Changeset 7125 for extensions/GMaps/gmaps_install.class.inc.php

Timestamp:

Oct 7, 2010, 8:04:43 PM (14 years ago)

Author:

grum

Message:

Admin interface + Gallery integration finished

File:

• extensions/GMaps/gmaps_install.class.inc.php (modified) (2 diffs)

extensions/GMaps/gmaps_install.class.inc.php

@@ -48 +48 @@
 
       $tables_def=array(
-"CREATE TABLE   `".$this->tables['maps']."` (
+"CREATE TABLE `".$this->tables['maps']."` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `mapId` char(12) NOT NULL,
   `name` varchar(80) NOT NULL,
+  `displayType` char(2) NOT NULL,
+  `sizeMode` char(1) NOT NULL,
   `width` int(10) unsigned NOT NULL default '470',
   `height` int(10) unsigned NOT NULL default '210',
@@ -60 +61 @@
   `scaleControl` char(1) NOT NULL default 'y',
   `style` varchar(512) NOT NULL,
-  PRIMARY KEY  (`id`),
-  KEY `byMapId` (`mapId`)
+  PRIMARY KEY  (`id`)
 )",
-"CREATE TABLE   `".$this->tables['category_maps']."` (
+"CREATE TABLE `".$this->tables['category_maps']."` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `target` char(1) NOT NULL default 'P',
-  `category_id` smallint(5) unsigned NOT NULL,
-  `map_id` int(11) NOT NULL,
-  `sort` smallint(5) unsigned NOT NULL default '0',
+  `categoryId` smallint(5) unsigned NOT NULL,
+  `mapId` int(11) NOT NULL,
+  `imgSort` smallint(5) unsigned NOT NULL default '0',
   `applySubCat` char(1) NOT NULL default 'y',
   `kmlFileUrl` varchar(255) NOT NULL,
-  `marker` varchar(1) NOT NULL,
+  `icon` varchar(255) NOT NULL,
+  `title` varchar(200) NOT NULL,
   PRIMARY KEY  (`id`),
-  KEY `byTarget` USING BTREE (`target`,`category_id`,`sort`),
-  KEY `byCategorie` (`category_id`,`target`)
+  KEY `byCategorie` (`categoryId`,`mapId`)
+)",
+"CREATE TABLE `".$this->tables['cache']."` (
+  `userId` smallint(5) NOT NULL,
+  `requestId` timestamp NOT NULL default '0000-00-00 00:00:00',
+  `imageId` mediumint(8) NOT NULL,
+  `latitude` decimal(20,17) NOT NULL default '0.00000000000000000',
+  `longitude` decimal(20,17) NOT NULL default '0.00000000000000000',
+  `imageName` varchar(255) NOT NULL,
+  `imageTnFile` varchar(255) NOT NULL,
+  `imageCatsId` varchar(255) NOT NULL,
+  `imageCatsNames` varchar(255) NOT NULL,
+  `imageCatsPLink` varchar(255) NOT NULL,
+  PRIMARY KEY  USING BTREE (`userId`,`requestId`,`imageId`)
 )"
       );