Revision 9414
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 359 | 359 |
stateprovince varchar(255), |
| 360 | 360 |
county varchar(255), |
| 361 | 361 |
description varchar(255), |
| 362 |
geovalid int(1), |
|
| 362 |
geovalid int(1) DEFAULT false NOT NULL,
|
|
| 363 | 363 |
distance_to_country_m double precision, |
| 364 | 364 |
distance_to_state_m double precision, |
| 365 | 365 |
distance_to_county_m double precision |
| schemas/vegbien.sql | ||
|---|---|---|
| 784 | 784 |
stateprovince text, |
| 785 | 785 |
county text, |
| 786 | 786 |
description text, |
| 787 |
geovalid boolean, |
|
| 787 |
geovalid boolean DEFAULT false NOT NULL,
|
|
| 788 | 788 |
distance_to_country_m double precision, |
| 789 | 789 |
distance_to_state_m double precision, |
| 790 | 790 |
distance_to_county_m double precision, |
Also available in: Unified diff
schemas/vegbien.sql: place.geovalid: require it to be NOT NULL so that it's always a 2-valued boolean (but default it to false since it's not a required field)