Revision 3732
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3097 | 3097 |
|
| 3098 | 3098 |
|
| 3099 | 3099 |
-- |
| 3100 |
-- Name: location_unique_sourceaccessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3101 |
-- |
|
| 3102 |
|
|
| 3103 |
ALTER TABLE location |
|
| 3104 |
ADD CONSTRAINT location_unique_sourceaccessioncode UNIQUE (datasource_id, sourceaccessioncode); |
|
| 3105 |
|
|
| 3106 |
|
|
| 3107 |
-- |
|
| 3108 | 3100 |
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3109 | 3101 |
-- |
| 3110 | 3102 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 3646 | 3646 |
|
| 3647 | 3647 |
|
| 3648 | 3648 |
-- |
| 3649 |
-- Name: location_unique_sourceaccessioncode; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 3650 |
-- |
|
| 3651 |
|
|
| 3652 |
ALTER TABLE ONLY location |
|
| 3653 |
ADD CONSTRAINT location_unique_sourceaccessioncode UNIQUE (datasource_id, sourceaccessioncode); |
|
| 3654 |
|
|
| 3655 |
|
|
| 3656 |
-- |
|
| 3657 | 3649 |
-- Name: location_unique_subplot_coords; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 3658 | 3650 |
-- |
| 3659 | 3651 |
|
Also available in: Unified diff
schemas/vegbien.sql: location: Removed redundant location_unique_sourceaccessioncode unique constraint, which has been replaced by location_unique_within_datasource