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

Timestamp:

Nov 4, 2010, 10:29:48 AM (13 years ago)

Author:

grum

Message:

fix bug on install/update process

File:

• extensions/GMaps/gmaps_install.class.inc.php (modified) (1 diff)

extensions/GMaps/gmaps_install.class.inc.php

@@ -233 +233 @@
       $tablesCreate=array(
 "CREATE TABLE `".$this->tables['cache']."` (
-  `requestId` int(8) UNSIGNED NOT NULL default '0',
+  `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,
-  `date` NOT NULL default '0000-00-00 00:00:00',
+  `date` timestamp 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);
     }