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;
10 ALTER TABLE adresses
ADD cityid
INT DEFAULT NULL AFTER city
;
12 ALTER TABLE adresses
ADD INDEX(cityid
);
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`
),