Changeset 1883 for trunk/install

Timestamp:

Mar 9, 2007, 5:28:49 PM (17 years ago)

Author:

plg

Message:

New: #images.high_filesize was added so that we can sum the filesizes in the
filtered history. #images.high_filesize is filled during metadata
synchronization.

Bug fixed: in getAttribute XML function, when asking "filesize", it was
returning high_filesize. The regex was too simple.

Location:

trunk/install

Files:

• db/55-database.php (added)
• db/56-database.php (added)
• phpwebgallery_structure.sql (modified) (3 diffs)

trunk/install/phpwebgallery_structure.sql

@@ -39 +39 @@
   `global_rank` varchar(255) default NULL,
   `image_order` varchar(128) default NULL,
-  `permalink` VARCHAR(64) default NULL,
-  PRIMARY KEY  (`id`),
-  KEY `categories_i2` (`id_uppercat`),
-  UNIQUE KEY `categories_i3` (`permalink`)
+  `permalink` varchar(64) default NULL,
+  PRIMARY KEY  (`id`),
+  UNIQUE KEY `categories_i3` (`permalink`),
+  KEY `categories_i2` (`id_uppercat`)
 ) TYPE=MyISAM;
 
@@ -197 +197 @@
   `path` varchar(255) NOT NULL default '',
   `storage_category_id` smallint(5) unsigned default NULL,
+  `high_filesize` mediumint(9) unsigned default NULL,
   PRIMARY KEY  (`id`),
   KEY `images_i2` (`date_available`),
@@ -211 +212 @@
 DROP TABLE IF EXISTS `phpwebgallery_old_permalinks`;
 CREATE TABLE `phpwebgallery_old_permalinks` (
-  `cat_id` smallint(5) unsigned NOT NULL,
-  `permalink` VARCHAR(64) NOT NULL,
-  `date_deleted` datetime NOT NULL,
+  `cat_id` smallint(5) unsigned NOT NULL default '0',
+  `permalink` varchar(64) NOT NULL default '',
+  `date_deleted` datetime NOT NULL default '0000-00-00 00:00:00',
   `last_hit` datetime default NULL,
   `hit` int(10) unsigned NOT NULL default '0',
-  PRIMARY KEY (`permalink`)
+  PRIMARY KEY  (`permalink`)
 ) TYPE=MyISAM;