From ec193d35e626f7522b9a0410fa29477daa7ae35b Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Wed, 1 Jul 2015 13:06:03 -0400 Subject: [PATCH] [SIGNED-OFF] Bug 8352 [QA Followup] - Fix column type in kohastructure.sql Signed-off-by: Jenice Tate --- installer/data/mysql/kohastructure.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 4877989..7905fd1 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1663,7 +1663,7 @@ CREATE TABLE `old_reserves` ( -- this table holds all holds/reserves that have b `lowestPriority` tinyint(1) NOT NULL, -- 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) - `printed` tinyint(1) DEFAULT NULL, + `printed` DATETIME DEFAULT NULL, PRIMARY KEY (`reserve_id`), KEY `old_reserves_borrowernumber` (`borrowernumber`), KEY `old_reserves_biblionumber` (`biblionumber`), @@ -1839,7 +1839,7 @@ CREATE TABLE `reserves` ( -- information related to holds/reserves in Koha `lowestPriority` tinyint(1) NOT NULL, `suspend` BOOLEAN NOT NULL DEFAULT 0, `suspend_until` DATETIME NULL DEFAULT NULL, - `printed` tinyint(1) DEFAULT NULL, + `printed` DATETIME DEFAULT NULL, PRIMARY KEY (`reserve_id`), KEY priorityfoundidx (priority,found), KEY `borrowernumber` (`borrowernumber`), -- 1.7.2.5