View | Details | Raw Unified | Return to bug 5668
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-7 / +6 lines)
Lines 2654-2668 CREATE TABLE `fieldmapping` ( -- koha to keyword mapping Link Here
2654
  PRIMARY KEY  (`id`)
2654
  PRIMARY KEY  (`id`)
2655
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2655
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2656
2656
2657
---
2657
--
2658
--- 'Ratings' table. This tracks the star ratings set by borrowers.
2658
-- 'Ratings' table. This tracks the star ratings set by borrowers.
2659
---
2659
--
2660
2660
2661
DROP TABLE IF EXISTS `ratings`;
2661
DROP TABLE IF EXISTS `ratings`;
2662
CREATE TABLE `ratings` (
2662
CREATE TABLE `ratings` (
2663
    `borrowernumber` int(11) NOT NULL, --- the borrower this rating is for
2663
    `borrowernumber` int(11) NOT NULL, -- the borrower this rating is for
2664
    `biblionumber` int(11) NOT NULL, --- the biblio it's for
2664
    `biblionumber` int(11) NOT NULL, -- the biblio it's for
2665
    `value` tinyint(1) NOT NULL, --- the rating, from 1-5
2665
    `value` tinyint(1) NOT NULL, -- the rating, from 1-5
2666
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
2666
    `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
2667
    PRIMARY KEY  (`borrowernumber`,`biblionumber`),
2667
    PRIMARY KEY  (`borrowernumber`,`biblionumber`),
2668
    KEY `ratings_borrowers_fk_1` (`borrowernumber`),
2668
    KEY `ratings_borrowers_fk_1` (`borrowernumber`),
2669
- 

Return to bug 5668