View | Details | Raw Unified | Return to bug 14179
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_14179-alter-currency-table.sql (+6 lines)
Line 0 Link Here
1
--
2
-- Alter `currency` column from VARCHAR(10) to VARCHAR(255)
3
--
4
5
ALTER TABLE `currency`
6
  MODIFY COLUMN `currency` VARCHAR(255) NOT NULL DEFAULT '';
(-)a/installer/data/mysql/kohastructure.sql (-2 / +1 lines)
Lines 742-748 CREATE TABLE `class_sources` ( Link Here
742
742
743
DROP TABLE IF EXISTS `currency`;
743
DROP TABLE IF EXISTS `currency`;
744
CREATE TABLE `currency` (
744
CREATE TABLE `currency` (
745
  `currency` varchar(10) NOT NULL default '',
745
  `currency` varchar(255) NOT NULL default '',
746
  `symbol` varchar(5) default NULL,
746
  `symbol` varchar(5) default NULL,
747
  `isocode` varchar(5) default NULL,
747
  `isocode` varchar(5) default NULL,
748
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
748
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
749
- 

Return to bug 14179