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

Timestamp:

Nov 4, 2010, 1:42:14 AM (13 years ago)

Author:

grum

Message:

fix bug:2004 - Cache table becomes very huge
fix bug:2005 - Category map is not displayed when a [gmaps] map is inserted in category description

File:

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

extensions/GMaps/gmaps_install.class.inc.php

@@ -87 +87 @@
 )",
 "CREATE TABLE `".$this->tables['cache']."` (
+  `requestId` mediumint(8) UNSIGNED NOT NULL default '0',
+  `imageId` mediumint(8) NOT NULL,
+  `latitude` decimal(17,14) NOT NULL default '0',
+  `longitude` decimal(17,14) NOT NULL default '0',
+  PRIMARY KEY (`requestId`,`imageId`)
+)",
+"CREATE TABLE `".$this->tables['cache_id']."` (
+  `requestId` mediumint(8) UNSIGNED NOT NULL auto_increment,
   `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`)
+  `date` timestamp NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY (`requestId`)
 )",
 "CREATE TABLE `".$this->tables['kmlfiles']."` (
@@ -144 +144 @@
         case '01.01.00':
           $this->updateFrom_010100();
+        case '01.02.00':
+        case '01.02.01':
+        case '01.02.02':
+          $this->updateFrom_010202();
         default:
           // nothing to do...
@@ -218 +222 @@
     }
 
+    /**
+     * update from release 1.2.2
+     *
+     */
+    private function updateFrom_010202()
+    {
+      $sql="DROP TABLE ".$this->tables['cache'];
+      pwg_query($sql);
+
+      $tablesCreate=array(
+"CREATE TABLE `".$this->tables['cache']."` (
+  `requestId` int(8) UNSIGNED NOT NULL default '0',
+  `imageId` mediumint(8) NOT NULL,
+  `latitude` decimal(17,14) NOT NULL default '0',
+  `longitude` decimal(17,14) NOT NULL default '0',
+  PRIMARY KEY (`requestId`,`imageId`)
+);",
+"CREATE TABLE `".$this->tables['cache_id']."` (
+  `requestId` mediumint(8) UNSIGNED NOT NULL auto_increment,
+  `userId` smallint(5) NOT NULL,
+  `date` NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY (`requestId`)
+)"
+      );
+
+      $tablesUpdate=array(
+        $this->tables['category_maps'] => array(
+          'forceDisplay' => " ADD COLUMN `forceDisplay` CHAR(1)  NOT NULL DEFAULT 'n' AFTER `title` ",
+        )
+      );
+
+      $tablesDef = create_table_add_character_set($tablesCreate);
+
+      $tablef=new GPCTables(array($this->tables['cache'], $this->tables['cache_id']));
+      $tablef->create($tablesCreate);
+      $tablef->updateTablesFields($tablesUpdate);
+
+      unset($tablesCreate);
+      unset($tablesUpdate);
+    }