Revision 6878
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.sql | ||
|---|---|---|
| 6586 | 6586 |
|
| 6587 | 6587 |
|
| 6588 | 6588 |
-- |
| 6589 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6590 |
-- |
|
| 6591 |
|
|
| 6592 |
CREATE UNIQUE INDEX trait_unique ON trait USING btree (taxonlabel_id, name, (COALESCE(value, '\N'::text)), (COALESCE(units, '\N'::text))); |
|
| 6593 |
|
|
| 6594 |
|
|
| 6595 |
-- |
|
| 6589 | 6596 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6590 | 6597 |
-- |
| 6591 | 6598 |
|
Also available in: Unified diff
schemas/vegbien.sql: trait: Added trait_unique unique index