Revision 6030
Added by Aaron Marcuse-Kubitza over 11 years ago
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