Revision 7370
Added by Aaron Marcuse-Kubitza almost 12 years ago
| 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