Revision 7617
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 7159 | 7159 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7160 | 7160 |
-- |
| 7161 | 7161 |
|
| 7162 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, source_id, isoriginal, role, (COALESCE(party_id, 2147483647)), taxonverbatim_id); |
|
| 7162 |
CREATE UNIQUE INDEX taxondetermination_unique ON taxondetermination USING btree (taxonoccurrence_id, source_id, (COALESCE(determinationtype, '\N'::text)), isoriginal, role, (COALESCE(party_id, 2147483647)), taxonverbatim_id);
|
|
| 7163 | 7163 |
|
| 7164 | 7164 |
|
| 7165 | 7165 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: taxondetermination_unique: Added determinationtype so that when the matched and accepted determinations are the same, they still both get created rather than the second one being removed due to the unique constraint