| 1 | ALTER TABLE adresses |
| 2 | CHANGE ville city VARCHAR(80) DEFAULT '' NOT NULL, |
| 3 | CHANGE cp postcode VARCHAR(20) DEFAULT '' NOT NULL, |
| 4 | CHANGE pays country VARCHAR(2) DEFAULT '00' NOT NULL; |
| 5 | ALTER TABLE entreprises |
| 6 | CHANGE ville city VARCHAR(80) DEFAULT '' NOT NULL, |
| 7 | CHANGE cp postcode VARCHAR(20) DEFAULT '' NOT NULL, |
| 8 | CHANGE pays country VARCHAR(2) DEFAULT '00' NOT NULL; |
| 9 | |
| 10 | ALTER TABLE adresses ADD cityid INT DEFAULT NULL AFTER city; |
| 11 | |
| 12 | ALTER TABLE adresses ADD INDEX(cityid); |
| 13 | |
| 14 | CREATE TABLE `geoloc_city` ( |
| 15 | `id` int(11) NOT NULL default '0', |
| 16 | `alias` smallint(6) NOT NULL default '0', |
| 17 | `name` varchar(200) NOT NULL default '', |
| 18 | `search_name` varchar(200) NOT NULL default '', |
| 19 | `prefix` varchar(30) NOT NULL default '', |
| 20 | `lat` int(11) NOT NULL default '0', |
| 21 | `lon` int(11) NOT NULL default '0', |
| 22 | `country` char(2) NOT NULL default '', |
| 23 | `region` char(2) NOT NULL default '', |
| 24 | `subregion` varchar(200) NOT NULL default '', |
| 25 | `postcode` varchar(8) NOT NULL default '', |
| 26 | `level` tinyint(4) NOT NULL default '5', |
| 27 | `population` int(11) NOT NULL default '0', |
| 28 | `x` float NOT NULL default '0', |
| 29 | `y` float NOT NULL default '0', |
| 30 | `z` float NOT NULL default '0', |
| 31 | PRIMARY KEY (`id`,`alias`), |
| 32 | KEY `famous` (`level`,`search_name`), |
| 33 | KEY `name` (`country`,`search_name`), |
| 34 | KEY `postcode` (`country`,`postcode`), |
| 35 | KEY `lat` (`lat`), |
| 36 | KEY `lon` (`lon`) |
| 37 | ); |