diff options
Diffstat (limited to '')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 5e1e8c162..469b1b9a1 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -290,6 +290,21 @@ CREATE TABLE `phpwebgallery_user_cache` ( ) TYPE=MyISAM; -- +-- Table structure for table `phpwebgallery_user_cache_categories` +-- + +DROP TABLE IF EXISTS `phpwebgallery_user_cache_categories`; +CREATE TABLE `phpwebgallery_user_cache_categories` ( + `user_id` smallint(5) NOT NULL default '0', + `cat_id` smallint(5) unsigned NOT NULL default '0', + `is_child_date_last` enum('true','false') NOT NULL default 'false', + `max_date_last` datetime default NULL, + `count_images` mediumint(8) unsigned default 0, + `count_categories` mediumint(8) unsigned default 0, + PRIMARY KEY (`user_id`, `cat_id`) +) TYPE=MyISAM; + +-- -- Table structure for table `phpwebgallery_user_feed` -- |