diff options
| author | z0rglub <z0rglub@piwigo.org> | 2004-08-30 22:00:46 +0000 |
|---|---|---|
| committer | z0rglub <z0rglub@piwigo.org> | 2004-08-30 22:00:46 +0000 |
| commit | 0e2436f50a61f90da22e75085280bf9f2087699a (patch) | |
| tree | bac0bec23ab9487453e212e66b5ba527b15c2e60 /install/dbscheme.txt | |
| parent | 0c482df04e1631e12db1fe99e904d6111b17adf1 (diff) | |
add rating feature
git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'install/dbscheme.txt')
| -rw-r--r-- | install/dbscheme.txt | 7 |
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 |