X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Falter2.3.sql;h=b52bfa475e01349debab4bbb3b97376607f12de3;hb=efc1a9ce400be6233323af9c193ab9460407bcf6;hp=0a52f483453daaf489b5f502808d90850122aa7e;hpb=e6cf9a74a7852b3ae2e4ebb794a755b6a90ad486;p=fa-stable.git diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql index 0a52f483..b52bfa47 100644 --- a/sql/alter2.3.sql +++ b/sql/alter2.3.sql @@ -160,3 +160,5 @@ ALTER TABLE `0_cust_branch` ADD COLUMN `rep_lang` char(5) default NULL; ALTER TABLE `0_suppliers` ADD COLUMN `rep_lang` char(5) default NULL; UPDATE `0_suppliers` set `rep_lang`= 'en_GB' WHERE `curr_code`<>(SELECT value FROM `0_sys_prefs` WHERE name='curr_default'); + +INSERT INTO `0_sys_prefs` (name, category, type, length, value) VALUES ('auto_curr_reval','setup.company', 'smallint','6', '1');