Fixed an array_combine object issue.

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

diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql
index 0c63c06f7125c994964092d564a5dcd803c49e9e..28cdcb0c1ae76805a5eaffb363948dd7e1648e9e 100644 (file)
--- a/sql/en_US-demo.sql
+++ b/sql/en_US-demo.sql
@@ -613,6 +613,7 @@ CREATE TABLE IF NOT EXISTS `0_cust_branch` (
   `notes` tinytext NOT NULL,
   `inactive` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`branch_code`,`debtor_no`),
+  KEY `branch_code` (`branch_code`),
   KEY `branch_ref` (`branch_ref`),
   KEY `group_no` (`group_no`)
 ) ENGINE=MyISAM  AUTO_INCREMENT=4 ;
@@ -817,7 +818,7 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
   PRIMARY KEY  (`id`),
   UNIQUE KEY `begin` (`begin`),
   UNIQUE KEY `end` (`end`)
-) ENGINE=InnoDB  AUTO_INCREMENT=3 ;
+) ENGINE=InnoDB  AUTO_INCREMENT=5 ;
 
 --
 -- Dumping data for table `0_fiscal_year`
@@ -825,6 +826,8 @@ CREATE TABLE IF NOT EXISTS `0_fiscal_year` (
 
 INSERT INTO `0_fiscal_year` VALUES(1, '2013-01-01', '2013-12-31', 0);
 INSERT INTO `0_fiscal_year` VALUES(2, '2014-01-01', '2014-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(3, '2015-01-01', '2015-12-31', 0);
+INSERT INTO `0_fiscal_year` VALUES(4, '2016-01-01', '2016-12-31', 0);
 
 --
 -- Table structure for table `0_gl_trans`
@@ -1977,7 +1980,9 @@ CREATE TABLE IF NOT EXISTS `0_supp_trans` (
   `alloc` double NOT NULL default '0',
   `tax_included` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`type`,`trans_no`),
-  KEY `supplier_id` (`supplier_id`,`supp_reference`),
+  KEY `supplier_id` (`supplier_id`),
+  KEY `SupplierID_2` (`supplier_id`,`supp_reference`),
+  KEY `type` (`type`),
   KEY `tran_date` (`tran_date`)
 ) ENGINE=InnoDB;