优化了初始脚本
diff --git a/src/main/resources/data-postgresql.sql b/src/main/resources/data-postgresql.sql
index bdea1da..89ba0ee 100644
--- a/src/main/resources/data-postgresql.sql
+++ b/src/main/resources/data-postgresql.sql
@@ -8,6 +8,8 @@
insert into TB_VOUCHERNOCTL(VOUCHERTYPE,PERIODMONTH,VOUCHERNO,"tenantid")
values (1,to_number(to_char(CURRENT_TIMESTAMP,'MM'),'99'),0, , '{tenantid}');
+update TB_SUBJECT set opendate = to_number(to_char(CURRENT_TIMESTAMP,'yyyymmdd'),'99999999');
+
CREATE SEQUENCE seq_refno;
--------- end of script
diff --git a/src/main/resources/data.sql b/src/main/resources/data.sql
index b16d5a4..e434042 100644
--- a/src/main/resources/data.sql
+++ b/src/main/resources/data.sql
@@ -431,7 +431,7 @@
VALUES ('660102', 2, 'y', 1, '6601', 20190430, 2, '积分抵扣款', 6, '{tenantid}');
INSERT INTO "tb_subject" ("subjno", "balflag", "displayflag", "endflag", "fsubjno", "opendate", "subjlevel", "subjname", "subjtype", "tenantid")
VALUES ('6602', 2, 'y', 1, NULL, 20190430, 1, '管理费收入', 6, '{tenantid}');
-update TB_SUBJECT set opendate = to_number(to_char(CURRENT_TIMESTAMP,'yyyymmdd'),'99999999');
+
INSERT INTO "tb_sourcetype" ("sourcetype", "checkable", "paydesc", "enable", "charge_enable", "consume_enable", "anonymous_enable", "reversable", "tenantid")