完善代码，整理sql，初始数据
diff --git a/sql/sample-user.sql b/sql/sample-user.sql
index ff3e654..6c5e727 100644
--- a/sql/sample-user.sql
+++ b/sql/sample-user.sql
@@ -31,7 +31,6 @@
COMMENT = '用户表';
-
CREATE TABLE `TB_U_GROUP` (
`ID` VARCHAR(100) NOT NULL COMMENT '',
`COMPANY_ID` VARCHAR(100) COMMENT 'CompanyID',
@@ -54,7 +53,6 @@
COMMENT = '用户组表';
-
CREATE TABLE `TB_U_ROLE` (
`ID` VARCHAR(100) NOT NULL COMMENT '',
`COMPANY_ID` VARCHAR(100) COMMENT 'CompanyID',
@@ -97,6 +95,7 @@
COMMENT = '用户组 - 用户表';
+
CREATE TABLE `TB_U_USER_ROLE` (
`ID` VARCHAR(100) NOT NULL COMMENT '',
`COMPANY_ID` VARCHAR(100) COMMENT 'CompanyID',
@@ -153,13 +152,14 @@
`MEMO` VARCHAR(500) COMMENT '备注',
`STATUS` VARCHAR(10) NOT NULL COMMENT '状态（1 启用，0 停用）',
- `TYPE` VARCHAR(10) NOT NULL COMMENT '类型（1 应用，2 页面，3 操作）',
+ `TYPE_` VARCHAR(10) NOT NULL COMMENT '类型（1 应用，2 页面，3 操作）',
`URL` VARCHAR(500) COMMENT 'URL地址',
`PARENT_ID` VARCHAR(10) NOT NULL COMMENT '父级ID',
- `LEVEL` VARCHAR(10) NOT NULL COMMENT '层次',
- `LFT` INT(11) COMMENT '左序',
- `RGT` INT(11) COMMENT '右序',
+ `ORDER_` INT(11) NOT NULL COMMENT '排序',
+ `LEVEL_` INT(11) NOT NULL COMMENT '层次',
+ `LFT` INT(11) NOT NULL COMMENT '左索引',
+ `RGT` INT(11) NOT NULL COMMENT '右索引',
PRIMARY KEY (`ID`),
UNIQUE KEY `UQ_CODE` (`COMPANY_ID`,`CODE`)
@@ -186,3 +186,70 @@
)
COMMENT = '角色 - 权限表';
+
+
+
+insert into TB_U_USER (ID, DELETED, USERNAME, PASSWORD, ENABLED, ACCOUNT_NON_EXPIRED, ACCOUNT_NON_LOCKED, CREDENTIALS_NON_EXPIRED, NAME, STATUS)
+values ('1', 1, 'admin', 'admin', 1, 1, 1, 1, 'Admin', '1');
+
+commit;
+
+
+insert into TB_U_GROUP (ID, DELETED, CODE, NAME, STATUS)
+values ('1', 1, 'users', '所有用户', '1');
+
+commit;
+
+
+insert into TB_U_ROLE (ID, DELETED, CODE, NAME, STATUS)
+values ('1', 1, 'administrator', '超级管理员', '1');
+insert into TB_U_ROLE (ID, DELETED, CODE, NAME, STATUS)
+values ('2', 1, 'user', '普通用户', '1');
+
+commit;
+
+
+insert into TB_U_USER_GROUP (ID, DELETED, USER_ID, GROUP_ID)
+values ('1_1', 1, '1', '1');
+
+commit;
+
+
+insert into TB_U_USER_ROLE (ID, DELETED, USER_ID, ROLE_ID)
+values ('1_1', 1, '1', '1');
+
+insert into TB_U_USER_ROLE (ID, DELETED, USER_ID, ROLE_ID)
+values ('1_2', 1, '1', '2');
+
+commit;
+
+
+insert into TB_U_GROUP_ROLE (ID, DELETED, GROUP_ID, ROLE_ID)
+values ('1', 1, '1', '2');
+
+commit;
+
+
+insert into TB_U_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('1', 1, 'client', 'Client', '1', '1', '', '0', 1, 1, 1, 10);
+
+insert into TB_U_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10000', 1, 'admin.system', '系统管理', '1', '2', '', '1', 1000, 2, 2, 9);
+
+insert into TB_U_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10100', 1, 'admin.system.user', '用户管理', '1', '2', '', '10000', 10100, 3, 3, 4);
+insert into TB_U_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10200', 1, 'admin.system.role', '角色管理', '1', '2', '', '10000', 10200, 3, 5, 6);
+insert into TB_U_PERMISSION (ID, DELETED, CODE, NAME, STATUS, TYPE_, URL, PARENT_ID, ORDER_, LEVEL_, LFT, RGT)
+values ('10300', 1, 'admin.system.permission', '权限管理', '1', '2', '', '10000', 10300, 3, 7, 8);
+
+commit;
+
+
+insert into TB_U_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)
+values ('2_1', 1, '2', '1');
+
+insert into TB_U_ROLE_PERMISSION (ID, DELETED, ROLE_ID, PERMISSION_ID)
+select CONCAT('1_', ID), 1, '1', ID from TB_U_PERMISSION;
+
+commit;