From e34ed9f8780902396b9c527524c7b6d63c5a3a4a Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 25 Feb 2020 12:07:18 +0100 Subject: [PATCH] Bug 24722: Enforce NOT NULL constraint on reserves.priority This field is never NULL and must always be equal to an integer. Signed-off-by: Martin Renvoize Signed-off-by: Katrin Fischer --- installer/data/mysql/kohastructure.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 0f092725b5..7ecf5a77f6 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1757,7 +1757,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `reminderdate` date default NULL, -- currently unused `cancellationdate` date default NULL, -- the date this hold was cancelled `reservenotes` LONGTEXT, -- notes related to this hold - `priority` smallint(6) default NULL, -- where in the queue the patron sits + `priority` smallint(6) NOT NULL, -- where in the queue the patron sits `found` varchar(1) default NULL, -- a one letter code defining what the status is of the hold is after it has been confirmed `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, -- the date and time this hold was last updated `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 -- 2.11.0