Changeset 1624 for trunk/install

Timestamp:

Dec 2, 2006, 12:31:19 AM (17 years ago)

Author:

rub

Message:

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)

Location:

trunk/install

Files:

• db/37-database.php (added)
• phpwebgallery_structure.sql (modified) (1 diff)

trunk/install/phpwebgallery_structure.sql

@@ -291 +291 @@
 
 --
+-- 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`
 --