Integrates external readers to the rss feeds and the iCal calendars.

[platal.git] / upgrade / 0.9.10 / 00_geoloc.sql

CREATE TABLE `geoloc_city_in_maps` (\r
  `city_id` int(11) NOT NULL default '0',\r
  `map_id` int(11) NOT NULL default '0',\r
  `infos` set('smallest') NOT NULL default '',\r
   PRIMARY KEY  (`map_id`,`infos`,`city_id`)\r
);\r
insert into admin_a VALUES (11, "Dynamap", "admin/geoloc_dynamap.php", 10);\r
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
CREATE TABLE `geoloc_maps` (\r
	`map_id` int(11) NOT NULL default '0',\r
  `name` varchar(50) NOT NULL default '',\r
  `x` double NOT NULL default '0',\r
  `y` double NOT NULL default '0',\r
  `width` double NOT NULL default '0',\r
  `height` double NOT NULL default '0',\r
  `xclip` float NOT NULL default '0',\r
  `yclip` float NOT NULL default '0',\r
  `scale` int(11) NOT NULL default '1',\r
  `parent` int(11) default NULL,\r
  `path` varchar(65) NOT NULL default '',\r
  PRIMARY KEY  (`map_id`),\r
  KEY `parent` (`parent`),\r
  KEY `path` (`path`)\r
	);\r