aboutsummaryrefslogtreecommitdiffstats
path: root/install/phpwebgallery_structure.sql
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-08-05 17:50:44 +0000
committerz0rglub <z0rglub@piwigo.org>2004-08-05 17:50:44 +0000
commitbf9fc4f33ce6cb77186a3f800fcc672999645cfb (patch)
tree28b53ceada6128a14e03c1cca9c983f31669a7c7 /install/phpwebgallery_structure.sql
parentc6ef17d20544f282af89aa2ca70af17bdbbe9785 (diff)
- non picture files management (adds column images.representative_ext)
- short_period + long_period replaced by a single recent_period git-svn-id: http://piwigo.org/svn/trunk@474 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/phpwebgallery_structure.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index ab0edfa66..f2072281b 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -125,7 +125,7 @@ CREATE TABLE phpwebgallery_images (
file varchar(255) NOT NULL default '',
date_available date NOT NULL default '0000-00-00',
date_creation date default NULL,
- tn_ext char(3) NOT NULL default 'jpg',
+ tn_ext varchar(4) default '',
name varchar(255) default NULL,
comment text,
author varchar(255) default NULL,
@@ -135,6 +135,7 @@ CREATE TABLE phpwebgallery_images (
height smallint(9) unsigned default NULL,
keywords varchar(255) default NULL,
storage_category_id smallint(5) unsigned default NULL,
+ representative_ext varchar(4) default NULL,
PRIMARY KEY (id),
KEY images_i2 (date_available),
KEY images_i1 (storage_category_id)
@@ -205,8 +206,7 @@ CREATE TABLE phpwebgallery_users (
maxheight smallint(6) default NULL,
expand enum('true','false') NOT NULL default 'false',
show_nb_comments enum('true','false') NOT NULL default 'false',
- short_period tinyint(3) unsigned NOT NULL default '7',
- long_period tinyint(3) unsigned NOT NULL default '14',
+ recent_period tinyint(3) unsigned NOT NULL default '7',
template varchar(255) NOT NULL default 'default',
forbidden_categories text,
PRIMARY KEY (id),