Changeset 507 for trunk/install/dbscheme.txt

Timestamp:

Aug 31, 2004, 12:00:46 AM (20 years ago)

Author:

z0rglub

Message:

add rating feature

File:

• trunk/install/dbscheme.txt (modified) (3 diffs)

trunk/install/dbscheme.txt

@@ -9 +9 @@
 table:image_category
 table:images
+table:rate
 table:sessions
 table:sites
@@ -69 +70 @@
 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
@@ -115 +120 @@
 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