Revision 3734
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3817 | 3817 |
|
| 3818 | 3818 |
|
| 3819 | 3819 |
-- |
| 3820 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3820 |
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3821 | 3821 |
-- |
| 3822 | 3822 |
|
| 3823 | 3823 |
|
| 3824 | 3824 |
|
| 3825 | 3825 |
|
| 3826 | 3826 |
-- |
| 3827 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3827 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3828 | 3828 |
-- |
| 3829 | 3829 |
|
| 3830 | 3830 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4363 | 4363 |
|
| 4364 | 4364 |
|
| 4365 | 4365 |
-- |
| 4366 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4366 |
-- Name: specimenreplicate_plantobservation_1_to_1; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4367 | 4367 |
-- |
| 4368 | 4368 |
|
| 4369 |
CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (datasource_id, (COALESCE(institution_id, 2147483647)), (COALESCE(collectioncode_dwc, '\\N'::text)), (COALESCE(catalognumber_dwc, '\\N'::text))) WHERE ((catalognumber_dwc IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
| 4369 |
CREATE UNIQUE INDEX specimenreplicate_plantobservation_1_to_1 ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (plantobservation_id IS NOT NULL);
|
|
| 4370 | 4370 |
|
| 4371 | 4371 |
|
| 4372 | 4372 |
-- |
| 4373 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4373 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4374 | 4374 |
-- |
| 4375 | 4375 |
|
| 4376 |
CREATE UNIQUE INDEX specimenreplicate_unique_plantobservation ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (plantobservation_id IS NOT NULL);
|
|
| 4376 |
CREATE UNIQUE INDEX specimenreplicate_unique_catalognumber ON specimenreplicate USING btree (datasource_id, (COALESCE(institution_id, 2147483647)), (COALESCE(collectioncode_dwc, '\\N'::text)), (COALESCE(catalognumber_dwc, '\\N'::text))) WHERE ((catalognumber_dwc IS NOT NULL) AND (sourceaccessioncode IS NULL));
|
|
| 4377 | 4377 |
|
| 4378 | 4378 |
|
| 4379 | 4379 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Renamed specimenreplicate_unique_plantobservation to specimenreplicate_plantobservation_1_to_1 to better reflect what it does