| 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 |