【小白专用】(C#)用户、角色、权限控制体系

 我们在开发很多项目的时候,都会用到用户权限管理,我也在很多项目里做过权限控制,所以,我也总结出一套条理清晰的角色权限控制体系。本文采用RBAC(Role Based Access Control)的基本思想,RBAC(角色访问控制)的基本思想可简单地用用户--角色--权限来表示,即把整个访问控制过程分成两步:访问权限与角色相关联,角色再与用户关联,从而实现了用户与访问权限的逻辑分离 
        由于RBAC实现了用户与访问权限的逻辑分离,因此它极大的方便了权限管理。例如,如果一个用户的职位发生变化,只要将用户当前的角色去掉,加入代表新职务或新任务的角色即可,角色/权限之间的变化比角色/用户关系之间的变化相对要慢得多,并且委派用户到角色不需要很多技术,可以由行政管理人员来执行,而配置权限到角色的工作比较复杂,需要一定的技术,可以由专门的技术人员来承担,但是不给他们委派用户的权限,这与现实中情况正好一致。利用.NET实现权限控制的基本思想是:根据角色访问控制(RBAC)的基本原理,给用户分配一个角色,每个角色对应不同模块的不同权限,同一个用户可属于不同的角色,对模块的操作权限取用户所属几个角色的最高权限

https://www.cnblogs.com/huangwen/articles/638050.html

(C#)用户、角色、权限




/*
 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
-- ----------------------------

















本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如若转载,请注明出处:http://www.mfbz.cn/a/304185.html

如若内容造成侵权/违法违规/事实不符,请联系我们进行投诉反馈qq邮箱809451989@qq.com,一经查实,立即删除!

相关文章

自动驾驶HWP的功能定义

一、功能定义 高速路自动驾驶功能HWP是指在一般畅通高速公路或城市快速路上驾驶员可以放开双手双脚,同时注意力可在较长时间内从驾驶环境中转移,做一些诸如看手机、接电话、看风景等活动,该系统最低工作速度为60kph。 如上两种不同环境和速度…

谷歌提出「边界注意力」模型,实现超越像素级检测精度!微弱边界也逃不过

有些情况下,当面临分辨率较低的图像时,可能会在进行诸如目标检测和图像分割等任务时遇到一些挑战和阻碍。这是因为低分辨率图像可能丢失了细节信息,使得计算机视觉系统难以准确捕捉和理解图像中的关键特征。在这种背景下,传统的方…

CTF-PWN-沙箱逃脱-【seccomp和prtcl-1】

文章目录 啥是seccomp#ifndef #define #endif使用使用格式 seccomp无参数条件禁用系统调用有参数条件禁用系统调用 prctl实例 seccomp_export_bpf 啥是seccomp 就是可以禁用掉某些系统调用,然后只能允许某些系统调用 #ifndef #define #endif使用 #ifndef #defin…

Java可视化大屏智慧工地云平台源码(SaaS模式)

智慧工地是一种崭新的工程现场一体化管理模式,是互联网与传统建筑行业的深度融合。它充分利用移动互联、物联网、云计算、大数据等新一代信息技术,围绕人、机、料、法、环等各方面关键因素,彻底改变传统建筑施工现场参建各方现场管理的交互方…

鸿蒙开发已解决The module to import is incompatible with the current project

文章目录 项目场景:问题描述原因分析:解决方案:心得体会:知识点OpenHarmony:HarmonyOS:项目场景: 报错: The module to import is incompatible with the current project 问题描述 希望通过 import module 将该模块引入到我的项目。 导入后出现错误,因为项目和模

从事涉密测绘业务的人员应当具有中华人民共和国国籍,签订保密责任书,接受保密教育。

从事涉密测绘业务的人员应当具有中华人民共和国国籍,签订保密责任书,接受保密教育。 1、从事涉密测绘业务并签署保密责任书的人员清单(包括:姓名、身份证号码、工作岗位、责任书签署日期) 2、近三年内(或…

【Java 设计模式】设计原则

文章目录 ✨单一职责原则(SRP)✨开放/封闭原则(OCP)✨里氏替换原则(LSP)✨依赖倒置原则(DIP)✨接口隔离原则(ISP)✨合成/聚合复用原则(CARP&#…

项目管理:放权并非推卸责任,项目经理如何做好授权管理

项目经理作为项目的管理者,肩负着对项目整体结果的重大责任。然而,项目的成功并非项目经理一人之力所能完成,因此,恰当地授权给团队成员显得尤为重要。 但是,项目经理的能力和精力有限,只有通过授权&…

【推文】企业级AI问答知识库训练营,火热开营中!

简介:阿里云人工智能平台PAI【企业AI成长营】系列课程上线!第一弹:企业AI问答知识库训练营,手把手带你从入门到实操快速完成知识库搭建,助力企业AI应用落地。 📚 企业AI问答知识库训练营:点击报…

性能分析与调优: Linux 内存观测工具

目录 一、实验 1.环境 2.vmstat 3.PSI 4.swapon 5.sar 6.slabtop 7.numstat 8.ps 9.top 10.pmap 11.perf 12.bpftrace 二、问题 1.接口读写报错 2.slabtop如何安装 3.numactl如何安装 4.numad启动服务与关闭NUMA 5. perf如何安装 6. kernel-lt-doc与kern…

Java Stream介绍和实战

目录 1. 引言 2. Stream 的基本特性 3. 创建 Stream 4. Stream 的中间操作 5. Stream 的终端操作 6. Stream 的性能优化 7. 实例演示 8. 注意事项 9. 结语 1. 引言 Java 中的 Stream 是 Java 8 引入的一种用于对集合进行操作的工具,为开发者提供了一种更便…

苹果在美国被禁售有望反转!

都说开门大吉,可2024年似乎对苹果公司并不友好,一会儿是Apple Watch系列在美国被禁售,一会儿又是分析师唱衰iPhone 16,总之各种风声杂糅,给人一种苹果正遭遇重大危机的感觉。 此前美国国际贸易委员会(ITC)下达了对苹果旗下部分智能手表的进口禁令,Apple Watch Series9和…

优思学院|为什么医疗行业供应商需要六西格玛管理?

什么是六西格玛管理? 六西格玛管理是一种旨在提高产品和服务质量的方法论。它通过减少过程中的错误和变异性,来提高效率和性能。自20世纪80年代由摩托罗拉公司首创以来,六西格玛已经在各行各业得到广泛应用。 医疗行业的特点 医疗行业是一…

C#.Net学习笔记——设计模式六大原则

***************基础介绍*************** 1、单一职责原则 2、里氏替换原则 3、依赖倒置原则 4、接口隔离原则 5、迪米特法原则 6、开闭原则 一、单一职责原则 举例:类T负责两个不同的职责:职责P1,职责P2。当由于职责P1需求发生改变而需要修…

【leetcode】力扣热门之回文链表【简单难度】

题目描述 给你一个单链表的头节点 head ,请你判断该链表是否为回文链表。如果是,返回 true ;否则,返回 false 。 用例 输入:head [1,2,2,1] 输出:true 输入:head [1,2] 输出:f…

TikTok电商年度洞察:出海到底“卖什么”?各国多类目爆款洞察,迅速掌握市场领先优势

很多卖家在尝试出海时,常面临两大核心痛点:一是“卖什么”,即选择何种商品进行销售;二是“怎么卖”,即如何通过有效的营销策略将商品销售出去。TikTok主打的内容电商模式,通过短视频和直播等形式&#xff0…

LeetCode-1822/1502/896/13

1.数组元素积的符号(1822) 题目描述: 已知函数 signFunc(x) 将会根据 x 的正负返回特定值: 如果 x 是正数,返回 1 。 如果 x 是负数,返回 -1 。 如果 x 是等于 0 ,返回 0 。 给你一个整数数组…

2.SPSS数据文件的建立和管理

文章目录 数据文件的特点建立SPSS数据文件步骤 数据文件的结构变量的规则 数据的录入和保存录入数据保存文件 数据的编辑数据定位 数据文件的特点 SPSS数据库文件包括文件结构和数据两部分 SPSS数据文件中的一列数据称为一个变量。每个变量都应有一个名称,即&…

如何搭建WampServer并结合cpolar内网穿透实现公网访问本地服务

文章目录 推荐前言1.WampServer下载安装2.WampServer启动3.安装cpolar内网穿透3.1 注册账号3.2 下载cpolar客户端3.3 登录cpolar web ui管理界面3.4 创建公网地址 4.固定公网地址访问 推荐 前些天发现了一个巨牛的人工智能学习网站,通俗易懂,风趣幽默&am…

视图与索引连表查询内/外联和子查询

1.视图 先介绍一下视图: 从SQL的角度来看,视图和表是相同的,两者的区别在于表中存储的是实际的数据,而视图中保存的是SELECT语句(视图本身并不存储数据)。 使用视图可以轻松完成跨多表查询数据等复杂操作…