Attachment 43782 Details for Bug 9129 – [PASSED QA] Bug 9129 - Update database

[patch] [PASSED QA] Bug 9129 - Update database

PASSED-QA-Bug-9129---Update-database.patch (text/plain), 1.78 KB, created by Katrin Fischer on 2015-10-22 20:17:17 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-10-22 20:17:17 UTC

Size: 1.78 KB

patch

obsolete

>From 4c27b635419aa58c500cb8480b7146e316c83643 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Thu, 22 Oct 2015 06:38:57 -0400
>Subject: [PATCH] [PASSED QA] Bug 9129 - Update database
>
>Signed-off-by: Cindy Murdock Ames <cmurdock@ccfls.org>
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> 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

Actions: View | Diff | Splinter Review

Attachments on bug 9129: 13612 | 13614 | 13615 | 13616 | 14553 | 16197 | 17989 | 17990 | 17991 | 17992 | 18366 | 18367 | 18368 | 18370 | 18371 | 18642 | 18643 | 23305 | 43252 | 43253 | 43298 | 43592 | 43685 | 43686 | 43688 | 43689 | 43745 | 43746 | 43747 | 43781 | 43782 | 43783 | 43784 | 46157