Revision 10472
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 165 | 165 |
/*!40101 SET character_set_client = utf8 */; |
| 166 | 166 |
CREATE TABLE `geocoords` ( |
| 167 | 167 |
`id` varbinary(767) NOT NULL, |
| 168 |
`latitude_deg` varbinary(767) DEFAULT NULL, |
|
| 169 |
`longitude_deg` varbinary(767) DEFAULT NULL, |
|
| 170 |
PRIMARY KEY (`id`) |
|
| 168 |
`latitude_deg` varbinary(767) NOT NULL, |
|
| 169 |
`longitude_deg` varbinary(767) NOT NULL, |
|
| 170 |
PRIMARY KEY (`id`), |
|
| 171 |
KEY `geocoords_unique` (`latitude_deg`,`longitude_deg`) |
|
| 171 | 172 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A numerically-defined point'; |
| 172 | 173 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 173 | 174 |
|
| ... | ... | |
| 209 | 210 |
CREATE TABLE `geopath` ( |
| 210 | 211 |
`id` varbinary(767) NOT NULL, |
| 211 | 212 |
`continent` varbinary(767) DEFAULT NULL, |
| 212 |
`country` varbinary(767) DEFAULT NULL,
|
|
| 213 |
`country` varbinary(767) NOT NULL,
|
|
| 213 | 214 |
`state_province` varbinary(767) DEFAULT NULL, |
| 214 | 215 |
`county` varbinary(767) DEFAULT NULL, |
| 215 | 216 |
`municipality` varbinary(767) 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.