Revision 1204
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 3391 | 3391 |
-- |
| 3392 | 3392 |
|
| 3393 | 3393 |
ALTER TABLE specimenreplicate |
| 3394 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, collectionnumber); |
|
| 3394 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, verbatimcollectorname, collectionnumber);
|
|
| 3395 | 3395 |
|
| 3396 | 3396 |
|
| 3397 | 3397 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 3793 | 3793 |
-- |
| 3794 | 3794 |
|
| 3795 | 3795 |
ALTER TABLE ONLY specimenreplicate |
| 3796 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, collectionnumber); |
|
| 3796 |
ADD CONSTRAINT specimenreplicate_unique_collectionnumber UNIQUE (datasource_id, verbatimcollectorname, collectionnumber);
|
|
| 3797 | 3797 |
|
| 3798 | 3798 |
|
| 3799 | 3799 |
-- |
Also available in: Unified diff
vegbien.sql: Changed specimenreplicate_unique_collectionnumber constraint to include verbatimcollectorname because collection number is assigned by collector