Project

General

Profile

« Previous | Next » 

Revision 3216

schemas/vegbien.sql: locationevent: Made location_id required because every locationevent should have a location, even one with no locationdeterminations. This also avoids the creation of a parent locationevent when subplots are not being used.

View differences:

inputs/CTFS/test/import.organisms.out.ref
1
Inserted 43 new rows into database
1
Inserted 41 new rows into database
schemas/vegbien.my.sql
773 773
    locationevent_id int(11) NOT NULL,
774 774
    parent_id int(11),
775 775
    datasource_id int(11),
776
    location_id int(11),
776
    location_id int(11) NOT NULL,
777 777
    project_id int(11),
778 778
    authorlocationcode text,
779 779
    sourceaccessioncode text,
schemas/vegbien.sql
1080 1080
    locationevent_id integer NOT NULL,
1081 1081
    parent_id integer,
1082 1082
    datasource_id integer,
1083
    location_id integer,
1083
    location_id integer NOT NULL,
1084 1084
    project_id integer,
1085 1085
    authorlocationcode text,
1086 1086
    sourceaccessioncode text,

Also available in: Unified diff