Lines 1598-1604
CREATE TABLE `reviews` ( -- patron opac comments
Link Here
|
1598 |
`review` text, -- the body of the comment |
1598 |
`review` text, -- the body of the comment |
1599 |
`approved` tinyint(4) default NULL, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1599 |
`approved` tinyint(4) default NULL, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1600 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1600 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1601 |
PRIMARY KEY (`reviewid`) |
1601 |
PRIMARY KEY (`reviewid`), |
|
|
1602 |
CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
1603 |
CONSTRAINT `reviews_ibfk_2` FOREIGN KEY (`biblionumber`) REFERENCES `biblio` (`biblionumber`) ON DELETE CASCADE ON UPDATE CASCADE |
1602 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1604 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
1603 |
|
1605 |
|
1604 |
-- |
1606 |
-- |