Revision 6030
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1965 | 1965 |
|
| 1966 | 1966 |
|
| 1967 | 1967 |
-- |
| 1968 |
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 1969 |
-- |
|
| 1970 |
|
|
| 1971 |
CREATE TABLE higher_plant_group_nodes ( |
|
| 1972 |
higher_plant_group text NOT NULL, |
|
| 1973 |
node_name text NOT NULL |
|
| 1974 |
); |
|
| 1975 |
|
|
| 1976 |
|
|
| 1977 |
-- |
|
| 1968 | 1978 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 1969 | 1979 |
-- |
| 1970 | 1980 |
|
| ... | ... | |
| 3887 | 3897 |
|
| 3888 | 3898 |
|
| 3889 | 3899 |
-- |
| 3900 |
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: - |
|
| 3901 |
-- |
|
| 3902 |
|
|
| 3903 |
|
|
| 3904 |
|
|
| 3905 |
|
|
| 3906 |
-- |
|
| 3890 | 3907 |
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: - |
| 3891 | 3908 |
-- |
| 3892 | 3909 |
|
| ... | ... | |
| 4370 | 4387 |
|
| 4371 | 4388 |
|
| 4372 | 4389 |
-- |
| 4390 |
-- Name: higher_plant_group_node_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4391 |
-- |
|
| 4392 |
|
|
| 4393 |
ALTER TABLE higher_plant_group_nodes |
|
| 4394 |
ADD CONSTRAINT higher_plant_group_node_pkey PRIMARY KEY (higher_plant_group, node_name); |
|
| 4395 |
|
|
| 4396 |
|
|
| 4397 |
-- |
|
| 4373 | 4398 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4374 | 4399 |
-- |
| 4375 | 4400 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2677 | 2677 |
|
| 2678 | 2678 |
|
| 2679 | 2679 |
-- |
| 2680 |
-- Name: higher_plant_group_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
| 2681 |
-- |
|
| 2682 |
|
|
| 2683 |
CREATE TABLE higher_plant_group_nodes ( |
|
| 2684 |
higher_plant_group higher_plant_group NOT NULL, |
|
| 2685 |
node_name text NOT NULL |
|
| 2686 |
); |
|
| 2687 |
|
|
| 2688 |
|
|
| 2689 |
-- |
|
| 2680 | 2690 |
-- Name: location_location_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
| 2681 | 2691 |
-- |
| 2682 | 2692 |
|
| ... | ... | |
| 4841 | 4851 |
|
| 4842 | 4852 |
|
| 4843 | 4853 |
-- |
| 4854 |
-- Data for Name: higher_plant_group_nodes; Type: TABLE DATA; Schema: public; Owner: - |
|
| 4855 |
-- |
|
| 4856 |
|
|
| 4857 |
COPY higher_plant_group_nodes (higher_plant_group, node_name) FROM stdin; |
|
| 4858 |
bryophytes Anthocerotophyta |
|
| 4859 |
bryophytes Marchantiophyta |
|
| 4860 |
bryophytes Bryophyta |
|
| 4861 |
ferns and allies Anthocerotophyta |
|
| 4862 |
ferns and allies Marchantiophyta |
|
| 4863 |
ferns and allies Bryophyta |
|
| 4864 |
ferns and allies Moniliformopses |
|
| 4865 |
flowering plants Magnoliophyta |
|
| 4866 |
gymnosperms (conifers) Coniferophyta |
|
| 4867 |
gymnosperms (non-conifer) Cycadophyta |
|
| 4868 |
gymnosperms (non-conifer) Ginkgophyta |
|
| 4869 |
gymnosperms (non-conifer) Gnetophyta |
|
| 4870 |
\. |
|
| 4871 |
|
|
| 4872 |
|
|
| 4873 |
-- |
|
| 4844 | 4874 |
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: - |
| 4845 | 4875 |
-- |
| 4846 | 4876 |
|
| ... | ... | |
| 5369 | 5399 |
|
| 5370 | 5400 |
|
| 5371 | 5401 |
-- |
| 5402 |
-- Name: higher_plant_group_node_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 5403 |
-- |
|
| 5404 |
|
|
| 5405 |
ALTER TABLE ONLY higher_plant_group_nodes |
|
| 5406 |
ADD CONSTRAINT higher_plant_group_node_pkey PRIMARY KEY (higher_plant_group, node_name); |
|
| 5407 |
|
|
| 5408 |
|
|
| 5409 |
-- |
|
| 5372 | 5410 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 5373 | 5411 |
-- |
| 5374 | 5412 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added higher_plant_group_nodes lookup table