0000684: Space for Legal Text is not enough. Extended to a text field.

[fa-stable.git] / sql / alter2.4.sql

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index 218c1ce5d385a08e2a95e7d4959e784cb69ca8ee..ca5f6dc9ac29e8235357fc3fca0d0c384bd71370 100644 (file)
--- 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 '';