Revision 1024
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 939 | 939 |
authorlocationcode text, |
| 940 | 940 |
reference_id int(11), |
| 941 | 941 |
parent_id int(11), |
| 942 |
reallatitude double precision,
|
|
| 943 |
reallongitude double precision,
|
|
| 942 |
centerlatitude double precision,
|
|
| 943 |
centerlongitude double precision,
|
|
| 944 | 944 |
locationaccuracy double precision, |
| 945 | 945 |
confidentialitystatus int(11) DEFAULT 0 NOT NULL, |
| 946 | 946 |
confidentialityreason text, |
| ... | ... | |
| 3934 | 3934 |
-- |
| 3935 | 3935 |
|
| 3936 | 3936 |
ALTER TABLE location |
| 3937 |
ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, reallatitude, reallongitude);
|
|
| 3937 |
ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, centerlatitude, centerlongitude);
|
|
| 3938 | 3938 |
|
| 3939 | 3939 |
|
| 3940 | 3940 |
-- |
Also available in: Unified diff
VegBIEN: Renamed location.reallatitude,reallongitude to centerlatitude,centerlongitude to reflect that it's now a value calculated from the centroid of the current locationdetermination