From 3d5d15ac18ffe047be22e74c62471fd3331bdc08 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Date: Tue, 16 Feb 2016 16:53:41 +0000
Subject: [PATCH] Bug 15839: Koha::Reviews - Change default value for approved
 to 0
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

The reviews.approved column had a default value set to NULL.
It does not make sense, the default value should be 0, this will avoid
to have to specify the approved value when creating a new review.

Signed-off-by: Marc VĂ©ron <veron@veron.ch>
---
 installer/data/mysql/atomicupdate/bug_review.sql |    1 +
 installer/data/mysql/kohastructure.sql           |    2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)
 create mode 100644 installer/data/mysql/atomicupdate/bug_review.sql

diff --git a/installer/data/mysql/atomicupdate/bug_review.sql b/installer/data/mysql/atomicupdate/bug_review.sql
new file mode 100644
index 0000000..076c3b5
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_review.sql
@@ -0,0 +1 @@
+ALTER TABLE reviews CHANGE COLUMN approved approved tinyint(4) DEFAULT 0;
diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 4bb4402..75dd2ec 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -1899,7 +1899,7 @@ CREATE TABLE `reviews` ( -- patron opac comments
   `borrowernumber` int(11) default NULL, -- foreign key from the borrowers table defining which patron left this comment
   `biblionumber` int(11) default NULL, -- foreign key from the biblio table defining which bibliographic record this comment is for
   `review` text, -- the body of the comment
-  `approved` tinyint(4) default NULL, -- whether this comment has been approved by a librarian (1 for yes, 0 for no)
+  `approved` tinyint(4) default 0, -- whether this comment has been approved by a librarian (1 for yes, 0 for no)
   `datereviewed` datetime default NULL, -- the date the comment was left
   PRIMARY KEY  (`reviewid`),
   CONSTRAINT `reviews_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE,
-- 
1.7.10.4