Revision 6878
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5474 | 5474 |
|
| 5475 | 5475 |
|
| 5476 | 5476 |
-- |
| 5477 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5478 |
-- |
|
| 5479 |
|
|
| 5480 |
|
|
| 5481 |
|
|
| 5482 |
|
|
| 5483 |
-- |
|
| 5477 | 5484 |
-- Name: userdefined_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5478 | 5485 |
-- |
| 5479 | 5486 |
|
| schemas/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