Revision 3728
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3825 | 3825 |
|
| 3826 | 3826 |
|
| 3827 | 3827 |
-- |
| 3828 |
-- Name: specimenreplicate_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3828 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3829 | 3829 |
-- |
| 3830 | 3830 |
|
| 3831 | 3831 |
|
| 3832 | 3832 |
|
| 3833 | 3833 |
|
| 3834 | 3834 |
-- |
| 3835 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3835 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3836 | 3836 |
-- |
| 3837 | 3837 |
|
| 3838 | 3838 |
|
| 3839 | 3839 |
|
| 3840 | 3840 |
|
| 3841 | 3841 |
-- |
| 3842 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3842 |
-- Name: specimenreplicate_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 3843 | 3843 |
-- |
| 3844 | 3844 |
|
| 3845 | 3845 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 4371 | 4371 |
|
| 4372 | 4372 |
|
| 4373 | 4373 |
-- |
| 4374 |
-- Name: specimenreplicate_unique_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4374 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4375 | 4375 |
-- |
| 4376 | 4376 |
|
| 4377 |
CREATE UNIQUE INDEX specimenreplicate_unique_accessioncode ON specimenreplicate USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4377 |
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));
|
|
| 4378 | 4378 |
|
| 4379 | 4379 |
|
| 4380 | 4380 |
-- |
| 4381 |
-- Name: specimenreplicate_unique_catalognumber; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4381 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4382 | 4382 |
-- |
| 4383 | 4383 |
|
| 4384 |
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));
|
|
| 4384 |
CREATE UNIQUE INDEX specimenreplicate_unique_plantobservation ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (plantobservation_id IS NOT NULL);
|
|
| 4385 | 4385 |
|
| 4386 | 4386 |
|
| 4387 | 4387 |
-- |
| 4388 |
-- Name: specimenreplicate_unique_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4388 |
-- Name: specimenreplicate_unique_within_datasource; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
| 4389 | 4389 |
-- |
| 4390 | 4390 |
|
| 4391 |
CREATE UNIQUE INDEX specimenreplicate_unique_plantobservation ON specimenreplicate USING btree ((COALESCE(plantobservation_id, 2147483647))) WHERE (plantobservation_id IS NOT NULL);
|
|
| 4391 |
CREATE UNIQUE INDEX specimenreplicate_unique_within_datasource ON specimenreplicate USING btree (datasource_id, (COALESCE(sourceaccessioncode, '\\N'::text))) WHERE (sourceaccessioncode IS NOT NULL);
|
|
| 4392 | 4392 |
|
| 4393 | 4393 |
|
| 4394 | 4394 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: specimenreplicate: Renamed specimenreplicate_unique_accessioncode to specimenreplicate_unique_within_datasource to better reflect what it does