diff options
| author | rub <rub@piwigo.org> | 2006-12-01 23:31:19 +0000 |
|---|---|---|
| committer | rub <rub@piwigo.org> | 2006-12-01 23:31:19 +0000 |
| commit | 63638b9b6dcdcef8baf5363419f0f6c5130c62df (patch) | |
| tree | cf53c156032a7565dc7db3842cbd10952a920812 /install/phpwebgallery_structure.sql | |
| parent | b2de3c32ee635788f2f34c98d529fdc167ca6a51 (diff) | |
Resolved Issue ID 0000299:
o Add (new) icon of parent category with children categories including new images
o Improved display text for images count
o Improved (a little) mass_* functions
More explications on the forum.
You must call directly upgrade_feep.php (http://127.0.0.1/BSF/upgrade_feed.php for example)
git-svn-id: http://piwigo.org/svn/trunk@1624 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -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` -- |