Attachment 39568 Details for Bug 12993 – Attachment to Bug 12993 - Add a default tax rate on item types

[patch] Attachment to Bug 12993 - Add a default tax rate on item types

Bug-12993-Add-a-default-tax-rate-on-item-types---D.patch (text/plain), 1.91 KB, created by Jonathan Druart on 2015-05-27 08:10:26 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2015-05-27 08:10:26 UTC

Size: 1.91 KB

patch

obsolete

>From 755c813c4e7b85610983dade1eb3781bbcbada53 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] 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>
>---
> .../data/mysql/atomicupdate/bug-12993_DB-field-itemtypes.gstrate.sql     | 1 +
> installer/data/mysql/kohastructure.sql                                   | 1 +
> 2 files changed, 2 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug-12993_DB-field-itemtypes.gstrate.sql
>
>diff --git a/installer/data/mysql/atomicupdate/bug-12993_DB-field-itemtypes.gstrate.sql b/installer/data/mysql/atomicupdate/bug-12993_DB-field-itemtypes.gstrate.sql
>new file mode 100644
>index 0000000..0fd68c1
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug-12993_DB-field-itemtypes.gstrate.sql
>@@ -0,0 +1 @@
>+ALTER TABLE itemtypes ADD COLUMN gstrate decimal(6,4) DEFAULT NULL AFTER rentalcharge;
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index c41710c..39bc7ba 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -1275,6 +1275,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
>-- 
>2.1.0

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