Changeset 23551 for extensions/UserCollections/include/install.inc.php

Timestamp:

Jun 26, 2013, 12:09:21 AM (11 years ago)

Author:

mistic100

Message:

many corrections & optimizations + remove useless code + clean

File:

• extensions/UserCollections/include/install.inc.php (modified) (2 diffs)

extensions/UserCollections/include/install.inc.php

@@ -24 +24 @@
   `name` varchar(255) NOT NULL,
   `date_creation` datetime NOT NULL,
+  `comment` text NULL,
   `nb_images` mediumint(8) NOT NULL DEFAULT 0,
-  `active` tinyint(1) DEFAULT 0,
   `public` tinyint(1) DEFAULT 0,
   `public_id` varchar(10) NULL,
@@ -48 +48 @@
     pwg_query('ALTER TABLE `'.$prefixeTable.'collection_images` ADD `add_date` DATETIME NULL;');
   }
+  
+  $result = pwg_query('SHOW COLUMNS FROM `'.$prefixeTable.'collections` LIKE "comment";');
+  if (!pwg_db_num_rows($result))
+  {
+    pwg_query('ALTER TABLE `'.$prefixeTable.'collections` ADD `comment` TEXT NULL;');
+    pwg_query('ALTER TABLE `'.$prefixeTable.'collections` DROP `active`;');
+  }
 }