Bug 6716: Update ratings table documentation

This patch adds a comment to the table and updates the field
descriptions with a bit more information.

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 9578164..081dec8 100644 (file)
--- 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,