Revision 1024
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1103 | 1103 |
authorlocationcode text, |
| 1104 | 1104 |
reference_id integer, |
| 1105 | 1105 |
parent_id integer, |
| 1106 |
reallatitude double precision,
|
|
| 1107 |
reallongitude double precision,
|
|
| 1106 |
centerlatitude double precision,
|
|
| 1107 |
centerlongitude double precision,
|
|
| 1108 | 1108 |
locationaccuracy double precision, |
| 1109 | 1109 |
confidentialitystatus integer DEFAULT 0 NOT NULL, |
| 1110 | 1110 |
confidentialityreason text, |
| ... | ... | |
| 4403 | 4403 |
-- |
| 4404 | 4404 |
|
| 4405 | 4405 |
ALTER TABLE ONLY location |
| 4406 |
ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, reallatitude, reallongitude);
|
|
| 4406 |
ADD CONSTRAINT location_keys_coords UNIQUE (reference_id, centerlatitude, centerlongitude);
|
|
| 4407 | 4407 |
|
| 4408 | 4408 |
|
| 4409 | 4409 |
-- |
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