Revision 13914
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 6736 | 6736 |
|
| 6737 | 6737 |
|
| 6738 | 6738 |
-- |
| 6739 |
-- Name: iucn_red_list; Type: VIEW; Schema: public; Owner: - |
|
| 6740 |
-- |
|
| 6741 |
|
|
| 6742 |
|
|
| 6743 |
|
|
| 6744 |
|
|
| 6745 |
-- |
|
| 6739 | 6746 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 6740 | 6747 |
-- |
| 6741 | 6748 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9575 | 9575 |
|
| 9576 | 9576 |
|
| 9577 | 9577 |
-- |
| 9578 |
-- Name: iucn_red_list; Type: VIEW; Schema: public; Owner: - |
|
| 9579 |
-- |
|
| 9580 |
|
|
| 9581 |
CREATE VIEW iucn_red_list AS |
|
| 9582 |
SELECT "ValidMatchedTaxon".accepted_family, |
|
| 9583 |
"ValidMatchedTaxon".accepted_species_binomial |
|
| 9584 |
FROM (taxonlabel |
|
| 9585 |
JOIN "TNRS"."ValidMatchedTaxon" ON (("ValidMatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))
|
|
| 9586 |
WHERE (taxonlabel.source_id = source_by_shortname('IUCN'::text));
|
|
| 9587 |
|
|
| 9588 |
|
|
| 9589 |
-- |
|
| 9578 | 9590 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 9579 | 9591 |
-- |
| 9580 | 9592 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9575 | 9575 |
|
| 9576 | 9576 |
|
| 9577 | 9577 |
-- |
| 9578 |
-- Name: iucn_red_list; Type: VIEW; Schema: public; Owner: - |
|
| 9579 |
-- |
|
| 9580 |
|
|
| 9581 |
CREATE VIEW iucn_red_list AS |
|
| 9582 |
SELECT "ValidMatchedTaxon".accepted_family, |
|
| 9583 |
"ValidMatchedTaxon".accepted_species_binomial |
|
| 9584 |
FROM (taxonlabel |
|
| 9585 |
JOIN "TNRS"."ValidMatchedTaxon" ON (("ValidMatchedTaxon"."concatenatedScientificName" = taxonlabel.taxonomicname)))
|
|
| 9586 |
WHERE (taxonlabel.source_id = source_by_shortname('IUCN'::text));
|
|
| 9587 |
|
|
| 9588 |
|
|
| 9589 |
-- |
|
| 9578 | 9590 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 9579 | 9591 |
-- |
| 9580 | 9592 |
|
Also available in: Unified diff
schemas/public_.sql: added iucn_red_list