Revision 13919
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 9575 | 9575 |
|
| 9576 | 9576 |
|
| 9577 | 9577 |
-- |
| 9578 |
-- Name: iucn_red_list; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 9579 |
-- |
|
| 9580 |
|
|
| 9581 |
CREATE TABLE iucn_red_list ( |
|
| 9582 |
accepted_family text NOT NULL, |
|
| 9583 |
accepted_species_binomial text NOT NULL |
|
| 9584 |
); |
|
| 9585 |
|
|
| 9586 |
|
|
| 9587 |
-- |
|
| 9578 | 9588 |
-- Name: iucn_red_list_view; Type: VIEW; Schema: public; Owner: - |
| 9579 | 9589 |
-- |
| 9580 | 9590 |
|
| ... | ... | |
| 14285 | 14295 |
|
| 14286 | 14296 |
|
| 14287 | 14297 |
-- |
| 14298 |
-- Data for Name: iucn_red_list; Type: TABLE DATA; Schema: public; Owner: - |
|
| 14299 |
-- |
|
| 14300 |
|
|
| 14301 |
|
|
| 14302 |
|
|
| 14303 |
-- |
|
| 14288 | 14304 |
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: - |
| 14289 | 14305 |
-- |
| 14290 | 14306 |
|
| ... | ... | |
| 15299 | 15315 |
|
| 15300 | 15316 |
|
| 15301 | 15317 |
-- |
| 15318 |
-- Name: iucn_red_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 15319 |
-- |
|
| 15320 |
|
|
| 15321 |
ALTER TABLE ONLY iucn_red_list |
|
| 15322 |
ADD CONSTRAINT iucn_red_list_pkey PRIMARY KEY (accepted_family, accepted_species_binomial); |
|
| 15323 |
|
|
| 15324 |
|
|
| 15325 |
-- |
|
| 15302 | 15326 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 15303 | 15327 |
-- |
| 15304 | 15328 |
|
Also available in: Unified diff
schemas/public_.sql: added iucn_red_list, materialized from iucn_red_list_view