Cleanup.

[fa-stable.git] / sql / en_US-new.sql

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index 613b2b73c0385c79f7309b26535f1bfb49be0038..9eda623314ab75f813cd576e9461a8e4f757a1eb 100644 (file)
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -501,6 +501,7 @@ CREATE TABLE `0_cust_branch` (
   `br_post_address` tinytext NOT NULL,
   `group_no` int(11) NOT NULL default '0',
   `notes` tinytext NOT NULL,
+  `rep_lang` char(5) default NULL,
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`branch_code`,`debtor_no`),
   KEY `branch_code` (`branch_code`),
@@ -587,6 +588,7 @@ CREATE TABLE `0_debtors_master` (
   `email` varchar(100) NOT NULL default '',
   `tax_id` varchar(55) NOT NULL default '',
   `curr_code` char(3) NOT NULL default '',
+  `rep_lang` char(5) default NULL,
   `sales_type` int(11) NOT NULL default '1',
   `dimension_id` int(11) NOT NULL default '0',
   `dimension2_id` int(11) NOT NULL default '0',
@@ -667,7 +669,7 @@ CREATE TABLE `0_fiscal_year` (
 
 ### Data of table `0_fiscal_year` ###
 
-INSERT INTO `0_fiscal_year` VALUES ('1', '2008-01-01', '2008-12-31', '0');
+INSERT INTO `0_fiscal_year` VALUES ('1', '2009-01-01', '2009-12-31', '0');
 
 
 ### Structure of table `0_gl_trans` ###
@@ -1527,6 +1529,7 @@ CREATE TABLE `0_suppliers` (
   `website` varchar(100) NOT NULL default '',
   `bank_account` varchar(60) NOT NULL default '',
   `curr_code` char(3) default NULL,
+  `rep_lang` char(5) default NULL,
   `payment_terms` int(11) default NULL,
   `dimension_id` int(11) default '0',
   `dimension2_id` int(11) default '0',
@@ -1584,6 +1587,7 @@ INSERT INTO `0_sys_prefs` VALUES ('time_zone', 'setup.company', 'tinyint', '1',
 INSERT INTO `0_sys_prefs` VALUES ('add_pct', 'setup.company', 'int', '5', '-1');
 INSERT INTO `0_sys_prefs` VALUES ('round_to', 'setup.company', 'int', '5', '1');
 INSERT INTO `0_sys_prefs` VALUES ('login_tout', 'setup.company', 'smallint', '6', '600');
+INSERT INTO `0_sys_prefs` VALUES ('auto_curr_reval','setup.company', 'smallint','6', '1');
 INSERT INTO `0_sys_prefs` VALUES ('past_due_days', 'glsetup.general', 'int', '11', '30');
 INSERT INTO `0_sys_prefs` VALUES ('profit_loss_year_act', 'glsetup.general', 'varchar', '15', '9990');
 INSERT INTO `0_sys_prefs` VALUES ('retained_earnings_act', 'glsetup.general', 'varchar', '15', '3590');