From 2c3c88f5d407a93906194deb59bfa6879203e041 Mon Sep 17 00:00:00 2001 From: Xia Kaixiang Date: Mon, 22 Apr 2019 17:40:36 +0800 Subject: [PATCH] =?utf8?q?=E6=B5=8B=E8=AF=95sql?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- config/application-devel-oracle.properties | 11 ++++++++--- sql/init_test.sql | 9 +++++++++ 2 files changed, 17 insertions(+), 3 deletions(-) diff --git a/config/application-devel-oracle.properties b/config/application-devel-oracle.properties index 3a3d0a65..50ff5981 100644 --- a/config/application-devel-oracle.properties +++ b/config/application-devel-oracle.properties @@ -1,11 +1,11 @@ spring.main.banner-mode=off # create and drop tables and sequences, loads import.sql -spring.jpa.hibernate.ddl-auto=create-drop +spring.jpa.hibernate.ddl-auto=update # Oracle settings spring.datasource.url=jdbc:oracle:thin:@172.28.201.101:47922:orcl -spring.datasource.username=ecardtest +spring.datasource.username=dlpay spring.datasource.password=kingstar spring.datasource.driver-class-oracle.jdbc.driver.OracleDriver @@ -13,4 +13,9 @@ spring.datasource.driver-class-oracle.jdbc.driver.OracleDriver redis.server=172.28.201.101 redis.port=16379 redis.password=kingstar -redis.database=0 \ No newline at end of file +redis.database=0 + +# jwt settings +jwt.secret=Zj5taLomEbrM0lk+NMQZbHfSxaDU1wekjT+kiC3YzDw= +# timeout seconds +jwt.expiration=3600 \ No newline at end of file diff --git a/sql/init_test.sql b/sql/init_test.sql index 3a210ae4..ceaf4643 100644 --- a/sql/init_test.sql +++ b/sql/init_test.sql @@ -12,4 +12,13 @@ INSERT INTO tb_oper_role( id, operid, role_id) VALUES ('1', 'LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); +-- 功能表 +Insert into TB_FUNCTION (ID,PARENT_ID,NAME,ORDER_NUM,MENU_URL,MENU_ICON,IS_LEAF) +values ('1','-1','系统中心',1,'#','layui-icon-set',0); +Insert into TB_FUNCTION (ID,PARENT_ID,NAME,ORDER_NUM,MENU_URL,MENU_ICON,IS_LEAF) +values ('2','1','管理员维护',1,'#','layui-icon-set',1); + +Insert into TB_ROLE_FUNCTION (ID,FUNCTION_ID,ROLE_ID) values ('1','1','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); +Insert into TB_ROLE_FUNCTION (ID,FUNCTION_ID,ROLE_ID) values ('2','2','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs'); + commit; \ No newline at end of file -- 2.17.1