Revision 6030
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added higher_plant_group_nodes lookup table