From e6088876be6803170c81b7ebbf6c2855a32d8f69 Mon Sep 17 00:00:00 2001 From: Indranil Das Gupta Date: Mon, 11 May 2015 04:28:54 +0530 Subject: [PATCH] Bug 14179 - Alters currency field to VARCHAR(255) 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