From 4c27b635419aa58c500cb8480b7146e316c83643 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 22 Oct 2015 06:38:57 -0400 Subject: [PATCH] [PASSED QA] Bug 9129 - Update database Signed-off-by: Cindy Murdock Ames Signed-off-by: Katrin Fischer --- installer/data/mysql/atomicupdate/bug_9192.sql | 1 + installer/data/mysql/kohastructure.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_9192.sql diff --git a/installer/data/mysql/atomicupdate/bug_9192.sql b/installer/data/mysql/atomicupdate/bug_9192.sql new file mode 100644 index 0000000..a6d0ca8 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_9192.sql @@ -0,0 +1 @@ +ALTER TABLE issuingrules ADD cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0' AFTER overduefinescap diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index e3f1cfc..5d1a488 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -1188,6 +1188,7 @@ CREATE TABLE `issuingrules` ( -- circulation and fine rules `reservesallowed` smallint(6) NOT NULL default "0", -- how many holds are allowed `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 + cap_fine_to_replacement_price BOOLEAN NOT NULL DEFAULT '0', -- cap the fine based on item's replacement price onshelfholds tinyint(1) NOT NULL default 0, -- allow holds for items that are on shelf opacitemholds char(1) NOT NULL default 'N', -- allow opac users to place specific items on hold PRIMARY KEY (`branchcode`,`categorycode`,`itemtype`), -- 1.9.1