From 9b018601aeaea8102a64281139baaa8bc004b5d0 Mon Sep 17 00:00:00 2001 From: Nicole C. Engard Date: Wed, 11 Jul 2012 23:20:28 -0400 Subject: [PATCH] Bug 6716: Update ratings table documentation This patch adds a comment to the table and updates the field descriptions with a bit more information. --- installer/data/mysql/kohastructure.sql | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 3b9827a..11e4b20 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2843,10 +2843,10 @@ CREATE TABLE IF NOT EXISTS `social_data` ( -- DROP TABLE IF EXISTS ratings; -CREATE TABLE ratings ( - borrowernumber int(11) NOT NULL, -- the borrower this rating is for - biblionumber int(11) NOT NULL, -- the biblio it's for - rating_value tinyint(1) NOT NULL, -- the rating, from 1-5 +CREATE TABLE ratings ( -- information related to the star ratings in the OPAC + borrowernumber int(11) NOT NULL, -- the borrowernumber of the patron who left this rating (borrowers.borrowernumber) + biblionumber int(11) NOT NULL, -- the biblio this rating is for (biblio.biblionumber) + rating_value tinyint(1) NOT NULL, -- the rating, from 1 to 5 timestamp timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (borrowernumber,biblionumber), CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, -- 1.7.2.3