Revision 13926
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.my.sql | ||
|---|---|---|
| 3849 | 3849 |
|
| 3850 | 3850 |
|
| 3851 | 3851 |
-- |
| 3852 |
-- Name: iucn_red_list; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 3853 |
-- |
|
| 3854 |
|
|
| 3855 |
CREATE TABLE iucn_red_list ( |
|
| 3856 |
accepted_family varchar(255) NOT NULL, |
|
| 3857 |
accepted_species_binomial varchar(255) NOT NULL |
|
| 3858 |
); |
|
| 3859 |
|
|
| 3860 |
|
|
| 3861 |
-- |
|
| 3852 | 3862 |
-- Name: 2014-6-4.Iara_Lacher.reserve_prioritization; Type: VIEW; Schema: public; Owner: - |
| 3853 | 3863 |
-- |
| 3854 | 3864 |
|
| ... | ... | |
| 6743 | 6753 |
|
| 6744 | 6754 |
|
| 6745 | 6755 |
-- |
| 6746 |
-- Name: iucn_red_list; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 6747 |
-- |
|
| 6748 |
|
|
| 6749 |
CREATE TABLE iucn_red_list ( |
|
| 6750 |
accepted_family varchar(255) NOT NULL, |
|
| 6751 |
accepted_species_binomial varchar(255) NOT NULL |
|
| 6752 |
); |
|
| 6753 |
|
|
| 6754 |
|
|
| 6755 |
-- |
|
| 6756 | 6756 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: - |
| 6757 | 6757 |
-- |
| 6758 | 6758 |
|
Also available in: Unified diff
fix: schemas/public_.sql: 2014-6-4.Iara_Lacher.reserve_prioritization: is_threatened_iucn: generate this much faster by doing a LEFT JOIN, which can reuse the same in-memory hash index for every row