@@ -, +, @@ Currencies & Exchange rates symbol Nu. and rate of 0.016) and save it. % perl installer/data/mysql/updatedatabase.pl --- .../data/mysql/atomicupdate/bug_14179-alter-currency-table.sql | 6 ++++++ installer/data/mysql/kohastructure.sql | 2 +- 2 files changed, 7 insertions(+), 1 deletion(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql --- a/installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql +++ a/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 ''; --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -742,7 +742,7 @@ CREATE TABLE `class_sources` ( DROP TABLE IF EXISTS `currency`; CREATE TABLE `currency` ( - `currency` varchar(10) NOT NULL default '', + `currency` varchar(255) NOT NULL default '', `symbol` varchar(5) default NULL, `isocode` varchar(5) default NULL, `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, --