Revision 4190
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 4418 | 4418 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4419 | 4419 |
-- |
| 4420 | 4420 |
|
| 4421 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, role, (COALESCE(party_id, 2147483647)), plantconcept_id); |
|
| 4421 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, isoriginal, role, (COALESCE(party_id, 2147483647)), plantconcept_id);
|
|
| 4422 | 4422 |
|
| 4423 | 4423 |
|
| 4424 | 4424 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: taxondetermination_unique unique index: Added isoriginal so an "original" determination in the same row (as found in SALVIAS) will be seen as distinct from the scrubbed determination, even if they are to the same plant name