X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.2.sql;h=a4d70802123690d67dcd34bb1c13a1f8c1153740;hb=28e7dac267b65d8163ca41c452c42706d0ffb2dd;hp=486b1f50d758bb91d747662262a3231ad302aff5;hpb=4b9166fc40747ca33ce4a9d5dc7467d9b7caf86b;p=fa-stable.git

diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql
index 486b1f50..a4d70802 100644
--- a/sql/alter2.2.sql
+++ b/sql/alter2.2.sql
@@ -105,4 +105,6 @@ ALTER TABLE `0_sales_orders` ADD COLUMN `reference` varchar(100) NOT NULL DEFAUL
 ALTER TABLE `0_sales_orders` DROP PRIMARY KEY;
 ALTER TABLE `0_sales_orders` ADD PRIMARY KEY ( `trans_type` , `order_no` ); 
 UPDATE `0_sales_orders`	SET `reference`=`order_no` WHERE 1;
-INSERT INTO `0_sys_types` (`type_id`, `type_no`, `next_reference`) VALUES (32, 0, '1');
\ No newline at end of file
+INSERT INTO `0_sys_types` (`type_id`, `type_no`, `next_reference`) VALUES (32, 0, '1');
+
+ALTER TABLE `0_bank_accounts` ADD COLUMN `dflt_curr_act` TINYINT(1) NOT NULL default '0' AFTER `bank_curr_code`;