Attachment 43745 Details for Bug 9129 – Bug 9129 - Update database

[patch] Bug 9129 - Update database

Bug-9129---Update-database.patch (text/plain), 1.74 KB, created by Kyle M Hall (khall) on 2015-10-22 10:40:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2015-10-22 10:40:44 UTC

Size: 1.74 KB

patch

obsolete

>From ddac9334999e26e1d4307392be2f146f97b2c4a7 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] Bug 9129 - Update database
>
>Signed-off-by: Cindy Murdock Ames <cmurdock@ccfls.org>
>---
> installer/data/mysql/atomicupdate/bug_9192.sql |    1 +
> installer/data/mysql/kohastructure.sql         |    1 +
> 2 files changed, 2 insertions(+), 0 deletions(-)
> 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.7.2.5

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