【小白专用】（C#）用户、角色、权限控制体系
2024-01-09 06:25:20
?我们在开发很多项目的时候,都会用到用户权限管理,我也在很多项目里做过权限控制,所以,我也总结出一套条理清晰的角色权限控制体系。本文采用RBAC（Role Based Access Control）的基本思想，RBAC（角色访问控制）的基本思想可简单地用用户--角色--权限来表示，即把整个访问控制过程分成两步：访问权限与角色相关联，角色再与用户关联，从而实现了用户与访问权限的逻辑分离?
??????? 由于RBAC实现了用户与访问权限的逻辑分离，因此它极大的方便了权限管理。例如，如果一个用户的职位发生变化，只要将用户当前的角色去掉，加入代表新职务或新任务的角色即可，角色/权限之间的变化比角色/用户关系之间的变化相对要慢得多，并且委派用户到角色不需要很多技术，可以由行政管理人员来执行，而配置权限到角色的工作比较复杂，需要一定的技术，可以由专门的技术人员来承担，但是不给他们委派用户的权限，这与现实中情况正好一致。利用.NET实现权限控制的基本思想是：根据角色访问控制（RBAC）的基本原理，给用户分配一个角色，每个角色对应不同模块的不同权限，同一个用户可属于不同的角色，对模块的操作权限取用户所属几个角色的最高权限
https://www.cnblogs.com/huangwen/articles/638050.html
/*
Navicat Premium Data Transfer
Source Server : localhost
Source Server Type : MySQL
Date: 1/8/2024 22:03:23
*/
-- ----------------------------
-- Table structure for tp_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group_access`;
CREATE TABLE `tp_auth_group_access` (
`uid` mediumint(8) UNSIGNED NOT NULL COMMENT '用户ID',
`group_id` mediumint(8) UNSIGNED NOT NULL COMMENT '分组ID',
`create_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '更新时间 ',
UNIQUE INDEX `uid_group_id`(`uid`, `group_id`) USING BTREE,
INDEX `uid`(`uid`) USING BTREE,
INDEX `group_id`(`group_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户组明细表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tp_auth_group_access
-- ----------------------------
INSERT INTO `tp_auth_group_access` VALUES (1, 1, 1553846932, 1553846932);
INSERT INTO `tp_auth_group_access` VALUES (2, 2, 1583728403, 1583748601);
-- ----------------------------
-- Table structure for tp_admin
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin`;
CREATE TABLE `tp_admin` (
`id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(1) NULL DEFAULT 1 COMMENT '状态',
`username` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
`login_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录时间',
`login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登录IP',
`nickname` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '昵称',
`image` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '头像',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员列表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tp_admin
-- ----------------------------
INSERT INTO `tp_admin` VALUES (1, 1580695622, 1583672118, 1, 'admin', '21232f297a57a5a743894a0e4a801fc3', 1639125170, '127.0.0.1', 'admin', '/static/plugins/AdminLTE/dist/img/user2-160x160.jpg');
INSERT INTO `tp_admin` VALUES (2, 1583727997, 1583749457, 0, 'test', 'e10adc3949ba59abbe56e057f20f883e', 1583748408, '127.0.0.1', 'test', '/static/plugins/AdminLTE/dist/img/user2-160x160.jpg');
-- ----------------------------
-- Table structure for tp_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_group`;
CREATE TABLE `tp_auth_group` (
`id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`status` tinyint(1) NULL DEFAULT 1 COMMENT '状态',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色组',
`rules` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '权限',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '角色组管理' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tp_auth_group
-- ----------------------------
INSERT INTO `tp_auth_group` VALUES (1, 1580633995, 1583732574, 1, '超级管理员', '0,157,92,93,94,95,96,97,98,99,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,171,172,173,174,175,176,268,269,270,271,272,273,274,275,276,158,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,106,107,108,109,110,111,112,113,114,115,100,101,102,103,104,105,159,163,164,165,166,167,168,169,170,160,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,39,40,41,42,43,44,45,46,47,48,187,177,178,179,180,181,182,183,184,185,186,161,49,50,51,52,53,54,55,56,57,58,69,70,71,72,73,74,75,76,77,78,59,60,61,62,63,64,65,66,67,68,79,80,81,82,83,84,85,86,87,88,162,1,2,3,4,5,6,7,8,29,30,31,32,33,34,35,36,37,38,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,260,261,262,263,264,265,266,267,');
INSERT INTO `tp_auth_group` VALUES (2, 1580634019, 1613634834, 1, '测试组', '0,157,92,93,95,99,9,10,12,16,19,20,22,26,171,174,268,269,271,274,277,278,158,116,117,119,123,125,126,128,132,134,106,107,109,113,100,101,105,159,163,164,165,166,167,169,170,160,136,137,139,143,147,148,150,154,39,40,42,46,187,177,178,180,184,281,161,49,50,52,56,69,70,72,76,59,60,62,66,79,80,82,86,162,1,2,4,8,29,30,32,36,188,189,190,192,196,199,200,202,206,209,210,212,216,219,220,222,226,229,230,232,236,239,240,242,246,249,252,256,258,260,261,262,263,264,265,266,267,');
-- ----------------------------
-- Table structure for tp_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `tp_auth_rule`;
CREATE TABLE `tp_auth_rule` (
`id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
`pid` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父ID',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '控制器/方法',
`title` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '权限名称',
`type` tinyint(1) NOT NULL DEFAULT 1,
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单状态',
`condition` char(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`sort` mediumint(8) NOT NULL DEFAULT 0 COMMENT '排序',
`auth_open` tinyint(2) NULL DEFAULT 1 COMMENT '验证权限',
`icon` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '图标名称',
`create_time` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`param` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '参数',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 283 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '规则表' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tp_auth_rule
-- ----------------------------
INSERT INTO `tp_auth_rule` VALUES (1, 162, 'Users/index', '会员管理', 1, 1, '', 71, 1, 'fa fa-user', 1580861016, 1580908159, '');
INSERT INTO `tp_auth_rule` VALUES (2, 1, 'Users/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (3, 1, 'Users/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (4, 1, 'Users/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (5, 1, 'Users/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (6, 1, 'Users/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (7, 1, 'Users/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (8, 1, 'Users/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861016, 1580861016, '');
INSERT INTO `tp_auth_rule` VALUES (9, 157, 'DictionaryType/index', '字典类型', 1, 1, '', 12, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (10, 9, 'DictionaryType/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (11, 9, 'DictionaryType/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (12, 9, 'DictionaryType/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (13, 9, 'DictionaryType/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (14, 9, 'DictionaryType/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (15, 9, 'DictionaryType/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (16, 9, 'DictionaryType/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (17, 9, 'DictionaryType/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (18, 9, 'DictionaryType/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861057, 1580861057, '');
INSERT INTO `tp_auth_rule` VALUES (19, 157, 'Dictionary/index', '字典数据', 1, 1, '', 13, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (20, 19, 'Dictionary/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (21, 19, 'Dictionary/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (22, 19, 'Dictionary/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (23, 19, 'Dictionary/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (24, 19, 'Dictionary/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (25, 19, 'Dictionary/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (26, 19, 'Dictionary/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (27, 19, 'Dictionary/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (28, 19, 'Dictionary/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861065, 1580861065, '');
INSERT INTO `tp_auth_rule` VALUES (29, 162, 'UsersType/index', '会员分组', 1, 1, '', 72, 1, 'fa fa-users', 1580861073, 1580908165, '');
INSERT INTO `tp_auth_rule` VALUES (30, 29, 'UsersType/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (31, 29, 'UsersType/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (32, 29, 'UsersType/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (33, 29, 'UsersType/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (34, 29, 'UsersType/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (35, 29, 'UsersType/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (36, 29, 'UsersType/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (37, 29, 'UsersType/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (38, 29, 'UsersType/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861073, 1580861073, '');
INSERT INTO `tp_auth_rule` VALUES (39, 160, 'FieldGroup/index', '字段分组', 1, 1, '', 43, 1, 'fa fa-bullseye', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (40, 39, 'FieldGroup/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (41, 39, 'FieldGroup/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (42, 39, 'FieldGroup/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (43, 39, 'FieldGroup/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (44, 39, 'FieldGroup/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (45, 39, 'FieldGroup/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (46, 39, 'FieldGroup/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (47, 39, 'FieldGroup/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (48, 39, 'FieldGroup/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861081, 1580861081, '');
INSERT INTO `tp_auth_rule` VALUES (49, 161, 'Link/index', '友情链接', 1, 1, '', 61, 1, 'fa fa-link', 1580861091, 1580908119, '');
INSERT INTO `tp_auth_rule` VALUES (50, 49, 'Link/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (51, 49, 'Link/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (52, 49, 'Link/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (53, 49, 'Link/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (54, 49, 'Link/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (55, 49, 'Link/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (56, 49, 'Link/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (57, 49, 'Link/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (58, 49, 'Link/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861091, 1580861091, '');
INSERT INTO `tp_auth_rule` VALUES (59, 161, 'AdType/index', '广告分组', 1, 1, '', 63, 1, 'fa fa-tv', 1580861099, 1580908135, '');
INSERT INTO `tp_auth_rule` VALUES (60, 59, 'AdType/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (61, 59, 'AdType/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (62, 59, 'AdType/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (63, 59, 'AdType/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (64, 59, 'AdType/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (65, 59, 'AdType/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (66, 59, 'AdType/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (67, 59, 'AdType/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (68, 59, 'AdType/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861099, 1580861099, '');
INSERT INTO `tp_auth_rule` VALUES (69, 161, 'Ad/index', '广告管理', 1, 1, '', 62, 1, 'fa fa-tv', 1580861106, 1580908132, '');
INSERT INTO `tp_auth_rule` VALUES (70, 69, 'Ad/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (71, 69, 'Ad/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (72, 69, 'Ad/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (73, 69, 'Ad/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (74, 69, 'Ad/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (75, 69, 'Ad/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (76, 69, 'Ad/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861106, 1580861106, '');
INSERT INTO `tp_auth_rule` VALUES (77, 69, 'Ad/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861107, 1580861107, '');
INSERT INTO `tp_auth_rule` VALUES (78, 69, 'Ad/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861107, 1580861107, '');
INSERT INTO `tp_auth_rule` VALUES (79, 161, 'Debris/index', '碎片管理', 1, 1, '', 64, 1, 'fa fa-gift', 1580861113, 1580908138, '');
INSERT INTO `tp_auth_rule` VALUES (80, 79, 'Debris/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (81, 79, 'Debris/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (82, 79, 'Debris/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (83, 79, 'Debris/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (84, 79, 'Debris/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (85, 79, 'Debris/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (86, 79, 'Debris/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (87, 79, 'Debris/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (88, 79, 'Debris/state', '操作-状态', 1, 0, '', 9, 1, '', 1580861113, 1580861113, '');
INSERT INTO `tp_auth_rule` VALUES (92, 157, 'System/index', '系统设置', 1, 1, '', 11, 1, 'fa fa-cog', 1580861127, 1580874204, '');
INSERT INTO `tp_auth_rule` VALUES (93, 92, 'System/add', '操作-添加', 1, 0, '', 1, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (94, 92, 'System/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (95, 92, 'System/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (96, 92, 'System/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (97, 92, 'System/del', '操作-删除', 1, 0, '', 5, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (98, 92, 'System/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (99, 92, 'System/export', '操作-导出', 1, 0, '', 7, 1, '', 1580861127, 1580861127, '');
INSERT INTO `tp_auth_rule` VALUES (100, 158, 'AdminLog/index', '管理员日志', 1, 1, '', 24, 1, 'fa fa-book', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (101, 100, 'AdminLog/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (102, 100, 'AdminLog/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (103, 100, 'AdminLog/del', '操作-删除', 1, 0, '', 5, 1, '', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (104, 100, 'AdminLog/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (105, 100, 'AdminLog/export', '操作-导出', 1, 0, '', 7, 1, '', 1580871750, 1580871750, '');
INSERT INTO `tp_auth_rule` VALUES (106, 158, 'AuthRule/index', '菜单规则', 1, 1, '', 23, 1, 'fa fa-bars', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (107, 106, 'AuthRule/add', '操作-添加', 1, 0, '', 1, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (108, 106, 'AuthRule/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (109, 106, 'AuthRule/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (110, 106, 'AuthRule/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (111, 106, 'AuthRule/del', '操作-删除', 1, 0, '', 5, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (112, 106, 'AuthRule/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (113, 106, 'AuthRule/export', '操作-导出', 1, 0, '', 7, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (114, 106, 'AuthRule/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (115, 106, 'AuthRule/state', '操作-状态', 1, 0, '', 9, 1, '', 1580871826, 1580871826, '');
INSERT INTO `tp_auth_rule` VALUES (116, 158, 'Admin/index', '管理员管理', 1, 1, '', 21, 1, 'fa fa-user', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (117, 116, 'Admin/add', '操作-添加', 1, 0, '', 1, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (118, 116, 'Admin/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (119, 116, 'Admin/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (120, 116, 'Admin/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (121, 116, 'Admin/del', '操作-删除', 1, 0, '', 5, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (122, 116, 'Admin/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (123, 116, 'Admin/export', '操作-导出', 1, 0, '', 7, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (124, 116, 'Admin/state', '操作-状态', 1, 0, '', 9, 1, '', 1580871882, 1580871882, '');
INSERT INTO `tp_auth_rule` VALUES (125, 158, 'AuthGroup/index', '角色组管理', 1, 1, '', 22, 1, 'fas fa-user-shield', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (126, 125, 'AuthGroup/add', '操作-添加', 1, 0, '', 1, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (127, 125, 'AuthGroup/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (128, 125, 'AuthGroup/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (129, 125, 'AuthGroup/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (130, 125, 'AuthGroup/del', '操作-删除', 1, 0, '', 5, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (131, 125, 'AuthGroup/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (132, 125, 'AuthGroup/export', '操作-导出', 1, 0, '', 7, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (133, 125, 'AuthGroup/state', '操作-状态', 1, 0, '', 9, 1, '', 1580871965, 1580871965, '');
INSERT INTO `tp_auth_rule` VALUES (134, 125, 'AuthGroup/access', '操作-权限', 1, 0, '', 10, 1, '', 1580872096, 1580872096, '');
INSERT INTO `tp_auth_rule` VALUES (135, 125, 'AuthGroup/accessPost', '操作-权限保存', 1, 0, '', 11, 1, '', 1580872132, 1580872132, '');
INSERT INTO `tp_auth_rule` VALUES (136, 160, 'Module/index', '模块管理', 1, 1, '', 41, 1, 'fa fa-th-list', 1580872182, 1580878146, '');
INSERT INTO `tp_auth_rule` VALUES (137, 136, 'Module/add', '操作-添加', 1, 0, '', 1, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (138, 136, 'Module/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (139, 136, 'Module/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (140, 136, 'Module/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (141, 136, 'Module/del', '操作-删除', 1, 0, '', 5, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (142, 136, 'Module/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (143, 136, 'Module/export', '操作-导出', 1, 0, '', 7, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (144, 136, 'Module/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580872182, 1580872182, '');
INSERT INTO `tp_auth_rule` VALUES (145, 136, 'Module/build', '操作-生成代码', 1, 0, '', 9, 1, '', 1580872699, 1580872699, '');
INSERT INTO `tp_auth_rule` VALUES (146, 136, 'Module/makeRule', '操作-生成菜单规则', 1, 0, '', 10, 1, '', 1580872730, 1580872730, '');
INSERT INTO `tp_auth_rule` VALUES (147, 160, 'Field/index', '字段管理', 1, 1, '', 42, 1, 'fa fa-bullhorn', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (148, 147, 'Field/add', '操作-添加', 1, 0, '', 1, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (149, 147, 'Field/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (150, 147, 'Field/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (151, 147, 'Field/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (152, 147, 'Field/del', '操作-删除', 1, 0, '', 5, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (153, 147, 'Field/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (154, 147, 'Field/changeType', '操作-加载配置', 1, 0, '', 7, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (155, 147, 'Field/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (156, 147, 'Field/state', '操作-状态', 1, 0, '', 9, 1, '', 1580872859, 1580872859, '');
INSERT INTO `tp_auth_rule` VALUES (157, 0, 'System', '系统管理', 1, 1, '', 1, 1, 'fa fa-cogs', 1580874149, 1580874149, '');
INSERT INTO `tp_auth_rule` VALUES (158, 0, 'Auth', '权限管理', 1, 1, '', 2, 1, 'fas fa-user-cog', 1580874265, 1580874265, '');
INSERT INTO `tp_auth_rule` VALUES (159, 0, 'Database', '数据库管理', 1, 1, '', 3, 1, 'fa fa-database', 1580876394, 1580876394, '');
INSERT INTO `tp_auth_rule` VALUES (160, 0, 'Module', '模块管理', 1, 1, '', 4, 1, 'fa fa-bolt', 1580876437, 1580876437, '');
INSERT INTO `tp_auth_rule` VALUES (161, 0, 'Link', '网站功能', 1, 1, '', 6, 1, 'fas fa-layer-group', 1580878492, 1580908102, '');
INSERT INTO `tp_auth_rule` VALUES (162, 0, 'Users', '会员管理', 1, 1, '', 7, 1, 'fa fa-user', 1580878687, 1580908154, '');
INSERT INTO `tp_auth_rule` VALUES (163, 159, 'Database/database', '数据库备份', 1, 1, '', 31, 1, 'fa fa-server', 1580881507, 1580881507, '');
INSERT INTO `tp_auth_rule` VALUES (164, 163, 'Database/backup', '操作-备份', 1, 0, '', 1, 1, '', 1580881536, 1580881536, '');
INSERT INTO `tp_auth_rule` VALUES (165, 163, 'Database/repair', '操作-修复', 1, 0, '', 2, 1, '', 1580881567, 1580881567, '');
INSERT INTO `tp_auth_rule` VALUES (166, 163, 'Database/optimize', '操作-优化', 1, 0, '', 3, 1, '', 1580881596, 1580881596, '');
INSERT INTO `tp_auth_rule` VALUES (167, 159, 'Database/restore', '数据库还原', 1, 1, '', 32, 1, 'fa fa-recycle', 1580881718, 1580881729, '');
INSERT INTO `tp_auth_rule` VALUES (168, 167, 'Database/import', '操作-还原', 1, 0, '', 1, 1, '', 1580881791, 1580881791, '');
INSERT INTO `tp_auth_rule` VALUES (169, 167, 'Database/downFile', '操作-下载', 1, 0, '', 2, 1, '', 1580881823, 1580881823, '');
INSERT INTO `tp_auth_rule` VALUES (170, 167, 'Database/del', '操作-删除', 1, 0, '', 3, 1, '', 1580881861, 1580881861, '');
INSERT INTO `tp_auth_rule` VALUES (171, 157, 'Config/email', '邮件配置', 1, 1, '', 14, 1, 'fas fa-envelope nav-icon', 1580882102, 1580882122, '');
INSERT INTO `tp_auth_rule` VALUES (172, 171, 'Config/emailPost', '操作-修改保存', 1, 0, '', 1, 1, '', 1580882214, 1580882214, '');
INSERT INTO `tp_auth_rule` VALUES (173, 171, 'Config/emailSend', '操作-测试邮箱', 1, 0, '', 2, 1, '', 1580882294, 1580882294, '');
INSERT INTO `tp_auth_rule` VALUES (174, 157, 'Config/sms', '短信配置', 1, 1, '', 15, 1, 'fas fa-comment-dots', 1580882360, 1580882360, '');
INSERT INTO `tp_auth_rule` VALUES (175, 174, 'Config/smsPost', '操作-修改保存', 1, 0, '', 1, 1, '', 1580882449, 1580882449, '');
INSERT INTO `tp_auth_rule` VALUES (176, 174, 'Config/smsSend', '操作-测试短信', 1, 0, '', 2, 1, '', 1580882486, 1580882486, '');
INSERT INTO `tp_auth_rule` VALUES (177, 187, 'Cate/index', '栏目管理', 1, 1, '', 51, 1, 'fas fa-th-list', 1580907966, 1580908113, '');
INSERT INTO `tp_auth_rule` VALUES (178, 177, 'Cate/add', '操作-添加', 1, 0, '', 1, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (179, 177, 'Cate/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (180, 177, 'Cate/edit', '操作-修改', 1, 0, '', 3, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (181, 177, 'Cate/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (182, 177, 'Cate/del', '操作-删除', 1, 0, '', 5, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (183, 177, 'Cate/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (184, 177, 'Cate/export', '操作-导出', 1, 0, '', 7, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (185, 177, 'Cate/sort', '操作-排序', 1, 0, '', 8, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (186, 177, 'Cate/state', '操作-状态', 1, 0, '', 9, 1, '', 1580907966, 1580907966, '');
INSERT INTO `tp_auth_rule` VALUES (187, 0, 'Cate', '栏目管理', 1, 1, '', 5, 1, 'fa fa-th', 1580908039, 1580908039, '');
INSERT INTO `tp_auth_rule` VALUES (188, 0, 'Page', '内容管理', 1, 1, '', 8, 1, 'fa fa-briefcase', 1581080617, 1581080617, '');
INSERT INTO `tp_auth_rule` VALUES (189, 188, 'Page/index', '单页模块', 1, 1, '', 81, 1, '', 1581080630, 1581080705, '');
INSERT INTO `tp_auth_rule` VALUES (190, 189, 'Page/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (191, 189, 'Page/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (192, 189, 'Page/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (193, 189, 'Page/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (194, 189, 'Page/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (195, 189, 'Page/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (196, 189, 'Page/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (197, 189, 'Page/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (198, 189, 'Page/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080630, 1581080630, '');
INSERT INTO `tp_auth_rule` VALUES (199, 188, 'Article/index', '文章模块', 1, 1, '', 82, 1, '', 1581080635, 1581080712, '');
INSERT INTO `tp_auth_rule` VALUES (200, 199, 'Article/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (201, 199, 'Article/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (202, 199, 'Article/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (203, 199, 'Article/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (204, 199, 'Article/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (205, 199, 'Article/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (206, 199, 'Article/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (207, 199, 'Article/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (208, 199, 'Article/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080635, 1581080635, '');
INSERT INTO `tp_auth_rule` VALUES (209, 188, 'Picture/index', '图片模块', 1, 1, '', 83, 1, '', 1581080640, 1581080717, '');
INSERT INTO `tp_auth_rule` VALUES (210, 209, 'Picture/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (211, 209, 'Picture/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (212, 209, 'Picture/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (213, 209, 'Picture/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (214, 209, 'Picture/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (215, 209, 'Picture/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (216, 209, 'Picture/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (217, 209, 'Picture/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (218, 209, 'Picture/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080640, 1581080640, '');
INSERT INTO `tp_auth_rule` VALUES (219, 188, 'Product/index', '产品模块', 1, 1, '', 84, 1, '', 1581080644, 1581080721, '');
INSERT INTO `tp_auth_rule` VALUES (220, 219, 'Product/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (221, 219, 'Product/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (222, 219, 'Product/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (223, 219, 'Product/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (224, 219, 'Product/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (225, 219, 'Product/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (226, 219, 'Product/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (227, 219, 'Product/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (228, 219, 'Product/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080644, 1581080644, '');
INSERT INTO `tp_auth_rule` VALUES (229, 188, 'Download/index', '下载模块', 1, 1, '', 85, 1, '', 1581080647, 1581080726, '');
INSERT INTO `tp_auth_rule` VALUES (230, 229, 'Download/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (231, 229, 'Download/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (232, 229, 'Download/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (233, 229, 'Download/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (234, 229, 'Download/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (235, 229, 'Download/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (236, 229, 'Download/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (237, 229, 'Download/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (238, 229, 'Download/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080647, 1581080647, '');
INSERT INTO `tp_auth_rule` VALUES (239, 188, 'Team/index', '团队模块', 1, 1, '', 86, 1, '', 1581080650, 1581080731, '');
INSERT INTO `tp_auth_rule` VALUES (240, 239, 'Team/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (241, 239, 'Team/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (242, 239, 'Team/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (243, 239, 'Team/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (244, 239, 'Team/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (245, 239, 'Team/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (246, 239, 'Team/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (247, 239, 'Team/sort', '操作-排序', 1, 0, '', 8, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (248, 239, 'Team/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080650, 1581080650, '');
INSERT INTO `tp_auth_rule` VALUES (249, 188, 'Message/index', '留言模块', 1, 1, '', 87, 1, '', 1581080655, 1581080741, '');
INSERT INTO `tp_auth_rule` VALUES (250, 249, 'Message/add', '操作-添加', 1, 0, '', 1, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (251, 249, 'Message/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (252, 249, 'Message/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (253, 249, 'Message/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (254, 249, 'Message/del', '操作-删除', 1, 0, '', 5, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (255, 249, 'Message/selectDel', '操作-批量删除', 1, 0, '', 6, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (256, 249, 'Message/export', '操作-导出', 1, 0, '', 7, 1, '', 1581080655, 1581080655, '');
INSERT INTO `tp_auth_rule` VALUES (257, 249, 'Message/state', '操作-状态', 1, 0, '', 9, 1, '', 1581080655, 1581214069, '');
INSERT INTO `tp_auth_rule` VALUES (258, 0, 'Demo', '实例演示', 1, 1, '', 9, 1, 'fa fa-desktop', 1581210913, 1581210922, '');
INSERT INTO `tp_auth_rule` VALUES (260, 258, 'Demo/button', '按钮', 1, 1, '', 91, 1, '', 1581212447, 1581212473, '');
INSERT INTO `tp_auth_rule` VALUES (261, 258, 'Demo/icons', '图标', 1, 1, '', 92, 1, '', 1581217423, 1581217753, '');
INSERT INTO `tp_auth_rule` VALUES (262, 258, 'Demo/general', '常规', 1, 1, '', 93, 1, '', 1581217729, 1581217756, '');
INSERT INTO `tp_auth_rule` VALUES (263, 258, 'Demo/modals', '模态框', 1, 1, '', 94, 1, '', 1581218146, 1581218146, '');
INSERT INTO `tp_auth_rule` VALUES (264, 258, 'Demo/timeline', '时间轴', 1, 1, '', 95, 1, '', 1581218342, 1581218342, '');
INSERT INTO `tp_auth_rule` VALUES (265, 258, 'Demo/layer', '弹层', 1, 1, '', 96, 1, '', 1581223849, 1581223863, '');
INSERT INTO `tp_auth_rule` VALUES (266, 258, 'Demo/layerForm', 'layer表单', 1, 1, '', 97, 1, '', 1581297357, 1581297367, '');
INSERT INTO `tp_auth_rule` VALUES (267, 258, 'Demo/addPost', '提交演示', 1, 0, '', 98, 0, '', 1581299002, 1581299009, '');
INSERT INTO `tp_auth_rule` VALUES (268, 157, 'Template/index', '模板管理', 1, 1, '', 16, 1, 'fa fa-code', 1581385089, 1581385089, '');
INSERT INTO `tp_auth_rule` VALUES (269, 268, 'Template/add', '操作-添加', 1, 0, '', 1, 1, '', 1581385125, 1581385125, '');
INSERT INTO `tp_auth_rule` VALUES (270, 268, 'Template/addPost', '操作-添加保存', 1, 0, '', 2, 1, '', 1581385157, 1581385157, '');
INSERT INTO `tp_auth_rule` VALUES (271, 268, 'Template/edit', '操作-修改', 1, 0, '', 3, 1, '', 1581385175, 1581385175, '');
INSERT INTO `tp_auth_rule` VALUES (272, 268, 'Template/editPost', '操作-修改保存', 1, 0, '', 4, 1, '', 1581385230, 1581385230, '');
INSERT INTO `tp_auth_rule` VALUES (273, 268, 'Template/del', '操作-删除', 1, 0, '', 5, 1, '', 1581385315, 1581385315, '');
INSERT INTO `tp_auth_rule` VALUES (274, 268, 'Template/img', '媒体文件-列表', 1, 0, '', 6, 1, '', 1581385347, 1581385347, '');
INSERT INTO `tp_auth_rule` VALUES (275, 268, 'Template/imgDel', '媒体文件-删除', 1, 0, '', 7, 1, '', 1581385377, 1581385377, '');
INSERT INTO `tp_auth_rule` VALUES (276, 268, 'Template/selectDel', '操作-批量删除', 1, 0, '', 8, 1, '', 1583732028, 1583732057, '');
INSERT INTO `tp_auth_rule` VALUES (277, 157, 'Plugin/index', '插件管理', 1, 1, '', 17, 1, 'fa fa-plug', 1583976240, 1583976276, '');
INSERT INTO `tp_auth_rule` VALUES (278, 277, 'Plugin/config', '操作-配置', 1, 0, '', 1, 1, '', 1583976343, 1583976343, '');
INSERT INTO `tp_auth_rule` VALUES (279, 277, 'Plugin/configSave', '操作-配置保存', 1, 0, '', 2, 1, '', 1583976405, 1583976405, '');
INSERT INTO `tp_auth_rule` VALUES (280, 277, 'Plugin/state', '操作-安装/卸载', 1, 0, '', 3, 1, '', 1583976450, 1583976450, '');
INSERT INTO `tp_auth_rule` VALUES (281, 177, 'Cate/batchAdd', '操作-批量添加', 1, 0, '', 10, 1, '', 1613634680, 1613634680, '');
INSERT INTO `tp_auth_rule` VALUES (282, 177, 'Cate/batchAddPost', '操作-批量添加保存', 1, 0, '', 11, 1, '', 1613634757, 1613634784, '');
-- ----------------------------
-- Table structure for tp_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `tp_admin_log`;
CREATE TABLE `tp_admin_log` (
`id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
`create_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
`update_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
`admin_id` int(8) NOT NULL DEFAULT 0 COMMENT '管理员',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作页面 ',
`title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '日志标题',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '日志内容',
`ip` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作IP',
`user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'User-Agent',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '管理员日志' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Records of tp_admin_log
-- ----------------------------
文章来源:https://blog.csdn.net/zgscwxd/article/details/135468658
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。 如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：veading@qq.com进行投诉反馈，一经查实，立即删除！
本文来自互联网用户投稿，该文观点仅代表作者本人，不代表本站立场。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。 如若内容造成侵权/违法违规/事实不符，请联系我的编程经验分享网邮箱：veading@qq.com进行投诉反馈，一经查实，立即删除！