Cleanup.

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

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 4e257bf4e4e612eefa3d20e019e0e795a5863358..2480537740992b61f8c07ab13c767830c2da64b1 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -318,7 +318,7 @@ DROP TABLE IF EXISTS `0_chart_types`;
 CREATE TABLE `0_chart_types` (
   `id` varchar(10) NOT NULL,
   `name` varchar(60) NOT NULL default '',
-  `class_id` varchart(3) NOT NULL default '',
+  `class_id` varchar(3) NOT NULL default '',
   `parent` varchar(10) NOT NULL default '-1',
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`id`),
@@ -710,13 +710,14 @@ CREATE TABLE `0_fiscal_year` (
   PRIMARY KEY  (`id`),
   UNIQUE KEY(`begin`),
   UNIQUE KEY(`end`)
-) TYPE=InnoDB AUTO_INCREMENT=3 ;
+) TYPE=InnoDB AUTO_INCREMENT=4 ;
 
 
 ### 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 ('2', '2009-01-01', '2009-12-31', '0');
+INSERT INTO `0_fiscal_year` VALUES ('3', '2010-01-01', '2010-12-31', '0');
 
 
 ### Structure of table `0_gl_trans` ###
@@ -1808,6 +1809,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');