diff options
| author | plegall <plg@piwigo.org> | 2007-03-09 16:28:49 +0000 |
|---|---|---|
| committer | plegall <plg@piwigo.org> | 2007-03-09 16:28:49 +0000 |
| commit | b0478ef330b8f729554aec55baa81d9e3d02a063 (patch) | |
| tree | 2be4688f02ba35fe2297f2b7d7de03e8f9eaf5e2 /install/phpwebgallery_structure.sql | |
| parent | 81030a7ab40a481d6d8c93539162a4a035ea09d1 (diff) | |
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.
git-svn-id: http://piwigo.org/svn/trunk@1883 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 15 |
1 files changed, 8 insertions, 7 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql index 5a9d3e544..4169f2973 100644 --- a/install/phpwebgallery_structure.sql +++ b/install/phpwebgallery_structure.sql @@ -38,10 +38,10 @@ CREATE TABLE `phpwebgallery_categories` ( `commentable` enum('true','false') NOT NULL default 'true', `global_rank` varchar(255) default NULL, `image_order` varchar(128) default NULL, - `permalink` VARCHAR(64) default NULL, + `permalink` varchar(64) default NULL, PRIMARY KEY (`id`), - KEY `categories_i2` (`id_uppercat`), - UNIQUE KEY `categories_i3` (`permalink`) + UNIQUE KEY `categories_i3` (`permalink`), + KEY `categories_i2` (`id_uppercat`) ) TYPE=MyISAM; -- @@ -196,6 +196,7 @@ CREATE TABLE `phpwebgallery_images` ( `has_high` enum('true') default NULL, `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`), KEY `images_i3` (`average_rate`), @@ -210,12 +211,12 @@ CREATE TABLE `phpwebgallery_images` ( 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; -- |