Emailed reports can be send to multiply destinations, fixed email charset selection.

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

diff --git a/sql/alter2.3.sql b/sql/alter2.3.sql
index afb3e9206bdefda782fcf0b39f67018055ddb555..b52bfa475e01349debab4bbb3b97376607f12de3 100644 (file)
--- 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');