aboutsummaryrefslogtreecommitdiffstats
path: root/install/dbscheme.txt
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/dbscheme.txt
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 'install/dbscheme.txt')
-rw-r--r--install/dbscheme.txt6
1 files changed, 3 insertions, 3 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