Added per supplier/customer document language selection.

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

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index afb3e9206bdefda782fcf0b39f67018055ddb555..0a52f483453daaf489b5f502808d90850122aa7e 100644 (file)
--- a/sql/alter2.3.sql
+++ b/sql/alter2.3.sql
@@ -152,3 +152,11 @@ 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');