0337d704 |
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 | ); |