aboutsummaryrefslogtreecommitdiffstats
path: root/install/dbscheme.txt
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-08-30 22:00:46 +0000
committerz0rglub <z0rglub@piwigo.org>2004-08-30 22:00:46 +0000
commit0e2436f50a61f90da22e75085280bf9f2087699a (patch)
treebac0bec23ab9487453e212e66b5ba527b15c2e60 /install/dbscheme.txt
parent0c482df04e1631e12db1fe99e904d6111b17adf1 (diff)
add rating feature
git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to '')
-rw-r--r--install/dbscheme.txt7
1 files changed, 7 insertions, 0 deletions
diff --git a/install/dbscheme.txt b/install/dbscheme.txt
index 913abe6e7..6661372f7 100644
--- a/install/dbscheme.txt
+++ b/install/dbscheme.txt
@@ -8,6 +8,7 @@ table:groups
table:history
table:image_category
table:images
+table:rate
table:sessions
table:sites
table:user_access
@@ -68,6 +69,10 @@ column:keywords table:images type:varchar
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:date_metadata_update table:images type:date nullable:N
+column:average_rate table:images type:float nullable:N length:5,2 signed:N
+column:user_id table:rate type:smallint nullable:Y length:5 signed:N
+column:element_id table:rate type:mediumint nullable:Y length:8 signed:N
+column:rate table:rate type:tinyint nullable:Y length:2 signed: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
@@ -114,6 +119,8 @@ PK:groups_pk table:groups column:id
PK:image_category_pk table:image_category column:image_id
PK:image_category_pk table:image_category column:category_id
PK:images_pk table:images column:id
+PK:rate_pk table:rate column:user_id
+PK:rate_pk table:rate column:element_id
PK:sessions_pk table:sessions column:id
PK:sites_pk table:sites column:id
PK:user_access_pk table:user_access column:user_id