X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.4.sql;h=73bbcef51e2df4f2767267c8980358257808ed30;hb=3e802cbb66e3b502ae3dcd5b120c429bf1469305;hp=c2fe4c3d230251afb332c078e544db2fd676276f;hpb=b1c9712c6042b26d43ce9c78c77d078ef1906a02;p=fa-stable.git

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index c2fe4c3d..73bbcef5 100644
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -34,4 +34,7 @@ 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_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 '';
 ALTER TABLE `0_cust_branch` ADD COLUMN `bank_account` varchar(60) DEFAULT NULL AFTER `notes`;