From 96e6b8f56c9c368b46644f70e84494ec7777df51 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 29 Dec 2015 19:11:47 +0000 Subject: [PATCH] Bug 14695 - Update database --- installer/data/mysql/atomicupdate/bug_7710.sql | 1 + installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_7710.sql diff --git a/installer/data/mysql/atomicupdate/bug_7710.sql b/installer/data/mysql/atomicupdate/bug_7710.sql new file mode 100644 index 0000000..6366acb --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_7710.sql @@ -0,0 +1 @@ +ALTER TABLE issuingrules ADD COLUMN holds_per_record SMALLINT(6) NOT NULL DEFAULT 1 AFTER reservesallowed; diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index fa44ff7..6bb133d 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1187,6 +1187,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `norenewalbefore` int(4) default NULL, -- no renewal allowed until X days or hours before due date. In the unit set in issuingrules.lengthunit `auto_renew` BOOLEAN default FALSE, -- automatic renewal `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed + `holds_per_record` SMALLINT(6) NOT NULL DEFAULT 1, -- How many holds a patron can have on a given bib `branchcode` varchar(10) NOT NULL default '', -- the branch this rule is for (branches.branchcode) overduefinescap decimal(28,6) default NULL, -- the maximum amount of an overdue fine onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf -- 2.1.4