Revision 3668
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 4135 | 4135 |
-- Name: aggregateoccurrence_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4136 | 4136 |
-- |
| 4137 | 4137 |
|
| 4138 |
CREATE UNIQUE INDEX aggregateoccurrence_unique_datasource ON aggregateoccurrence USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4138 |
CREATE UNIQUE INDEX aggregateoccurrence_unique_datasource ON aggregateoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4139 | 4139 |
|
| 4140 | 4140 |
|
| 4141 | 4141 |
-- |
| ... | ... | |
| 4212 | 4212 |
-- Name: locationevent_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4213 | 4213 |
-- |
| 4214 | 4214 |
|
| 4215 |
CREATE UNIQUE INDEX locationevent_unique_datasource ON locationevent USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4215 |
CREATE UNIQUE INDEX locationevent_unique_datasource ON locationevent USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4216 | 4216 |
|
| 4217 | 4217 |
|
| 4218 | 4218 |
-- |
| ... | ... | |
| 4317 | 4317 |
-- Name: plantobservation_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4318 | 4318 |
-- |
| 4319 | 4319 |
|
| 4320 |
CREATE UNIQUE INDEX plantobservation_unique_datasource ON plantobservation USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4320 |
CREATE UNIQUE INDEX plantobservation_unique_datasource ON plantobservation USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4321 | 4321 |
|
| 4322 | 4322 |
|
| 4323 | 4323 |
-- |
| ... | ... | |
| 4338 | 4338 |
-- Name: project_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4339 | 4339 |
-- |
| 4340 | 4340 |
|
| 4341 |
CREATE UNIQUE INDEX project_unique_datasource ON project USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4341 |
CREATE UNIQUE INDEX project_unique_datasource ON project USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4342 | 4342 |
|
| 4343 | 4343 |
|
| 4344 | 4344 |
-- |
| ... | ... | |
| 4394 | 4394 |
-- Name: stemobservation_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4395 | 4395 |
-- |
| 4396 | 4396 |
|
| 4397 |
CREATE UNIQUE INDEX stemobservation_unique_datasource ON stemobservation USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4397 |
CREATE UNIQUE INDEX stemobservation_unique_datasource ON stemobservation USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4398 | 4398 |
|
| 4399 | 4399 |
|
| 4400 | 4400 |
-- |
| ... | ... | |
| 4422 | 4422 |
-- Name: taxonoccurrence_unique_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4423 | 4423 |
-- |
| 4424 | 4424 |
|
| 4425 |
CREATE UNIQUE INDEX taxonoccurrence_unique_datasource ON taxonoccurrence USING btree ((COALESCE(datasource_id, 2147483647)), (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE ((datasource_id IS NOT NULL) AND (sourceaccessioncode IS NOT NULL));
|
|
| 4425 |
CREATE UNIQUE INDEX taxonoccurrence_unique_datasource ON taxonoccurrence USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4426 | 4426 |
|
| 4427 | 4427 |
|
| 4428 | 4428 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: *_unique_datasource UNIQUE INDEXes: Removed COALESCE from datasource_id and datasource_id IS NOT NULL filter, because datasource_id is now always NOT NULL