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

(-)a/installer/data/mysql/kohastructure.sql (-4 / +4 lines)
Lines 1545-1550 CREATE TABLE `patronimage` ( Link Here
1545
-- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied...
1545
-- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied...
1546
-- so MyISAM is better in this case
1546
-- so MyISAM is better in this case
1547
1547
1548
DROP TABLE IF EXISTS `pending_offline_operations`;
1548
CREATE TABLE `pending_offline_operations` (
1549
CREATE TABLE `pending_offline_operations` (
1549
  `operationid` int(11) NOT NULL AUTO_INCREMENT,
1550
  `operationid` int(11) NOT NULL AUTO_INCREMENT,
1550
  `userid` varchar(30) NOT NULL,
1551
  `userid` varchar(30) NOT NULL,
Lines 2819-2827 CREATE TABLE IF NOT EXISTS `social_data` ( Link Here
2819
2820
2820
DROP TABLE IF EXISTS ratings;
2821
DROP TABLE IF EXISTS ratings;
2821
CREATE TABLE ratings (
2822
CREATE TABLE ratings (
2822
    borrowernumber int(11) NOT NULL, --- the borrower this rating is for
2823
    borrowernumber int(11) NOT NULL, -- the borrower this rating is for
2823
    biblionumber int(11) NOT NULL, --- the biblio it's for
2824
    biblionumber int(11) NOT NULL, -- the biblio it's for
2824
    rating_value tinyint(1) NOT NULL, --- the rating, from 1-5
2825
    rating_value tinyint(1) NOT NULL, -- the rating, from 1-5
2825
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP,
2826
    timestamp timestamp NOT NULL default CURRENT_TIMESTAMP,
2826
    PRIMARY KEY  (borrowernumber,biblionumber),
2827
    PRIMARY KEY  (borrowernumber,biblionumber),
2827
    CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
2828
    CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE,
2828
- 

Return to bug 7954