@@ -, +, @@ --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 files changed, 6 insertions(+), 6 deletions(-) --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -2654,15 +2654,15 @@ CREATE TABLE `fieldmapping` ( -- koha to keyword mapping PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ---- ---- 'Ratings' table. This tracks the star ratings set by borrowers. ---- +-- +-- 'Ratings' table. This tracks the star ratings set by borrowers. +-- 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 - `value` tinyint(1) NOT NULL, --- the rating, from 1-5 + `borrowernumber` int(11) NOT NULL, -- the borrower this rating is for + `biblionumber` int(11) NOT NULL, -- the biblio it's for + `value` tinyint(1) NOT NULL, -- the rating, from 1-5 `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`borrowernumber`,`biblionumber`), KEY `ratings_borrowers_fk_1` (`borrowernumber`), --