Revision 4071
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3894 | 3894 |
|
| 3895 | 3895 |
|
| 3896 | 3896 |
-- |
| 3897 |
-- Name: taxonoccurrence_locationevent_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3897 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3898 | 3898 |
-- |
| 3899 | 3899 |
|
| 3900 | 3900 |
|
| 3901 | 3901 |
|
| 3902 | 3902 |
|
| 3903 | 3903 |
-- |
| 3904 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3904 |
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3905 | 3905 |
-- |
| 3906 | 3906 |
|
| 3907 | 3907 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4426 | 4426 |
|
| 4427 | 4427 |
|
| 4428 | 4428 |
-- |
| 4429 |
-- Name: taxonoccurrence_locationevent_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4429 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4430 | 4430 |
-- |
| 4431 | 4431 |
|
| 4432 |
CREATE UNIQUE INDEX taxonoccurrence_locationevent_1_to_1 ON taxonoccurrence USING btree (locationevent_id) WHERE (sourceaccessioncode IS NULL);
|
|
| 4432 |
CREATE UNIQUE INDEX taxonoccurrence_unique_within_datasource ON taxonoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4433 | 4433 |
|
| 4434 | 4434 |
|
| 4435 | 4435 |
-- |
| 4436 |
-- Name: taxonoccurrence_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4436 |
-- Name: taxonoccurrence_unique_within_locationevent; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4437 | 4437 |
-- |
| 4438 | 4438 |
|
| 4439 |
CREATE UNIQUE INDEX taxonoccurrence_unique_within_datasource ON taxonoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4439 |
CREATE UNIQUE INDEX taxonoccurrence_unique_within_locationevent ON taxonoccurrence USING btree (locationevent_id, (COALESCE(authortaxoncode, '\\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
|
| 4440 | 4440 |
|
| 4441 | 4441 |
|
| 4442 | 4442 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: taxonoccurrence: Renamed taxonoccurrence_locationevent_1_to_1 to taxonoccurrence_unique_within_locationevent and added new authortaxoncode to it