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