commit ea5744baeced5bc37124b71c077866a09e24724d
author Tang Cheng <cheng.tang@supwisdom.com> 周三 6月 26 15:13:15 2019 +0800
committer Tang Cheng <cheng.tang@supwisdom.com> 周三 6月 26 15:15:26 2019 +0800
tree cf4021d5ea2320262777bdf4f966e772e9bace0c
parent 30fec3d336a81c8e4eecf9885a34acb88fd4e2fd

整理sql语句

src/main/resources/import.sql

diff --git a/src/main/resources/import.sql b/src/main/resources/import.sql
index 4760e09..544e132 100644
--- a/src/main/resources/import.sql
+++ b/src/main/resources/import.sql
@@ -11,7 +11,8 @@
 	VALUES ('1', 'LOR2IwRkbOjp+sVG9KR2BpHZbwGKepS4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
 
 
-INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon", "menuurl", "name", "ordernum", "parentid")
+INSERT INTO "tb_function" ("id", "createtime", "isleaf", "lastsaved", "menuicon",
+"menuurl", "name", "ordernum", "parentid", "tenantid")
 VALUES ('1', NULL, '0', NULL, 'layui-icon-home', '#', '主页', '1', '-1'),
 ('2', NULL, '1', NULL, 'layui-icon-home', '/home/console', '控制台', '1', '1'),
 ('3', NULL, '0', NULL, 'layui-icon-set', '#', '系统中心', '2', '-1'),
@@ -40,6 +41,36 @@
 ('31', NULL, '1', NULL, '', '/report/shopbusiness', '商户营业情况表', NULL, '20');
 
 
+
+INSERT INTO "public"."tb_role_function" ("id", "functionid", "roleid", "permissions")
+VALUES
+('ff8080816b7947ed016b7955772c0032', '1', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b7955772d0033', '2', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b7955772d0034', '3', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b7955772d0035', '5', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557730003b', '6', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577310041', '4', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557732004a', '9', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557732004c', '7', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557732004d', '23', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577330052', '25', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557733005a', '20', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557733005b', '29', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557733005d', '30', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557733005f', '31', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577340061', '19', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577340062', '21', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577350068', '24', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557735006a', '22', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557735006c', '26', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557735006d', '27', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557735006f', '28', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577350071', '10', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577350072', '11', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577360074', '17', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b79557736007b', '12', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL),
+('ff8080816b7947ed016b795577370081', '18', 'd1yctWs5+ks0iQN3m9bUvRHus6HbKbrs', NULL);
+
 Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('5','5','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
 Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('1','1','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');
 Insert into TB_ROLE_FUNCTION (ID,FUNCTIONID,ROLEID) values ('2','2','d1yctWs5+ks0iQN3m9bUvRHus6HbKbrs');