Revision 7369
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6002 | 6002 |
|
| 6003 | 6003 |
|
| 6004 | 6004 |
-- |
| 6005 |
-- Name: taxondetermination_single_matched_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6006 |
-- |
|
| 6007 |
|
|
| 6008 |
|
|
| 6009 |
|
|
| 6010 |
|
|
| 6011 |
-- |
|
| 6005 | 6012 |
-- Name: taxondetermination_source_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6006 | 6013 |
-- |
| 6007 | 6014 |
|
| schemas/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