X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Falter2.3.sql;h=b52bfa475e01349debab4bbb3b97376607f12de3;hb=efc1a9ce400be6233323af9c193ab9460407bcf6;hp=afb3e9206bdefda782fcf0b39f67018055ddb555;hpb=3bda75fb8d3dde20fdd32c383db8b6ed750b501c;p=fa-stable.git

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index afb3e920..b52bfa47 100644
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -152,3 +152,13 @@ ALTER TABLE `0_chart_types` CHANGE `parent` `parent` VARCHAR(10) NOT NULL DEFAUL
 ALTER TABLE `0_chart_types` CHANGE `class_id` `class_id` VARCHAR(3) NOT NULL DEFAULT '';
 .
 UPDATE `0_chart_types` SET parent='' WHERE parent='0' OR parent='-1';
+
+ALTER TABLE `0_debtors_master` ADD COLUMN  `rep_lang` char(5) default NULL;
+UPDATE `0_debtors_master` set `rep_lang`= 'en_GB' WHERE `curr_code`<>(SELECT value FROM `0_sys_prefs` WHERE name='curr_default');
+
+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');