Revision 6246
Added by Aaron Marcuse-Kubitza over 11 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1984 | 1984 |
-- |
| 1985 | 1985 |
|
| 1986 | 1986 |
CREATE TABLE higher_plant_group_nodes ( |
| 1987 |
higher_plant_group text NOT NULL,
|
|
| 1987 |
higher_plant_group text, |
|
| 1988 | 1988 |
node_name text NOT NULL |
| 1989 | 1989 |
); |
| 1990 | 1990 |
|
| ... | ... | |
| 4362 | 4362 |
|
| 4363 | 4363 |
|
| 4364 | 4364 |
-- |
| 4365 |
-- Name: higher_plant_group_node_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4366 |
-- |
|
| 4367 |
|
|
| 4368 |
ALTER TABLE higher_plant_group_nodes |
|
| 4369 |
ADD CONSTRAINT higher_plant_group_node_pkey PRIMARY KEY (higher_plant_group, node_name); |
|
| 4370 |
|
|
| 4371 |
|
|
| 4372 |
-- |
|
| 4373 | 4365 |
-- Name: location_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4374 | 4366 |
-- |
| 4375 | 4367 |
|
| ... | ... | |
| 4864 | 4856 |
|
| 4865 | 4857 |
|
| 4866 | 4858 |
-- |
| 4859 |
-- Name: higher_plant_group_nodes_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4860 |
-- |
|
| 4861 |
|
|
| 4862 |
|
|
| 4863 |
|
|
| 4864 |
|
|
| 4865 |
-- |
|
| 4867 | 4866 |
-- Name: location_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4868 | 4867 |
-- |
| 4869 | 4868 |
|
Also available in: Unified diff
schemas/vegbien.sql: higher_plant_group_nodes: Allow NULL values for higher_plant_group, to allow mapping all remaining families to NULL in family_higher_plant_group