springSecurity 数据库
尚硅谷：
表：
/* Navicat MySQL Data Transfer Source Server : 本地 Source Server Version : 50729 Source Host : localhost:3306 Source Database : acldb Target Server Type : MYSQL Target Server Version : 50729 File Encoding : 65001 Date: 2022-06-14 09:37:08 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for acl_permission -- ---------------------------- DROP TABLE IF EXISTS `acl_permission`; CREATE TABLE `acl_permission` ( `id` char(19) NOT NULL DEFAULT '' COMMENT '编号', `pid` char(19) NOT NULL DEFAULT '' COMMENT '所属上级', `name` varchar(20) NOT NULL DEFAULT '' COMMENT '名称', `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '类型(1:菜单,2:按钮)', `permission_value` varchar(50) DEFAULT NULL COMMENT '权限值', `path` varchar(100) DEFAULT NULL COMMENT '访问路径', `component` varchar(100) DEFAULT NULL COMMENT '组件路径', `icon` varchar(50) DEFAULT NULL COMMENT '图标', `status` tinyint(4) DEFAULT NULL COMMENT '状态(0:禁止,1:正常)', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除', `gmt_create` datetime DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_pid` (`pid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限'; -- ---------------------------- -- Records of acl_permission -- ---------------------------- INSERT INTO `acl_permission` VALUES ('1', '0', '全部数据', '0', null, null, null, null, null, '0', '2019-11-15 17:13:06', '2019-11-15 17:13:06'); INSERT INTO `acl_permission` VALUES ('1195268474480156673', '1', '权限管理', '1', null, '/acl', 'Layout', null, null, '0', '2019-11-15 17:13:06', '2019-11-18 13:54:25'); INSERT INTO `acl_permission` VALUES ('1195268616021139457', '1195268474480156673', '用户管理', '1', null, 'user/list', '/acl/user/list', null, null, '0', '2019-11-15 17:13:40', '2019-11-18 13:53:12'); INSERT INTO `acl_permission` VALUES ('1195268788138598401', '1195268474480156673', '角色管理', '1', null, 'role/list', '/acl/role/list', null, null, '0', '2019-11-15 17:14:21', '2019-11-15 17:14:21'); INSERT INTO `acl_permission` VALUES ('1195268893830864898', '1195268474480156673', '菜单管理', '1', null, 'menu/list', '/acl/menu/list', null, null, '0', '2019-11-15 17:14:46', '2019-11-15 17:14:46'); INSERT INTO `acl_permission` VALUES ('1195269143060602882', '1195268616021139457', '查看', '2', 'user.list', '', '', null, null, '0', '2019-11-15 17:15:45', '2019-11-17 21:57:16'); INSERT INTO `acl_permission` VALUES ('1195269295926206466', '1195268616021139457', '添加', '2', 'user.add', 'user/add', '/acl/user/form', null, null, '0', '2019-11-15 17:16:22', '2019-11-15 17:16:22'); INSERT INTO `acl_permission` VALUES ('1195269473479483394', '1195268616021139457', '修改', '2', 'user.update', 'user/update/:id', '/acl/user/form', null, null, '0', '2019-11-15 17:17:04', '2019-11-15 17:17:04'); INSERT INTO `acl_permission` VALUES ('1195269547269873666', '1195268616021139457', '删除', '2', 'user.remove', '', '', null, null, '0', '2019-11-15 17:17:22', '2019-11-15 17:17:22'); INSERT INTO `acl_permission` VALUES ('1195269821262782465', '1195268788138598401', '修改', '2', 'role.update', 'role/update/:id', '/acl/role/form', null, null, '0', '2019-11-15 17:18:27', '2019-11-15 17:19:53'); INSERT INTO `acl_permission` VALUES ('1195269903542444034', '1195268788138598401', '查看', '2', 'role.list', '', '', null, null, '0', '2019-11-15 17:18:47', '2019-11-15 17:18:47'); INSERT INTO `acl_permission` VALUES ('1195270037005197313', '1195268788138598401', '添加', '2', 'role.add', 'role/add', '/acl/role/form', null, null, '0', '2019-11-15 17:19:19', '2019-11-18 11:05:42'); INSERT INTO `acl_permission` VALUES ('1195270442602782721', '1195268788138598401', '删除', '2', 'role.remove', '', '', null, null, '0', '2019-11-15 17:20:55', '2019-11-15 17:20:55'); INSERT INTO `acl_permission` VALUES ('1195270621548568578', '1195268788138598401', '角色权限', '2', 'role.acl', 'role/distribution/:id', '/acl/role/roleForm', null, null, '0', '2019-11-15 17:21:38', '2019-11-15 17:21:38'); INSERT INTO `acl_permission` VALUES ('1195270744097742849', '1195268893830864898', '查看', '2', 'permission.list', '', '', null, null, '0', '2019-11-15 17:22:07', '2019-11-15 17:22:07'); INSERT INTO `acl_permission` VALUES ('1195270810560684034', '1195268893830864898', '添加', '2', 'permission.add', '', '', null, null, '0', '2019-11-15 17:22:23', '2019-11-15 17:22:23'); INSERT INTO `acl_permission` VALUES ('1195270862100291586', '1195268893830864898', '修改', '2', 'permission.update', '', '', null, null, '0', '2019-11-15 17:22:35', '2019-11-15 17:22:35'); INSERT INTO `acl_permission` VALUES ('1195270887933009922', '1195268893830864898', '删除', '2', 'permission.remove', '', '', null, null, '0', '2019-11-15 17:22:41', '2019-11-15 17:22:41'); INSERT INTO `acl_permission` VALUES ('1195349439240048642', '1', '讲师管理', '1', null, '/edu/teacher', 'Layout', null, null, '0', '2019-11-15 22:34:49', '2019-11-15 22:34:49'); INSERT INTO `acl_permission` VALUES ('1195349699995734017', '1195349439240048642', '讲师列表', '1', null, 'list', '/edu/teacher/list', null, null, '0', '2019-11-15 22:35:52', '2019-11-15 22:35:52'); INSERT INTO `acl_permission` VALUES ('1195349810561781761', '1195349439240048642', '添加讲师', '1', null, 'create', '/edu/teacher/form', null, null, '0', '2019-11-15 22:36:18', '2019-11-15 22:36:18'); INSERT INTO `acl_permission` VALUES ('1195349876252971010', '1195349810561781761', '添加', '2', 'teacher.add', '', '', null, null, '0', '2019-11-15 22:36:34', '2019-11-15 22:36:34'); INSERT INTO `acl_permission` VALUES ('1195349979797753857', '1195349699995734017', '查看', '2', 'teacher.list', '', '', null, null, '0', '2019-11-15 22:36:58', '2019-11-15 22:36:58'); INSERT INTO `acl_permission` VALUES ('1195350117270261762', '1195349699995734017', '修改', '2', 'teacher.update', 'edit/:id', '/edu/teacher/form', null, null, '0', '2019-11-15 22:37:31', '2019-11-15 22:37:31'); INSERT INTO `acl_permission` VALUES ('1195350188359520258', '1195349699995734017', '删除', '2', 'teacher.remove', '', '', null, null, '0', '2019-11-15 22:37:48', '2019-11-15 22:37:48'); INSERT INTO `acl_permission` VALUES ('1195350299365969922', '1', '课程分类', '1', null, '/edu/subject', 'Layout', null, null, '0', '2019-11-15 22:38:15', '2019-11-15 22:38:15'); INSERT INTO `acl_permission` VALUES ('1195350397751758850', '1195350299365969922', '课程分类列表', '1', null, 'list', '/edu/subject/list', null, null, '0', '2019-11-15 22:38:38', '2019-11-15 22:38:38'); INSERT INTO `acl_permission` VALUES ('1195350500512206850', '1195350299365969922', '导入课程分类', '1', null, 'import', '/edu/subject/import', null, null, '0', '2019-11-15 22:39:03', '2019-11-15 22:39:03'); INSERT INTO `acl_permission` VALUES ('1195350612172967938', '1195350397751758850', '查看', '2', 'subject.list', '', '', null, null, '0', '2019-11-15 22:39:29', '2019-11-15 22:39:29'); INSERT INTO `acl_permission` VALUES ('1195350687590748161', '1195350500512206850', '导入', '2', 'subject.import', '', '', null, null, '0', '2019-11-15 22:39:47', '2019-11-15 22:39:47'); INSERT INTO `acl_permission` VALUES ('1195350831744782337', '1', '课程管理', '1', null, '/edu/course', 'Layout', null, null, '0', '2019-11-15 22:40:21', '2019-11-15 22:40:21'); INSERT INTO `acl_permission` VALUES ('1195350919074385921', '1195350831744782337', '课程列表', '1', null, 'list', '/edu/course/list', null, null, '0', '2019-11-15 22:40:42', '2019-11-15 22:40:42'); INSERT INTO `acl_permission` VALUES ('1195351020463296513', '1195350831744782337', '发布课程', '1', null, 'info', '/edu/course/info', null, null, '0', '2019-11-15 22:41:06', '2019-11-15 22:41:06'); INSERT INTO `acl_permission` VALUES ('1195351159672246274', '1195350919074385921', '完成发布', '2', 'course.publish', 'publish/:id', '/edu/course/publish', null, null, '0', '2019-11-15 22:41:40', '2019-11-15 22:44:01'); INSERT INTO `acl_permission` VALUES ('1195351326706208770', '1195350919074385921', '编辑课程', '2', 'course.update', 'info/:id', '/edu/course/info', null, null, '0', '2019-11-15 22:42:19', '2019-11-15 22:42:19'); INSERT INTO `acl_permission` VALUES ('1195351566221938690', '1195350919074385921', '编辑课程大纲', '2', 'chapter.update', 'chapter/:id', '/edu/course/chapter', null, null, '0', '2019-11-15 22:43:17', '2019-11-15 22:43:17'); INSERT INTO `acl_permission` VALUES ('1195351862889254913', '1', '统计分析', '1', null, '/statistics/daily', 'Layout', null, null, '0', '2019-11-15 22:44:27', '2019-11-15 22:44:27'); INSERT INTO `acl_permission` VALUES ('1195351968841568257', '1195351862889254913', '生成统计', '1', null, 'create', '/statistics/daily/create', null, null, '0', '2019-11-15 22:44:53', '2019-11-15 22:44:53'); INSERT INTO `acl_permission` VALUES ('1195352054917074946', '1195351862889254913', '统计图表', '1', null, 'chart', '/statistics/daily/chart', null, null, '0', '2019-11-15 22:45:13', '2019-11-15 22:45:13'); INSERT INTO `acl_permission` VALUES ('1195352127734386690', '1195352054917074946', '查看', '2', 'daily.list', '', '', null, null, '0', '2019-11-15 22:45:30', '2019-11-15 22:45:30'); INSERT INTO `acl_permission` VALUES ('1195352215768633346', '1195351968841568257', '生成', '2', 'daily.add', '', '', null, null, '0', '2019-11-15 22:45:51', '2019-11-15 22:45:51'); INSERT INTO `acl_permission` VALUES ('1195352547621965825', '1', 'CMS管理', '1', null, '/cms', 'Layout', null, null, '0', '2019-11-15 22:47:11', '2019-11-18 10:51:46'); INSERT INTO `acl_permission` VALUES ('1195352856645701633', '1195353513549205505', '查看', '2', 'banner.list', '', null, null, null, '0', '2019-11-15 22:48:24', '2019-11-15 22:48:24'); INSERT INTO `acl_permission` VALUES ('1195352909401657346', '1195353513549205505', '添加', '2', 'banner.add', 'banner/add', '/cms/banner/form', null, null, '0', '2019-11-15 22:48:37', '2019-11-18 10:52:10'); INSERT INTO `acl_permission` VALUES ('1195353051395624961', '1195353513549205505', '修改', '2', 'banner.update', 'banner/update/:id', '/cms/banner/form', null, null, '0', '2019-11-15 22:49:11', '2019-11-18 10:52:05'); INSERT INTO `acl_permission` VALUES ('1195353513549205505', '1195352547621965825', 'Bander列表', '1', null, 'banner/list', '/cms/banner/list', null, null, '0', '2019-11-15 22:51:01', '2019-11-18 10:51:29'); INSERT INTO `acl_permission` VALUES ('1195353672110673921', '1195353513549205505', '删除', '2', 'banner.remove', '', '', null, null, '0', '2019-11-15 22:51:39', '2019-11-15 22:51:39'); INSERT INTO `acl_permission` VALUES ('1195354076890370050', '1', '订单管理', '1', null, '/order', 'Layout', null, null, '0', '2019-11-15 22:53:15', '2019-11-15 22:53:15'); INSERT INTO `acl_permission` VALUES ('1195354153482555393', '1195354076890370050', '订单列表', '1', null, 'list', '/order/list', null, null, '0', '2019-11-15 22:53:33', '2019-11-15 22:53:58'); INSERT INTO `acl_permission` VALUES ('1195354315093282817', '1195354153482555393', '查看', '2', 'order.list', '', '', null, null, '0', '2019-11-15 22:54:12', '2019-11-15 22:54:12'); INSERT INTO `acl_permission` VALUES ('1196301740985311234', '1195268616021139457', '分配角色', '2', 'user.assgin', 'user/role/:id', '/acl/user/roleForm', null, null, '0', '2019-11-18 13:38:56', '2019-11-18 13:38:56'); -- ---------------------------- -- Table structure for acl_role -- ---------------------------- DROP TABLE IF EXISTS `acl_role`; CREATE TABLE `acl_role` ( `id` char(19) NOT NULL DEFAULT '' COMMENT '角色id', `role_name` varchar(20) NOT NULL DEFAULT '' COMMENT '角色名称', `role_code` varchar(20) DEFAULT NULL COMMENT '角色编码', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除', `gmt_create` datetime NOT NULL COMMENT '创建时间', `gmt_modified` datetime NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of acl_role -- ---------------------------- INSERT INTO `acl_role` VALUES ('1', '普通管理员', null, null, '0', '2019-11-11 13:09:32', '2019-11-18 10:27:18'); INSERT INTO `acl_role` VALUES ('1193757683205607426', '课程管理员', null, null, '0', '2019-11-11 13:09:45', '2019-11-18 10:25:44'); INSERT INTO `acl_role` VALUES ('1196300996034977794', 'test', null, null, '0', '2019-11-18 13:35:58', '2019-11-18 13:35:58'); -- ---------------------------- -- Table structure for acl_role_permission -- ---------------------------- DROP TABLE IF EXISTS `acl_role_permission`; CREATE TABLE `acl_role_permission` ( `id` char(19) NOT NULL DEFAULT '', `role_id` char(19) NOT NULL DEFAULT '', `permission_id` char(19) NOT NULL DEFAULT '', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除', `gmt_create` datetime NOT NULL COMMENT '创建时间', `gmt_modified` datetime NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_permission_id` (`permission_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色权限'; -- ---------------------------- -- Records of acl_role_permission -- ---------------------------- INSERT INTO `acl_role_permission` VALUES ('1196301979754455041', '1', '1', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979792203778', '1', '1195268474480156673', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979821563906', '1', '1195268616021139457', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979842535426', '1', '1195269143060602882', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979855118338', '1', '1195269295926206466', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979880284161', '1', '1195269473479483394', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979913838593', '1', '1195269547269873666', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979926421506', '1', '1196301740985311234', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301979951587330', '1', '1195268788138598401', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980014501889', '1', '1195269821262782465', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980035473410', '1', '1195269903542444034', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980052250626', '1', '1195270037005197313', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980077416450', '1', '1195270442602782721', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980094193665', '1', '1195270621548568578', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980119359489', '1', '1195268893830864898', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980136136706', '1', '1195270744097742849', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980249382913', '1', '1195270810560684034', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980270354434', '1', '1195270862100291586', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980287131649', '1', '1195270887933009922', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980303908866', '1', '1195349439240048642', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980320686082', '1', '1195349699995734017', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980345851905', '1', '1195349979797753857', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980362629121', '1', '1195350117270261762', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980383600641', '1', '1195350188359520258', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980408766465', '1', '1195349810561781761', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980421349378', '1', '1195349876252971010', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980438126593', '1', '1195350299365969922', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980450709506', '1', '1195350397751758850', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980501041153', '1', '1195350612172967938', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980517818370', '1', '1195350500512206850', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980538789889', '1', '1195350687590748161', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980622675970', '1', '1195350831744782337', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980639453186', '1', '1195350919074385921', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980660424705', '1', '1195351159672246274', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980677201922', '1', '1195351326706208770', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980698173441', '1', '1195351566221938690', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980714950658', '1', '1195351020463296513', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980723339266', '1', '1195351862889254913', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980744310786', '1', '1195351968841568257', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980761088001', '1', '1195352215768633346', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980777865217', '1', '1195352054917074946', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980794642434', '1', '1195352127734386690', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980811419650', '1', '1195352547621965825', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980828196865', '1', '1195353513549205505', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980844974082', '1', '1195352856645701633', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980861751298', '1', '1195352909401657346', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980886917122', '1', '1195353051395624961', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980928860162', '1', '1195353672110673921', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980954025986', '1', '1195354076890370050', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980970803201', '1', '1195354153482555393', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196301980987580418', '1', '1195354315093282817', '1', '2019-11-18 13:39:53', '2019-11-18 13:39:53'); INSERT INTO `acl_role_permission` VALUES ('1196305293070077953', '1', '1', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293099438081', '1', '1195268474480156673', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293120409602', '1', '1195268616021139457', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293153964034', '1', '1195269143060602882', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293183324162', '1', '1195269295926206466', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293212684290', '1', '1195269473479483394', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293237850114', '1', '1195269547269873666', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293271404545', '1', '1196301740985311234', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293485314049', '1', '1195268788138598401', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293506285569', '1', '1195269821262782465', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293527257089', '1', '1195269903542444034', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293552422914', '1', '1195270037005197313', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293565005825', '1', '1195270442602782721', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293594365954', '1', '1195270621548568578', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293611143169', '1', '1195268893830864898', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293627920385', '1', '1195270744097742849', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293657280513', '1', '1195349439240048642', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293674057729', '1', '1195349699995734017', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293690834946', '1', '1195349979797753857', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293716000770', '1', '1195350117270261762', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293736972290', '1', '1195350188359520258', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293749555202', '1', '1195349810561781761', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293766332417', '1', '1195349876252971010', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293795692546', '1', '1195350299365969922', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293812469762', '1', '1195350397751758850', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293837635586', '1', '1195350612172967938', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293858607106', '1', '1195350500512206850', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293875384322', '1', '1195350687590748161', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293892161538', '1', '1195350831744782337', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293950881794', '1', '1195350919074385921', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305293976047617', '1', '1195351159672246274', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294127042561', '1', '1195351326706208770', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294156402690', '1', '1195351566221938690', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294177374209', '1', '1195351862889254913', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294194151425', '1', '1195351968841568257', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294223511554', '1', '1195352215768633346', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294240288770', '1', '1195352054917074946', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294248677377', '1', '1195352127734386690', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294248677378', '1', '1195352547621965825', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294319980546', '1', '1195353513549205505', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294319980547', '1', '1195352856645701633', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294319980548', '1', '1195352909401657346', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294378700802', '1', '1195353051395624961', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294378700803', '1', '1195353672110673921', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294458392577', '1', '1195354076890370050', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294483558402', '1', '1195354153482555393', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305294500335618', '1', '1195354315093282817', '1', '2019-11-18 13:53:03', '2019-11-18 13:53:03'); INSERT INTO `acl_role_permission` VALUES ('1196305566656139266', '1', '1', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566689693698', '1', '1195268474480156673', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566706470913', '1', '1195268616021139457', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566740025346', '1', '1195269143060602882', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566756802561', '1', '1195269295926206466', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566781968385', '1', '1195269473479483394', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566811328514', '1', '1195269547269873666', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566828105730', '1', '1196301740985311234', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566853271554', '1', '1195268788138598401', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566878437378', '1', '1195269821262782465', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566895214593', '1', '1195269903542444034', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566916186113', '1', '1195270037005197313', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566949740546', '1', '1195270442602782721', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566966517761', '1', '1195270621548568578', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305566991683585', '1', '1195268893830864898', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567012655106', '1', '1195270744097742849', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567029432322', '1', '1195270810560684034', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567042015233', '1', '1195270862100291586', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567100735490', '1', '1195270887933009922', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567117512705', '1', '1195349439240048642', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567142678530', '1', '1195349699995734017', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567155261442', '1', '1195349979797753857', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567172038658', '1', '1195350117270261762', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567188815873', '1', '1195350188359520258', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567218176001', '1', '1195349810561781761', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567234953217', '1', '1195349876252971010', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567251730434', '1', '1195350299365969922', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567272701954', '1', '1195350397751758850', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567289479170', '1', '1195350612172967938', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567310450690', '1', '1195350500512206850', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567327227905', '1', '1195350687590748161', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567448862722', '1', '1195350831744782337', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567478222850', '1', '1195350919074385921', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567495000065', '1', '1195351159672246274', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567520165889', '1', '1195351326706208770', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567541137409', '1', '1195351566221938690', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567570497538', '1', '1195351862889254913', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567587274754', '1', '1195351968841568257', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567604051970', '1', '1195352215768633346', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567633412098', '1', '1195352054917074946', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567683743745', '1', '1195352127734386690', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567721492481', '1', '1195352547621965825', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567742464002', '1', '1195353513549205505', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567771824129', '1', '1195352856645701633', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567792795650', '1', '1195352909401657346', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567809572866', '1', '1195353051395624961', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567843127298', '1', '1195353672110673921', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567868293122', '1', '1195354076890370050', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567885070338', '1', '1195354153482555393', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196305567910236162', '1', '1195354315093282817', '1', '2019-11-18 13:54:08', '2019-11-18 13:54:08'); INSERT INTO `acl_role_permission` VALUES ('1196312702601695234', '1', '1', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702652026881', '1', '1195268474480156673', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702668804098', '1', '1195268616021139457', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702698164226', '1', '1195269143060602882', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702723330049', '1', '1195269295926206466', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702744301569', '1', '1195269473479483394', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702765273089', '1', '1195269547269873666', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702790438913', '1', '1196301740985311234', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702945628161', '1', '1195268788138598401', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312702970793985', '1', '1195269821262782465', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703000154114', '1', '1195269903542444034', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703025319938', '1', '1195270037005197313', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703046291458', '1', '1195270442602782721', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703063068673', '1', '1195270621548568578', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703084040193', '1', '1195268893830864898', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703113400321', '1', '1195270744097742849', '0', '2019-11-18 14:22:29', '2019-11-18 14:22:29'); INSERT INTO `acl_role_permission` VALUES ('1196312703134371842', '1', '1195270810560684034', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703159537665', '1', '1195270862100291586', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703184703490', '1', '1195270887933009922', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703209869313', '1', '1195349439240048642', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703230840834', '1', '1195349699995734017', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703251812354', '1', '1195349979797753857', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703272783873', '1', '1195350117270261762', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703293755394', '1', '1195350188359520258', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703327309826', '1', '1195349810561781761', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703348281345', '1', '1195349876252971010', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703365058561', '1', '1195350299365969922', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703386030082', '1', '1195350397751758850', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703440556034', '1', '1195350612172967938', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703486693378', '1', '1195350500512206850', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703511859202', '1', '1195350687590748161', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703654465537', '1', '1195350831744782337', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703683825665', '1', '1195350919074385921', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703700602882', '1', '1195351159672246274', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703717380098', '1', '1195351326706208770', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703738351618', '1', '1195351566221938690', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703759323137', '1', '1195351020463296513', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703776100353', '1', '1195351862889254913', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703792877570', '1', '1195351968841568257', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703830626305', '1', '1195352215768633346', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703843209217', '1', '1195352054917074946', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703868375041', '1', '1195352127734386690', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703889346561', '1', '1195352547621965825', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703901929473', '1', '1195353513549205505', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703918706689', '1', '1195352856645701633', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703952261121', '1', '1195352909401657346', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703973232642', '1', '1195353051395624961', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312703990009857', '1', '1195353672110673921', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312704048730114', '1', '1195354076890370050', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312704069701633', '1', '1195354153482555393', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); INSERT INTO `acl_role_permission` VALUES ('1196312704094867457', '1', '1195354315093282817', '0', '2019-11-18 14:22:30', '2019-11-18 14:22:30'); -- ---------------------------- -- Table structure for acl_user -- ---------------------------- DROP TABLE IF EXISTS `acl_user`; CREATE TABLE `acl_user` ( `id` char(19) NOT NULL COMMENT '会员id', `username` varchar(20) NOT NULL DEFAULT '' COMMENT '微信openid', `password` varchar(32) NOT NULL DEFAULT '' COMMENT '密码', `nick_name` varchar(50) DEFAULT NULL COMMENT '昵称', `salt` varchar(255) DEFAULT NULL COMMENT '用户头像', `token` varchar(100) DEFAULT NULL COMMENT '用户签名', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除', `gmt_create` datetime NOT NULL COMMENT '创建时间', `gmt_modified` datetime NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表'; -- ---------------------------- -- Records of acl_user -- ---------------------------- INSERT INTO `acl_user` VALUES ('1', 'admin', '96e79218965eb72c92a549dd5a330112', 'admin', '', null, '0', '2019-11-01 10:39:47', '2019-11-01 10:39:47'); INSERT INTO `acl_user` VALUES ('2', 'test', '96e79218965eb72c92a549dd5a330112', 'test', null, null, '0', '2019-11-01 16:36:07', '2019-11-01 16:40:08'); -- ---------------------------- -- Table structure for acl_user_role -- ---------------------------- DROP TABLE IF EXISTS `acl_user_role`; CREATE TABLE `acl_user_role` ( `id` char(19) NOT NULL DEFAULT '' COMMENT '主键id', `role_id` char(19) NOT NULL DEFAULT '0' COMMENT '角色id', `user_id` char(19) NOT NULL DEFAULT '0' COMMENT '用户id', `is_deleted` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '逻辑删除 1（true）已删除， 0（false）未删除', `gmt_create` datetime NOT NULL COMMENT '创建时间', `gmt_modified` datetime NOT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of acl_user_role -- ---------------------------- INSERT INTO `acl_user_role` VALUES ('1', '1', '2', '0', '2019-11-11 13:09:53', '2019-11-11 13:09:53');
本文来自博客园，作者：咸瑜，转载请注明原文链接：https://www.cnblogs.com/bi-hu/p/16372009.html
