projects
/
fa-stable.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
e0544ed
)
Created new fiscal years in en_US-demo.sql
author
Joe Hunt
<joe.hunt.consulting@gmail.com>
Wed, 13 Jan 2016 07:21:19 +0000
(08:21 +0100)
committer
Joe Hunt
<joe.hunt.consulting@gmail.com>
Wed, 13 Jan 2016 07:21:19 +0000
(08:21 +0100)
sql/en_US-demo.sql
patch
|
blob
|
history
diff --git
a/sql/en_US-demo.sql
b/sql/en_US-demo.sql
index 08dc0230ccb908e5f37937fbb6ab4e7f9ad0df88..28cdcb0c1ae76805a5eaffb363948dd7e1648e9e 100644
(file)
--- a/
sql/en_US-demo.sql
+++ b/
sql/en_US-demo.sql
@@
-818,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`
@@
-826,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`