Revision 8600
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 214 | 214 |
-- ----------------------------------------------------- |
| 215 | 215 |
CREATE TABLE IF NOT EXISTS `coordinates` ( |
| 216 | 216 |
`id` TEXT NOT NULL , |
| 217 |
`latitude_deg` TEXT NULL , |
|
| 218 |
`longitude_deg` TEXT NULL , |
|
| 217 | 219 |
PRIMARY KEY (`id`) ) |
| 218 | 220 |
ENGINE = InnoDB |
| 219 | 221 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 1064 | 1066 |
`id` TEXT NOT NULL , |
| 1065 | 1067 |
`geovalid` TINYINT(1) NOT NULL , |
| 1066 | 1068 |
`lat_long_domain_valid` TINYINT(1) NOT NULL , |
| 1069 |
`lat_long_in_ranks` SET('hstore') NULL ,
|
|
| 1067 | 1070 |
PRIMARY KEY (`id`) , |
| 1068 | 1071 |
CONSTRAINT `fk_geovalidation_validatable_place1` |
| 1069 | 1072 |
FOREIGN KEY (`id` ) |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: coordinates: added latitude_deg, longitude_deg. geovalidation: added lat_long_in_ranks hstore.