Revision 3216
Added by Aaron Marcuse-Kubitza over 12 years ago
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
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.