Revision 10472
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.pg.sql | ||
|---|---|---|
| 167 | 167 |
/*!40101 SET character_set_client = utf8 */; |
| 168 | 168 |
CREATE TABLE "geocoords" ( |
| 169 | 169 |
"id" text NOT NULL, |
| 170 |
"latitude_deg" text DEFAULT NULL, |
|
| 171 |
"longitude_deg" text DEFAULT NULL, |
|
| 172 |
PRIMARY KEY ("id")
|
|
| 170 |
"latitude_deg" text NOT NULL, |
|
| 171 |
"longitude_deg" text NOT NULL, |
|
| 172 |
PRIMARY KEY ("id"),
|
|
| 173 |
/*KEY "geocoords_unique" ("latitude_deg","longitude_deg")*/CHECK (true)
|
|
| 173 | 174 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'*/; |
| 174 | 175 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 175 | 176 |
|
| ... | ... | |
| 211 | 212 |
CREATE TABLE "geopath" ( |
| 212 | 213 |
"id" text NOT NULL, |
| 213 | 214 |
"continent" text DEFAULT NULL, |
| 214 |
"country" text DEFAULT NULL,
|
|
| 215 |
"country" text NOT NULL,
|
|
| 215 | 216 |
"state_province" text DEFAULT NULL, |
| 216 | 217 |
"county" text DEFAULT NULL, |
| 217 | 218 |
"municipality" text DEFAULT NULL, |
Also available in: Unified diff
bugfix: schemas/VegCore/VegCore.ERD.mwb: geopath: made country NOT NULL so that every geoplace (for input to geovalidation) has something on the geopath side. geocoords: made latitude_deg/longitude_deg NOT NULL so that every geoplace (for input to geovalidation) has something on the geocoords side. added geocoords_unique constraint since this is a global table with one entry for each lat/long.