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 |
- |
|
|