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

Timestamp:

Oct 9, 2010, 12:28:05 AM (14 years ago)

Author:

grum

Message:

KML files manager implemented + fixe some small bugs + forgotten file for the search page

File:

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

extensions/GMaps/gmaps_install.class.inc.php

@@ -69 +69 @@
   `imgSort` smallint(5) unsigned NOT NULL default '0',
   `applySubCat` char(1) NOT NULL default 'y',
+  `kmlFileId` int(10) unsigned NOT NULL default '0',
   `kmlFileUrl` varchar(255) NOT NULL,
   `icon` varchar(255) NOT NULL,
@@ -87 +88 @@
   `imageCatsPLink` varchar(255) NOT NULL,
   PRIMARY KEY  USING BTREE (`userId`,`requestId`,`imageId`)
+)",
+"CREATE TABLE `".$this->tables['kmlfiles']."` (
+  `id` int(10) unsigned NOT NULL auto_increment,
+  `file` varchar(255) NOT NULL,
+  `name` varchar(255) NOT NULL,
+  `fileDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+  `fileSize` mediumint(8) unsigned NOT NULL,
+  PRIMARY KEY  (`id`)
 )"
       );