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
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
