Added currency defualt bank accounts used in reporting instead of manually selected...

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

diff --git a/sql/alter2.2.sql b/sql/alter2.2.sql
index 486b1f50d758bb91d747662262a3231ad302aff5..a4d70802123690d67dcd34bb1c13a1f8c1153740 100644 (file)
--- 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`;