Revision 582
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 1 | 1 |
CREATE TABLE location |
| 2 | 2 |
( |
| 3 | 3 |
location_id serial NOT NULL, |
| 4 |
authorlocationcode character varying(30) NOT NULL DEFAULT ''::character varying,
|
|
| 4 |
authorlocationcode character varying(30), |
|
| 5 | 5 |
reference_id integer, |
| 6 | 6 |
parent_id integer, |
| 7 |
reallatitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 8 |
reallongitude double precision NOT NULL DEFAULT 'NaN'::double precision,
|
|
| 7 |
reallatitude double precision, |
|
| 8 |
reallongitude double precision, |
|
| 9 | 9 |
locationaccuracy double precision, |
| 10 | 10 |
confidentialitystatus integer NOT NULL DEFAULT 0, |
| 11 | 11 |
confidentialityreason character varying(200), |
Also available in: Unified diff
vegbien.sql: Do location duplicate elimination independently on code or lat/long, allowing duplicate entries with NULLs to exist when a location is incompletely specified