Revision 7369
Added by Aaron Marcuse-Kubitza almost 12 years ago
| vegbien.sql | ||
|---|---|---|
| 7179 | 7179 |
|
| 7180 | 7180 |
|
| 7181 | 7181 |
-- |
| 7182 |
-- Name: taxondetermination_single_matched_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7183 |
-- |
|
| 7184 |
|
|
| 7185 |
CREATE UNIQUE INDEX taxondetermination_single_matched_determination ON taxondetermination USING btree (taxonoccurrence_id) WHERE (determinationtype = 'matched'::text); |
|
| 7186 |
|
|
| 7187 |
|
|
| 7188 |
-- |
|
| 7182 | 7189 |
-- Name: taxondetermination_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7183 | 7190 |
-- |
| 7184 | 7191 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added taxondetermination_single_matched_determination unique index to facilitate joining on the matched determination