diff options
| author | rvelices <rv-github@modusoptimus.com> | 2008-04-30 01:03:14 +0000 |
|---|---|---|
| committer | rvelices <rv-github@modusoptimus.com> | 2008-04-30 01:03:14 +0000 |
| commit | 6c0a51806f74eec1bf85842a558976a2e430c15f (patch) | |
| tree | 95a81ab60ec87d372fc32a2ffb6c92ec22fa10cb /install/phpwebgallery_structure.sql | |
| parent | f85dcfda5458f8f01e6a7c03794561f8ccb1a225 (diff) | |
- transform some db fields from text to mediumtext (for large dbs); - #sessions.data, #user_cache.forbidden_categories and #user_cache.image_access_list
git-svn-id: http://piwigo.org/svn/trunk@2323 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index bb09e0fd1..01626af0c 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -266,7 +266,7 @@ CREATE TABLE `phpwebgallery_search` ( DROP TABLE IF EXISTS `phpwebgallery_sessions`; 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`) ) TYPE=MyISAM; @@ -327,10 +327,10 @@ DROP TABLE IF EXISTS `phpwebgallery_user_cache`; CREATE TABLE `phpwebgallery_user_cache` ( `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; |