From d03a6206da9b74ff169dd71154992d80b966cd5d Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 5 Feb 2018 14:33:45 -0300 Subject: [PATCH] Bug 20144: [sql_modes] Set a default value for lowestPriority Fix for: Field 'lowestPriority' doesn't have a default value Signed-off-by: Josef Moravec Signed-off-by: Julian Maurice Signed-off-by: Jonathan Druart --- .../mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql | 2 ++ installer/data/mysql/kohastructure.sql | 4 ++-- 2 files changed, 4 insertions(+), 2 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql diff --git a/installer/data/mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql b/installer/data/mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql new file mode 100644 index 0000000000..2eac0baefe --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_xxxxx_reserves.lowestPriority.sql @@ -0,0 +1,2 @@ +ALTER TABLE reserves MODIFY lowestPriority tinyint(1) NOT NULL DEFAULT 0; +ALTER TABLE old_reserves MODIFY lowestPriority tinyint(1) NOT NULL DEFAULT 0; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 7601562063..96d2c24d99 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1865,7 +1865,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) - `lowestPriority` tinyint(1) NOT NULL, + `lowestPriority` tinyint(1) NOT NULL DEFAULT 0, `suspend` BOOLEAN NOT NULL DEFAULT 0, `suspend_until` DATETIME NULL DEFAULT NULL, `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting @@ -1904,7 +1904,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b `itemnumber` int(11) default NULL, -- foreign key from the items table defining the specific item the patron has placed on hold or the item this hold was filled with `waitingdate` date default NULL, -- the date the item was marked as waiting for the patron at the library `expirationdate` DATE DEFAULT NULL, -- the date the hold expires (usually the date entered by the patron to say they don't need the hold after a certain date) - `lowestPriority` tinyint(1) NOT NULL, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) + `lowestPriority` tinyint(1) NOT NULL DEFAULT 0, -- has this hold been pinned to the lowest priority in the holds queue (1 for yes, 0 for no) `suspend` BOOLEAN NOT NULL DEFAULT 0, -- in this hold suspended (1 for yes, 0 for no) `suspend_until` DATETIME NULL DEFAULT NULL, -- the date this hold is suspended until (NULL for infinitely) `itemtype` VARCHAR(10) NULL DEFAULT NULL, -- If record level hold, the optional itemtype of the item the patron is requesting -- 2.20.1