Revision 3209
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/CTFS/test/import.organisms.out.ref | ||
|---|---|---|
| 1 |
Inserted 45 new rows into database |
|
| 1 |
Inserted 43 new rows into database |
|
| schemas/vegbien.my.sql | ||
|---|---|---|
| 638 | 638 |
CREATE TABLE location ( |
| 639 | 639 |
location_id int(11) NOT NULL, |
| 640 | 640 |
parent_id int(11), |
| 641 |
datasource_id int(11), |
|
| 642 |
sourceaccessioncode text, |
|
| 641 |
datasource_id int(11) NOT NULL,
|
|
| 642 |
sourceaccessioncode text NOT NULL,
|
|
| 643 | 643 |
centerlatitude double precision, |
| 644 | 644 |
centerlongitude double precision, |
| 645 | 645 |
locationaccuracy double precision, |
| schemas/vegbien.sql | ||
|---|---|---|
| 935 | 935 |
CREATE TABLE location ( |
| 936 | 936 |
location_id integer NOT NULL, |
| 937 | 937 |
parent_id integer, |
| 938 |
datasource_id integer, |
|
| 939 |
sourceaccessioncode text, |
|
| 938 |
datasource_id integer NOT NULL,
|
|
| 939 |
sourceaccessioncode text NOT NULL,
|
|
| 940 | 940 |
centerlatitude double precision, |
| 941 | 941 |
centerlongitude double precision, |
| 942 | 942 |
locationaccuracy double precision, |
Also available in: Unified diff
schemas/vegbien.sql: location: Made datasource_id, sourceaccessioncode NOT NULL to ensure that all locations are uniquely identifiable by their datasource's unique key (sourceaccessioncode)