[Koha-patches] [PATCH 1/2] Bug 14179 - Alters currency field to VARCHAR(255)

[Indranil Das Gupta]

Alters `currency`.`currency` column from VARCHAR(10) to VARCHAR(255)
---
 .../data/mysql/atomicupdate/bug_14179-alter-currency-table.sql      | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql

diff --git a/installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql b/installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql
new file mode 100644
index 0000000..e6a06e6
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql
@@ -0,0 +1,6 @@
+--
+-- Alter `currency` column from VARCHAR(10) to VARCHAR(255)
+--
+
+ALTER TABLE `currency`
+  MODIFY COLUMN `currency` VARCHAR(255) NOT NULL DEFAULT '';
-- 
1.9.1