Lines 1912-1918
CREATE TABLE `reviews` ( -- patron opac comments
Link Here
|
1912 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment |
1912 |
`borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment |
1913 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for |
1913 |
`biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for |
1914 |
`review` text, -- the body of the comment |
1914 |
`review` text, -- the body of the comment |
1915 |
`approved` tinyint(4) default NULL, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1915 |
`approved` tinyint(4) default 0, -- whether this comment has been approved by a librarian (1 for yes, 0 for no) |
1916 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1916 |
`datereviewed` datetime default NULL, -- the date the comment was left |
1917 |
PRIMARY KEY (`reviewid`), |
1917 |
PRIMARY KEY (`reviewid`), |
1918 |
CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
1918 |
CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
1919 |
- |
|
|