Revision 7370
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5995 | 5995 |
|
| 5996 | 5996 |
|
| 5997 | 5997 |
-- |
| 5998 |
-- Name: taxondetermination_single_accepted_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5999 |
-- |
|
| 6000 |
|
|
| 6001 |
|
|
| 6002 |
|
|
| 6003 |
|
|
| 6004 |
-- |
|
| 5998 | 6005 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5999 | 6006 |
-- |
| 6000 | 6007 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 7172 | 7172 |
|
| 7173 | 7173 |
|
| 7174 | 7174 |
-- |
| 7175 |
-- Name: taxondetermination_single_accepted_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 7176 |
-- |
|
| 7177 |
|
|
| 7178 |
CREATE UNIQUE INDEX taxondetermination_single_accepted_determination ON taxondetermination USING btree (taxonoccurrence_id) WHERE (determinationtype = 'accepted'::text); |
|
| 7179 |
|
|
| 7180 |
|
|
| 7181 |
-- |
|
| 7175 | 7182 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 7176 | 7183 |
-- |
| 7177 | 7184 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added taxondetermination_single_accepted_determination unique index to facilitate joining on the accepted determination