Changed hardcoded trans days in inquiries (30) to be a user preference.

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

diff --git a/sql/alter2.4.sql b/sql/alter2.4.sql
index 13f10736bf6966a4e8222c52d387e21ad8236cdd..c0fdca279ba582820837a3cbf6a654d01b00b3a0 100644 (file)
--- a/sql/alter2.4.sql
+++ b/sql/alter2.4.sql
@@ -44,4 +44,5 @@ UPDATE `0_debtor_trans` tr, `0_trans_tax_details` td SET tr.tax_included=td.incl
        WHERE tr.`type`=td.trans_type AND tr.trans_no=td.trans_no AND td.included_in_price
 ALTER TABLE `0_bank_accounts` ADD COLUMN `bank_charge_act` varchar(15) NOT NULL DEFAULT '' AFTER `id`;
 UPDATE `0_bank_accounts` SET `bank_charge_act`=(SELECT `value` FROM 0_sys_prefs WHERE name='bank_charge_act'); 
-       
\ No newline at end of file
+ALTER TABLE `0_users` ADD `transaction_days` INT( 6 ) NOT NULL COMMENT 'Transaction days' AFTER `startup_tab`; 
+UPDATE `0_users` SET `transaction_days`=30;