From 9ffbb3548c2c3b7ab9cd2c6f838b22c45abc1bb4 Mon Sep 17 00:00:00 2001
From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Date: Fri, 26 Oct 2018 11:55:54 +0100
Subject: [PATCH] Bug 21682: Corrections for strict sql in stockrotationrotas

Test Plan:
1) Ensure you're database is prior to version 18.06.00.040
2) Ensure 'strict_sql_modes' is enabled
3) Run updatedatabase
4) See no errors during upgrade
5) Run a fresh install
6) Note no errors during database installation

Signed-off-by: Mark Tompsett <mtompset@hotmail.com>
---
 installer/data/mysql/kohastructure.sql | 4 ++--
 installer/data/mysql/updatedatabase.pl | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 62c0dcecfb..629bc93569 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -4269,9 +4269,9 @@ CREATE TABLE `circulation_rules` (
 --
 
 CREATE TABLE IF NOT EXISTS stockrotationrotas (
-    rota_id int(11) auto_increment,          -- Stockrotation rota ID
+    rota_id int(11) auto_increment,         -- Stockrotation rota ID
     title varchar(100) NOT NULL,            -- Title for this rota
-    description text NOT NULL default '',   -- Description for this rota
+    description text NOT NULL,              -- Description for this rota
     cyclical tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
     active tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
     PRIMARY KEY (`rota_id`)
diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index cc738c617b..e1a95daba8 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -16569,7 +16569,7 @@ if( CheckVersion( $DBversion ) ) {
           CREATE TABLE `stockrotationrotas` (
             `rota_id` int(11) auto_increment,         -- Stockrotation rota ID
             `title` varchar(100) NOT NULL,            -- Title for this rota
-            `description` text NOT NULL default '',   -- Description for this rota
+            `description` text NOT NULL,              -- Description for this rota
             `cyclical` tinyint(1) NOT NULL default 0, -- Should items on this rota keep cycling?
             `active` tinyint(1) NOT NULL default 0,   -- Is this rota currently active?
             PRIMARY KEY (`rota_id`),
-- 
2.11.0