Changeset 2324 for trunk/install

Timestamp:

May 1, 2008, 3:12:34 AM (16 years ago)

Author:

rvelices

Message:

• move #categories.date_last and nb_images to #user_cache_categories

Location:

trunk/install

Files:

• db/69-database.php (added)
• phpwebgallery_structure.sql (modified) (2 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -23 +23 @@
 CREATE TABLE `phpwebgallery_categories` (
   `id` smallint(5) unsigned NOT NULL auto_increment,
-  `date_last` datetime default NULL,
-  `nb_images` mediumint(8) unsigned NOT NULL default '0',
   `name` varchar(255) NOT NULL default '',
   `id_uppercat` smallint(5) unsigned default NULL,
@@ -343 +341 @@
   `user_id` smallint(5) NOT NULL default '0',
   `cat_id` smallint(5) unsigned NOT NULL default '0',
+  `date_last` datetime default NULL,
   `max_date_last` datetime default NULL,
+  `nb_images` mediumint(8) unsigned NOT NULL default '0',
   `count_images` mediumint(8) unsigned default '0',
   `count_categories` mediumint(8) unsigned default '0',