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