Revision 6419
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 5123 | 5123 |
|
| 5124 | 5124 |
|
| 5125 | 5125 |
-- |
| 5126 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5127 |
-- |
|
| 5128 |
|
|
| 5129 |
|
|
| 5130 |
|
|
| 5131 |
|
|
| 5132 |
-- |
|
| 5126 | 5133 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5127 | 5134 |
-- |
| 5128 | 5135 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 6120 | 6120 |
|
| 6121 | 6121 |
|
| 6122 | 6122 |
-- |
| 6123 |
-- Name: taxondetermination_single_current_determination; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 6124 |
-- |
|
| 6125 |
|
|
| 6126 |
CREATE UNIQUE INDEX taxondetermination_single_current_determination ON taxondetermination USING btree (taxonoccurrence_id) WHERE iscurrent; |
|
| 6127 |
|
|
| 6128 |
|
|
| 6129 |
-- |
|
| 6123 | 6130 |
-- Name: taxondetermination_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6124 | 6131 |
-- |
| 6125 | 6132 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxondetermination: Added unique index to ensure that there is only one current determination for each taxonoccurrence