Project

General

Profile

« Previous | Next » 

Revision 1204

vegbien.sql: Changed specimenreplicate_unique_collectionnumber constraint to include verbatimcollectorname because collection number is assigned by collector

View differences:

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