Attachment 33306 Details for Bug 12993 – 32018: Bug 12993: Add a default tax rate on item types - DB changes

[patch] 32018: Bug 12993: Add a default tax rate on item types - DB changes

0002-Bug-12993-Add-a-default-tax-rate-on-item-types-DB-ch.patch (text/plain), 2.08 KB, created by Paola Rossi on 2014-11-06 14:01:27 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Paola Rossi

Created: 2014-11-06 14:01:27 UTC

Size: 2.08 KB

patch

obsolete

>From 9fd992759e1d9f823b614be7be26b2d48a0dc45b Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Thu, 25 Sep 2014 11:21:06 +0200
>Subject: [PATCH 2/3] Bug 12993: Add a default tax rate on item types - DB
> changes
>
>This patch adds a new DB field: itemtypes.gstrate
>
>Signed-off-by: Paola Rossi <paola.rossi@cineca.it>
>---
> installer/data/mysql/kohastructure.sql |    1 +
> installer/data/mysql/updatedatabase.pl |   10 ++++++++++
> 2 files changed, 11 insertions(+)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 12fb181..240fb21 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1246,6 +1246,7 @@ CREATE TABLE `itemtypes` ( -- defines the item types
>   itemtype varchar(10) NOT NULL default '', -- unique key, a code associated with the item type
>   description mediumtext, -- a plain text explanation of the item type
>   rentalcharge double(16,4) default NULL, -- the amount charged when this item is checked out/issued
>+  gstrate decimal(6,4)  default NULL, -- default gst rate to use when ordering this item type
>   notforloan smallint(6) default NULL, -- 1 if the item is not for loan, 0 if the item is available for loan
>   imageurl varchar(200) default NULL, -- URL for the item type icon
>   summary text, -- information from the summary field, may include HTML
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 7b7255d..e96b92f 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -9005,6 +9005,16 @@ if ( CheckVersion($DBversion) ) {
>     SetVersion($DBversion);
> }
> 
>+$DBversion = '3.17.00.XXX';
>+if ( CheckVersion($DBversion) ) {
>+    $dbh->do(q{
>+        ALTER TABLE itemtypes ADD COLUMN gstrate decimal(6,4) DEFAULT NULL AFTER rentalcharge
>+    });
>+    print "Upgrade to $DBversion done (Bug XXXXX: Add DB field itemtypes.gstrate)\n";
>+    SetVersion($DBversion);
>+}
>+
>+
> =head1 FUNCTIONS
> 
> =head2 TableExists($table)
>-- 
>1.7.10.4
>

Actions: View | Diff | Splinter Review

Attachments on bug 12993: 31863 | 32018 | 32284 | 33305 | 33306 | 33307 | 34797 | 35394 | 39566 | 39567 | 39568 | 39569 | 45538 | 45539 | 45540 | 45541 | 45542 | 45543