From d3c4abcaebfb3db5287a0f19d5f0c5e2bf254f0b Mon Sep 17 00:00:00 2001 From: =?utf8?q?=E5=88=98=E6=B4=AA=E9=9D=92?= Date: Thu, 19 Sep 2019 18:13:19 +0800 Subject: [PATCH] =?utf8?q?docs:=20=E5=88=9D=E5=A7=8B=E6=95=B0=E6=8D=AEsql?= MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit --- sql/base.sql | 14 ++++++++++---- 1 file changed, 10 insertions(+), 4 deletions(-) diff --git a/sql/base.sql b/sql/base.sql index a7bdfb8..d27bd71 100644 --- a/sql/base.sql +++ b/sql/base.sql @@ -311,7 +311,7 @@ COMMENT = '角色 - 权限关联表'; insert into TB_BASE_ACCOUNT (ID, DELETED, USERNAME, PASSWORD, ENABLED, ACCOUNT_NON_EXPIRED, ACCOUNT_NON_LOCKED, CREDENTIALS_NON_EXPIRED, NAME, STATUS) -values ('1', 0, 'admin', 'admin', 1, 1, 1, 1, 'Admin', '1'); +values ('1', 0, 'swadmin', 'swadmin', 1, 1, 1, 1, 'Supwisdom Admin', '1'); commit; @@ -353,10 +353,10 @@ commit; insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) -values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 10); +values ('1', 0, 'admin', '树维管理后台', '1', '1', '', '1', '0', 1, 1, 1, 21); insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) -values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 1, 14); +values ('10000', 0, 'admin.base', '基础管理', '1', '2', '', '1', '1', 10000, 1, 1, 18); insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) values ('10100', 0, 'admin.base.account', '帐号管理', '1', '2', '', '1', '10000', 10100, 2, 2, 3); @@ -372,7 +372,13 @@ insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APP values ('10600', 0, 'admin.base.resource', '资源管理', '1', '2', '', '1', '10000', 10600, 2, 12, 13); insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) -values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 1, 14); +values ('10700', 0, 'admin.base.application', '应用管理', '1', '2', '', '1', '10000', 10700, 2, 14, 15); +insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) +values ('10800', 0, 'admin.base.route', '路由管理', '1', '2', '', '1', '10000', 10800, 2, 16, 17); + + +insert into TB_BASE_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, APPLICATION_ID, PARENT_ID, ORDER_, LEVEL_, LFT, RGT) +values ('20000', 0, 'admin.system', '系统管理', '1', '2', '', '1', '1', 20000, 1, 19, 20); commit; -- 2.17.1