Revision 6883
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5477 | 5477 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5478 | 5478 |
-- |
| 5479 | 5479 |
|
| 5480 |
CREATE UNIQUE INDEX trait_unique ON trait (taxonoccurrence_id, name); |
|
| 5480 | 5481 |
|
| 5481 | 5482 |
|
| 5482 |
|
|
| 5483 | 5483 |
-- |
| 5484 | 5484 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5485 | 5485 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 6589 | 6589 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6590 | 6590 |
-- |
| 6591 | 6591 |
|
| 6592 |
CREATE UNIQUE INDEX trait_unique ON trait USING btree (taxonoccurrence_id, name, (COALESCE(value, '\N'::text)), (COALESCE(units, '\N'::text)));
|
|
| 6592 |
CREATE UNIQUE INDEX trait_unique ON trait USING btree (taxonoccurrence_id, name); |
|
| 6593 | 6593 |
|
| 6594 | 6594 |
|
| 6595 | 6595 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: trait: trait_unique: Removed value and units because there should only be one value of a trait for each taxonoccurrence