Revision 13915
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: - |
|
| 6739 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: -
|
|
| 6740 | 6740 |
-- |
| 6741 | 6741 |
|
| 6742 | 6742 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 9575 | 9575 |
|
| 9576 | 9576 |
|
| 9577 | 9577 |
-- |
| 9578 |
-- Name: iucn_red_list; Type: VIEW; Schema: public; Owner: - |
|
| 9578 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: -
|
|
| 9579 | 9579 |
-- |
| 9580 | 9580 |
|
| 9581 |
CREATE VIEW iucn_red_list AS |
|
| 9581 |
CREATE VIEW iucn_red_list_view AS
|
|
| 9582 | 9582 |
SELECT "ValidMatchedTaxon".accepted_family, |
| 9583 | 9583 |
"ValidMatchedTaxon".accepted_species_binomial |
| 9584 | 9584 |
FROM (taxonlabel |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 9575 | 9575 |
|
| 9576 | 9576 |
|
| 9577 | 9577 |
-- |
| 9578 |
-- Name: iucn_red_list; Type: VIEW; Schema: public; Owner: - |
|
| 9578 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: -
|
|
| 9579 | 9579 |
-- |
| 9580 | 9580 |
|
| 9581 |
CREATE VIEW iucn_red_list AS |
|
| 9581 |
CREATE VIEW iucn_red_list_view AS
|
|
| 9582 | 9582 |
SELECT "ValidMatchedTaxon".accepted_family, |
| 9583 | 9583 |
"ValidMatchedTaxon".accepted_species_binomial |
| 9584 | 9584 |
FROM (taxonlabel |
Also available in: Unified diff
schemas/public_.sql: iucn_red_list: renamed to iucn_red_list_view since this will be materialized