diff options
Diffstat (limited to 'install/phpwebgallery_structure.sql')
| -rw-r--r-- | install/phpwebgallery_structure.sql | 6 |
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), |