1 CREATE TABLE `geoloc_city_in_maps`
(
2 `city_id`
int(11) NOT NULL default '0',
3 `map_id`
int(11) NOT NULL default '0',
4 `infos`
set('smallest') NOT NULL default '',
5 PRIMARY KEY (`map_id`
,`infos`
,`city_id`
)
7 insert into admin_a
VALUES (11, "Dynamap", "admin/geoloc_dynamap.php", 10);
8 UPDATE `adresses`
AS a
, `geoloc_city`
AS c
SET a.glng
= c.lon
/100000, a.glat
= c.lat
/100000 WHERE a.cityid
= c.
id;
9 CREATE TABLE `geoloc_maps`
(
10 `map_id`
int(11) NOT NULL default '0',
11 `
name`
varchar(50) NOT NULL default '',
12 `x`
double NOT NULL default '0',
13 `y`
double NOT NULL default '0',
14 `width`
double NOT NULL default '0',
15 `height`
double NOT NULL default '0',
16 `xclip`
float NOT NULL default '0',
17 `yclip`
float NOT NULL default '0',
18 `
scale`
int(11) NOT NULL default '1',
19 `parent`
int(11) default NULL,
20 `
path`
varchar(65) NOT NULL default '',
21 PRIMARY KEY (`map_id`
),
22 KEY `parent`
(`parent`
),