1CREATE TABLE `geodb_coordinates` ( 2 `loc_id` int(11) NOT NULL default '0', 3 `lon` double default NULL, 4 `lat` double default NULL, 5 `sin_lon` double default NULL, 6 `sin_lat` double default NULL, 7 `cos_lon` double default NULL, 8 `cos_lat` double default NULL, 9 `coord_type` int(11) NOT NULL default '0', 10 `coord_subtype` int(11) default NULL, 11 `valid_since` date default NULL, 12 `date_type_since` int(11) default NULL, 13 `valid_until` date NOT NULL default '0000-00-00', 14 `date_type_until` int(11) NOT NULL default '0', 15 KEY `coord_loc_id_idx` (`loc_id`), 16 KEY `coord_lon_idx` (`lon`), 17 KEY `coord_lat_idx` (`lat`), 18 KEY `coord_slon_idx` (`sin_lon`), 19 KEY `coord_slat_idx` (`sin_lat`), 20 KEY `coord_clon_idx` (`cos_lon`), 21 KEY `coord_clat_idx` (`cos_lat`), 22 KEY `coord_type_idx` (`coord_type`), 23 KEY `coord_stype_idx` (`coord_subtype`), 24 KEY `coord_since_idx` (`valid_since`), 25 KEY `coord_until_idx` (`valid_until`) 26) ENGINE=InnoDB DEFAULT CHARSET=latin1