Revision 580
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 1127 | 1127 |
authorlocationcode character varying(30) DEFAULT ''::character varying NOT NULL, |
| 1128 | 1128 |
reference_id integer, |
| 1129 | 1129 |
parent_id integer, |
| 1130 |
reallatitude double precision, |
|
| 1131 |
reallongitude double precision, |
|
| 1130 |
reallatitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1131 |
reallongitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1132 | 1132 |
locationaccuracy double precision, |
| 1133 | 1133 |
confidentialitystatus integer DEFAULT 0 NOT NULL, |
| 1134 | 1134 |
confidentialityreason character varying(200), |
| 1135 |
latitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1136 |
longitude double precision DEFAULT 'NaN'::double precision NOT NULL,
|
|
| 1135 |
publiclatitude double precision,
|
|
| 1136 |
publiclongitude double precision,
|
|
| 1137 | 1137 |
authore character varying(20), |
| 1138 | 1138 |
authorn character varying(20), |
| 1139 | 1139 |
authorzone character varying(20), |
Also available in: Unified diff
vegbien.sql: Renamed location.latitude and longitude to publiclatitude, publiclongitude to reflect that they are not the actual lat/long. Switched to requiring reallatitude/reallongitude.