Project

General

Profile

« Previous | Next » 

Revision 4462

Added by Aaron Marcuse-Kubitza over 12 years ago

schemas/vegbien.sql: locationevent: Made location_id optional when sourceaccessioncode is provided, since a sourceaccessioncode is globally unique and does not require a location to scope it

View differences:

schemas/vegbien.my.sql
333 333 
    datasource_id int(11) NOT NULL,
334 334 
    sourceaccessioncode text,
335 335 
    parent_id int(11),
336 
    location_id int(11) NOT NULL,
336 
    location_id int(11),
337 337 
    project_id int(11),
338 338 
    authoreventcode text,
339 339 
    previous_id int(11),
schemas/vegbien.sql
545 545 
    datasource_id integer NOT NULL,
546 546 
    sourceaccessioncode text,
547 547 
    parent_id integer,
548 
    location_id integer NOT NULL,
548 
    location_id integer,
549 549 
    project_id integer,
550 550 
    authoreventcode text,
551 551 
    previous_id integer,
......
616 616 
    toptaxon4name text,
617 617 
    toptaxon5name text,
618 618 
    numberoftaxa integer,
619 
    accessioncode text
619 
    accessioncode text,
620 
    CONSTRAINT locationevent_required_key CHECK (((sourceaccessioncode IS NOT NULL) OR (location_id IS NOT NULL)))
620 621 
);
621 622 

  		




  622
  623
  
    

  		












Also available in:  Unified diff