56670b6a |
1 | CREATE TABLE `geoloc_city_in_maps` (\r |
2 | `city_id` int(11) NOT NULL default '0',\r |
3 | `map_id` int(11) NOT NULL default '0',\r |
4 | `infos` set('smallest') NOT NULL default '',\r |
5 | PRIMARY KEY (`map_id`,`infos`,`city_id`)\r |
6 | );\r |
7 | insert into admin_a VALUES (11, "Dynamap", "admin/geoloc_dynamap.php", 10);\r |
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;\r |
9 | CREATE TABLE `geoloc_maps` (\r |
10 | `map_id` int(11) NOT NULL default '0',\r |
11 | `name` varchar(50) NOT NULL default '',\r |
12 | `x` double NOT NULL default '0',\r |
13 | `y` double NOT NULL default '0',\r |
14 | `width` double NOT NULL default '0',\r |
15 | `height` double NOT NULL default '0',\r |
16 | `xclip` float NOT NULL default '0',\r |
17 | `yclip` float NOT NULL default '0',\r |
18 | `scale` int(11) NOT NULL default '1',\r |
19 | `parent` int(11) default NULL,\r |
20 | `path` varchar(65) NOT NULL default '',\r |
21 | PRIMARY KEY (`map_id`),\r |
22 | KEY `parent` (`parent`),\r |
23 | KEY `path` (`path`)\r |
24 | );\r |