Revision 3726
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2945 | 2945 |
|
| 2946 | 2946 |
|
| 2947 | 2947 |
-- |
| 2948 |
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 2949 |
-- |
|
| 2950 |
|
|
| 2951 |
ALTER TABLE aggregateoccurrence |
|
| 2952 |
ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode); |
|
| 2953 |
|
|
| 2954 |
|
|
| 2955 |
-- |
|
| 2956 | 2948 |
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 2957 | 2949 |
-- |
| 2958 | 2950 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3494 | 3494 |
|
| 3495 | 3495 |
|
| 3496 | 3496 |
-- |
| 3497 |
-- Name: aggregateoccurrence_unique_accessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3498 |
-- |
|
| 3499 |
|
|
| 3500 |
ALTER TABLE ONLY aggregateoccurrence |
|
| 3501 |
ADD CONSTRAINT aggregateoccurrence_unique_accessioncode UNIQUE (taxonoccurrence_id, sourceaccessioncode); |
|
| 3502 |
|
|
| 3503 |
|
|
| 3504 |
-- |
|
| 3505 | 3497 |
-- Name: classcontributor_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3506 | 3498 |
-- |
| 3507 | 3499 |
|
Also available in: Unified diff
schemas/vegbien.sql: aggregateoccurrence: Removed redundant aggregateoccurrence_unique_accessioncode unique constraint, which has been replaced by aggregateoccurrence_unique_within_taxonoccurrence