Project

General

Profile

« Previous | Next » 

Revision 6030

schemas/vegbien.sql: Added higher_plant_group_nodes lookup table

View differences:

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