Revision 1204
Added by Aaron Marcuse-Kubitza almost 13 years ago
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 |
-- |
Also available in: Unified diff
vegbien.sql: Changed specimenreplicate_unique_collectionnumber constraint to include verbatimcollectorname because collection number is assigned by collector