1+ INSERT INTO ` user_info` ` uid` ` username` ` name` ` password` ` salt` ` state` VALUES (' 1' ' admin' ' 管理员' ' d3c59d25033dbf980d29554025c23a75' ' 8d78869f470951332959580424d4bf4f' 0 );
12INSERT INTO ` sys_permission` ` id` ` available` ` name` ` parent_id` ` parent_ids` ` permission` ` resource_type` ` url` VALUES (1 ,0 ,' 用户管理' 0 ,' 0/' ' userInfo:view' ' menu' ' userInfo/userList'
23INSERT INTO ` sys_permission` ` id` ` available` ` name` ` parent_id` ` parent_ids` ` permission` ` resource_type` ` url` VALUES (2 ,0 ,' 用户添加' 1 ,' 0/1' ' userInfo:add' ' button' ' userInfo/userAdd'
34INSERT INTO ` sys_permission` ` id` ` available` ` name` ` parent_id` ` parent_ids` ` permission` ` resource_type` ` url` VALUES (3 ,0 ,' 用户删除' 1 ,' 0/1' ' userInfo:del' ' button' ' userInfo/userDel'
4- INSERT INTO ` sys_role` ` id` ` available` ` description` ` role` VALUES (1 ,' 0' ' 管理员' ' admin'
5- INSERT INTO ` sys_role` ` id` ` available` ` description` ` role` VALUES (2 ,' 0' ' VIP会员' ' vip' INSERT INTO ` sys_role_permission` VALUES (' 1' ' 1'
5+ INSERT INTO ` sys_role` ` id` ` available` ` description` ` role` VALUES (1 ,0 ,' 管理员' ' admin'
6+ INSERT INTO ` sys_role` ` id` ` available` ` description` ` role` VALUES (2 ,0 ,' VIP会员' ' vip'
7+ INSERT INTO ` sys_role` ` id` ` available` ` description` ` role` VALUES (3 ,1 ,' test' ' test'
8+ INSERT INTO ` sys_role_permission` VALUES (' 1' ' 1'
69INSERT INTO ` sys_role_permission` ` permission_id` ` role_id` VALUES (1 ,1 );
7- INSERT INTO ` sys_role_permission` ` permission_id` ` role_id` VALUES (1 ,2 );
8- INSERT INTO ` sys_role_permission` ` permission_id` ` role_id` VALUES (1 ,3 );
9- INSERT INTO ` sys_user_role` ` role_id` ` uid` VALUES (1 ,1 );
10- INSERT INTO ` user_info` ` uid` ` username` ` name` ` password` ` salt` ` state` VALUES (' 1' ' admin' ' 管理员' ' d3c59d25033dbf980d29554025c23a75' ' 8d78869f470951332959580424d4bf4f' 0 );
11-
12-
10+ INSERT INTO ` sys_role_permission` ` permission_id` ` role_id` VALUES (2 ,1 );
11+ INSERT INTO ` sys_role_permission` ` permission_id` ` role_id` VALUES (3 ,2 );
12+ INSERT INTO ` sys_user_role` ` role_id` ` uid` VALUES (1 ,1 );