upgrade/0.9.10/00_geoloc.sql

   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`)
   6 );
   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`),
  23   KEY `path` (`path`)
  24         );