diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-08-05 17:50:44 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-08-05 17:50:44 +0000 |
| commit | bf9fc4f33ce6cb77186a3f800fcc672999645cfb (patch) | |
| tree | 28b53ceada6128a14e03c1cca9c983f31669a7c7 /install | |
| parent | c6ef17d20544f282af89aa2ca70af17bdbbe9785 (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 'install')
| -rw-r--r-- | install/dbscheme.txt | 6 | ||||
| -rw-r--r-- | install/phpwebgallery_structure.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt index fb41c4e50..d5ec539b4 100644 --- a/install/dbscheme.txt +++ b/install/dbscheme.txt @@ -56,7 +56,7 @@ column:id table:images type:mediumint column:file table:images type:varchar nullable:Y length:255 binary:N column:date_available table:images type:date nullable:Y column:date_creation table:images type:date nullable:N -column:tn_ext table:images type:char nullable:Y length:3 binary:N +column:tn_ext table:images type:varchar nullable:N length:4 binary:N column:name table:images type:varchar nullable:N length:255 binary:N column:comment table:images type:text nullable:N column:author table:images type:varchar nullable:N length:255 binary:N @@ -66,6 +66,7 @@ column:width table:images type:smallint column:height table:images type:smallint nullable:N length:9 signed:N column:keywords table:images type:varchar nullable:N length:255 binary:N column:storage_category_id table:images type:smallint nullable:N length:5 signed:N +column:representative_ext table:images type:varchar nullable:N length:4 binary:N column:id table:sessions type:varchar nullable:Y length:255 binary:Y column:user_id table:sessions type:smallint nullable:Y length:5 signed:N column:expiration table:sessions type:int nullable:Y length:10 signed:N @@ -88,8 +89,7 @@ column:maxwidth table:users type:smallint column:maxheight table:users type:smallint nullable:N length:6 signed:Y column:expand table:users type:enum('true','false') nullable:Y column:show_nb_comments table:users type:enum('true','false') nullable:Y -column:short_period table:users type:tinyint nullable:Y length:3 signed:N -column:long_period table:users type:tinyint nullable:Y length:3 signed:N +column:recent_period table:users type:tinyint nullable:Y length:3 signed:N column:template table:users type:varchar nullable:Y length:255 binary:N column:forbidden_categories table:users type:text nullable:N column:id table:waiting type:int nullable:Y length:10 signed:N 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), |