Revision 6268
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 298 | 298 |
description text, |
| 299 | 299 |
geovalid int(1), |
| 300 | 300 |
distance_to_country_m double precision, |
| 301 |
distance_to_state_m double precision |
|
| 301 |
distance_to_state_m double precision, |
|
| 302 |
distance_to_county_m double precision |
|
| 302 | 303 |
); |
| 303 | 304 |
|
| 304 | 305 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 640 | 640 |
geovalid boolean, |
| 641 | 641 |
distance_to_country_m double precision, |
| 642 | 642 |
distance_to_state_m double precision, |
| 643 |
distance_to_county_m double precision, |
|
| 643 | 644 |
CONSTRAINT place_required_key CHECK ((((((coordinates_id IS NOT NULL) OR (continent IS NOT NULL)) OR (country IS NOT NULL)) OR (stateprovince IS NOT NULL)) OR (county IS NOT NULL))) |
| 644 | 645 |
); |
| 645 | 646 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added distance_to_county_m. Note that this can also be used to store latLongInCounty by mapping true to 0 and false to -1.