commit 91d822d47f968c9f18cc7f3712416b1cbc02d780
author Tang Cheng <cheng.tang@supwisdom.com> 周二 7月 02 21:54:52 2019 +0800
committer Tang Cheng <cheng.tang@supwisdom.com> 周三 7月 10 10:17:14 2019 +0800
tree 24fc8f09e0e4476ad04a410e17726b536f17d953
parent ae9dfe15e711efe11b39e26523fd1716f2556b46

优化了初始脚本

src/main/resources/data-postgresql.sql

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