projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Fixed problems with excel report generation.
[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`),
`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 ;
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`)
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`
--
-- 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(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`
--
-- 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`),
`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;
KEY `tran_date` (`tran_date`)
) ENGINE=InnoDB;