From ea5744baeced5bc37124b71c077866a09e24724d Mon Sep 17 00:00:00 2001 From: Tang Cheng Date: Wed, 26 Jun 2019 15:13:15 +0800 Subject: [PATCH] =?utf8?q?=E6=95=B4=E7=90=86sql=E8=AF=AD=E5=8F=A5?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- src/main/resources/import.sql | 33 ++++++++++++++++++++++++++++++++- 1 file changed, 32 insertions(+), 1 deletion(-) diff --git a/src/main/resources/import.sql b/src/main/resources/import.sql index 4760e093..544e132e 100644 --- a/src/main/resources/import.sql +++ b/src/main/resources/import.sql @@ -11,7 +11,8 @@ INSERT INTO tb_oper_role( 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 @@ VALUES ('1', NULL, '0', NULL, 'layui-icon-home', '#', '主页', '1', '-1'), ('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'); -- 2.17.1