From 22c84933870f016a7c124410151bc61906d93244 Mon Sep 17 00:00:00 2001 From: Joe Hunt Date: Thu, 16 Feb 2012 08:46:07 +0100 Subject: [PATCH] 0000684: Space for Legal Text is not enough. Extended to a text field. --- sql/alter2.4.sql | 5 +++-- sql/en_US-demo.sql | 4 ++-- sql/en_US-new.sql | 2 +- 3 files changed, 6 insertions(+), 5 deletions(-) diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql index 218c1ce5..ca5f6dc9 100644 --- a/sql/alter2.4.sql +++ b/sql/alter2.4.sql @@ -34,5 +34,6 @@ UPDATE `0_tax_group_items` tgi WHERE tax_shipping=1 AND tgi.tax_group_id=0_tax_groups.id AND tgi.tax_type_id=0_tax_types.id); ALTER TABLE `0_tax_groups` DROP COLUMN `tax_shipping`; ALTER TABLE `0_tax_group_items` DROP COLUMN `rate`; -ALTER TABLE 0_sales_order_details ADD KEY `stkcode` (`stk_code`); -ALTER TABLE 0_purch_order_details ADD KEY `itemcode` (`item_code`); +ALTER TABLE `0_sales_order_details` ADD KEY `stkcode` (`stk_code`); +ALTER TABLE `0_purch_order_details` ADD KEY `itemcode` (`item_code`); +ALTER TABLE `0_sys_prefs` CHANGE `value` `value` TEXT NOT NULL DEFAULT ''; diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index d8281297..38cb4958 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -2010,7 +2010,7 @@ CREATE TABLE IF NOT EXISTS `0_sys_prefs` ( `category` varchar(30) default NULL, `type` varchar(20) NOT NULL default '', `length` smallint(6) default NULL, - `value` tinytext, + `value` text, PRIMARY KEY (`name`), KEY `category` (`category`) ) ENGINE=MyISAM; @@ -2193,7 +2193,7 @@ CREATE TABLE IF NOT EXISTS `0_tax_group_items` ( -- Dumping data for table `0_tax_group_items` -- -INSERT INTO `0_tax_group_items` VALUES(1, 1, 5, 1); +INSERT INTO `0_tax_group_items` VALUES(1, 1, 1); -- -------------------------------------------------------- diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index f9d81ce4..c80bd314 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1769,7 +1769,7 @@ CREATE TABLE IF NOT EXISTS `0_sys_prefs` ( `category` varchar(30) default NULL, `type` varchar(20) NOT NULL default '', `length` smallint(6) default NULL, - `value` tinytext, + `value` text, PRIMARY KEY (`name`), KEY `category` (`category`) ) ENGINE=MyISAM; -- 2.30.2