Revision 14450
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 8349 | 8349 |
|
| 8350 | 8350 |
|
| 8351 | 8351 |
-- |
| 8352 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
|
| 8353 |
-- |
|
| 8354 |
|
|
| 8355 |
|
|
| 8356 |
|
|
| 8357 |
|
|
| 8358 |
-- |
|
| 8359 | 8352 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
| 8360 | 8353 |
-- |
| 8361 | 8354 |
|
| ... | ... | |
| 16385 | 16378 |
|
| 16386 | 16379 |
|
| 16387 | 16380 |
-- |
| 16388 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
|
| 16389 |
-- |
|
| 16390 |
|
|
| 16391 |
|
|
| 16392 |
|
|
| 16393 |
|
|
| 16394 |
|
|
| 16395 |
|
|
| 16396 |
|
|
| 16397 |
-- |
|
| 16398 | 16381 |
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: - |
| 16399 | 16382 |
-- |
| 16400 | 16383 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 11636 | 11636 |
|
| 11637 | 11637 |
|
| 11638 | 11638 |
-- |
| 11639 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
|
| 11640 |
-- |
|
| 11641 |
|
|
| 11642 |
CREATE VIEW threatened_taxonlabel_view AS |
|
| 11643 |
SELECT DISTINCT accepted_taxonlabel_descendant.descendant_id AS taxonlabel_id |
|
| 11644 |
FROM ((taxonlabel datasource_taxonlabel |
|
| 11645 |
JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) |
|
| 11646 |
JOIN taxonlabel_relationship accepted_taxonlabel_descendant ON ((accepted_taxonlabel_descendant.ancestor_id = accepted_taxonlabel.taxonlabel_id))) |
|
| 11647 |
WHERE (((datasource_taxonlabel.source_id = ( SELECT source_by_shortname('IUCN'::text) AS source_by_shortname)) AND (datasource_taxonlabel.taxonomicname IS NOT NULL)) AND (accepted_taxonlabel.rank >= 'species'::taxonrank));
|
|
| 11648 |
|
|
| 11649 |
|
|
| 11650 |
-- |
|
| 11651 | 11639 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
| 11652 | 11640 |
-- |
| 11653 | 11641 |
|
| ... | ... | |
| 20501 | 20489 |
|
| 20502 | 20490 |
|
| 20503 | 20491 |
-- |
| 20504 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
|
| 20505 |
-- |
|
| 20506 |
|
|
| 20507 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM PUBLIC; |
|
| 20508 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM bien; |
|
| 20509 |
GRANT ALL ON TABLE threatened_taxonlabel_view TO bien; |
|
| 20510 |
GRANT SELECT ON TABLE threatened_taxonlabel_view TO bien_read; |
|
| 20511 |
|
|
| 20512 |
|
|
| 20513 |
-- |
|
| 20514 | 20492 |
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: - |
| 20515 | 20493 |
-- |
| 20516 | 20494 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 11636 | 11636 |
|
| 11637 | 11637 |
|
| 11638 | 11638 |
-- |
| 11639 |
-- Name: threatened_taxonlabel_view; Type: VIEW; Schema: public; Owner: - |
|
| 11640 |
-- |
|
| 11641 |
|
|
| 11642 |
CREATE VIEW threatened_taxonlabel_view AS |
|
| 11643 |
SELECT DISTINCT accepted_taxonlabel_descendant.descendant_id AS taxonlabel_id |
|
| 11644 |
FROM ((taxonlabel datasource_taxonlabel |
|
| 11645 |
JOIN taxonlabel accepted_taxonlabel ON ((accepted_taxonlabel.taxonlabel_id = datasource_taxonlabel.canon_label_id))) |
|
| 11646 |
JOIN taxonlabel_relationship accepted_taxonlabel_descendant ON ((accepted_taxonlabel_descendant.ancestor_id = accepted_taxonlabel.taxonlabel_id))) |
|
| 11647 |
WHERE (((datasource_taxonlabel.source_id = ( SELECT source_by_shortname('IUCN'::text) AS source_by_shortname)) AND (datasource_taxonlabel.taxonomicname IS NOT NULL)) AND (accepted_taxonlabel.rank >= 'species'::taxonrank));
|
|
| 11648 |
|
|
| 11649 |
|
|
| 11650 |
-- |
|
| 11651 | 11639 |
-- Name: tnrs_input_name; Type: VIEW; Schema: public; Owner: - |
| 11652 | 11640 |
-- |
| 11653 | 11641 |
|
| ... | ... | |
| 20501 | 20489 |
|
| 20502 | 20490 |
|
| 20503 | 20491 |
-- |
| 20504 |
-- Name: threatened_taxonlabel_view; Type: ACL; Schema: public; Owner: - |
|
| 20505 |
-- |
|
| 20506 |
|
|
| 20507 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM PUBLIC; |
|
| 20508 |
REVOKE ALL ON TABLE threatened_taxonlabel_view FROM bien; |
|
| 20509 |
GRANT ALL ON TABLE threatened_taxonlabel_view TO bien; |
|
| 20510 |
GRANT SELECT ON TABLE threatened_taxonlabel_view TO bien_read; |
|
| 20511 |
|
|
| 20512 |
|
|
| 20513 |
-- |
|
| 20514 | 20492 |
-- Name: tnrs_input_name; Type: ACL; Schema: public; Owner: - |
| 20515 | 20493 |
-- |
| 20516 | 20494 |
|
Also available in: Unified diff
schemas/public_.sql: removed no longer used threatened_taxonlabel_view. use iucn_red_list_view instead.