Changeset 2323

Timestamp:

Apr 30, 2008, 3:03:14 AM (16 years ago)

Author:

rvelices

Message:

• transform some db fields from text to mediumtext (for large dbs); - #sessions.data, #user_cache.forbidden_categories and #user_cache.image_access_list

Location:

trunk

Files:

• install/db/68-database.php (added)
• install/phpwebgallery_structure.sql (modified) (2 diffs)
• upgrade_feed.php (modified) (2 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -267 +267 @@
 CREATE TABLE `phpwebgallery_sessions` (
   `id` varchar(255) binary NOT NULL default '',
-  `data` text NOT NULL,
+  `data` mediumtext NOT NULL,
   `expiration` datetime NOT NULL default '0000-00-00 00:00:00',
   PRIMARY KEY  (`id`)
@@ -328 +328 @@
   `user_id` smallint(5) NOT NULL default '0',
   `need_update` enum('true','false') NOT NULL default 'true',
-  `forbidden_categories` text,
+  `forbidden_categories` mediumtext,
   `nb_total_images` mediumint(8) unsigned default NULL,
   `image_access_type` enum('NOT IN','IN') NOT NULL default 'NOT IN',
-  `image_access_list` text default NULL,
+  `image_access_list` mediumtext default NULL,
   PRIMARY KEY  (`user_id`)
 ) TYPE=MyISAM;

trunk/upgrade_feed.php

@@ -27 +27 @@
 include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
 include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php');
-include(PHPWG_ROOT_PATH.'include/template.php');
 include(PHPWG_ROOT_PATH.'include/mysql.inc.php');
 
@@ -72 +71 @@
 {
   unset($upgrade_description);
-  
+
   echo "\n\n";
   echo '=== upgrade '.$upgrade_id."\n";