Changeset 2323 for trunk/install

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/install

Files:

• db/68-database.php (added)
• phpwebgallery_structure.sql (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;