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

(-)a/installer/data/mysql/atomicupdate/bug_review.sql (+1 lines)
Line 0 Link Here
1
ALTER TABLE reviews CHANGE COLUMN approved approved tinyint(4) DEFAULT 0;
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 1932-1938 CREATE TABLE `reviews` ( -- patron opac comments Link Here
1932
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment
1932
  `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment
1933
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for
1933
  `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for
1934
  `review` text, -- the body of the comment
1934
  `review` text, -- the body of the comment
1935
  `approved` tinyint(4) default NULL, -- whether this comment has been approved by a librarian (1 for yes, 0 for no)
1935
  `approved` tinyint(4) default 0, -- whether this comment has been approved by a librarian (1 for yes, 0 for no)
1936
  `datereviewed` datetime default NULL, -- the date the comment was left
1936
  `datereviewed` datetime default NULL, -- the date the comment was left
1937
  PRIMARY KEY  (`reviewid`),
1937
  PRIMARY KEY  (`reviewid`),
1938
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1938
  CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
1939
- 

Return to bug 15839