/* Navicat MySQL Data Transfer Source Server : mysql192.168.180.134 Source Server Version : 50548 Source Host : 192.168.180.134:3306 Source Database : dp-boot-lte Target Server Type : MYSQL Target Server Version : 50548 File Encoding : 65001 Date: 2017-09-13 22:32:06 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单id', `parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0', `name` varchar(50) DEFAULT NULL COMMENT '菜单名称', `url` varchar(200) DEFAULT NULL COMMENT '菜单URL', `perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)', `type` int(11) DEFAULT NULL COMMENT '类型 0：目录 1：菜单 2：按钮', `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标', `order_num` int(11) DEFAULT NULL COMMENT '排序', `gmt_create` datetime DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`menu_id`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COMMENT='菜单管理'; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', null, '', '0', 'fa fa-coffee', '0', '2017-08-09 22:49:47', '2017-09-11 17:25:22'); INSERT INTO `sys_menu` VALUES ('2', '1', '系统菜单', 'base/menu/list.html', null, '1', 'fa fa-th-list', '1', '2017-08-09 22:55:15', '2017-08-17 10:00:12'); INSERT INTO `sys_menu` VALUES ('3', '0', '组织机构', null, null, '0', 'fa fa-desktop', '1', '2017-08-09 23:06:55', '2017-08-17 09:54:28'); INSERT INTO `sys_menu` VALUES ('4', '1', '通用字典', 'base/macro/list.html', null, '1', 'fa fa-book', '2', '2017-08-09 23:06:58', '2017-08-17 10:00:24'); INSERT INTO `sys_menu` VALUES ('6', '3', '用户管理', 'base/user/list.html', '', '1', 'fa fa-user', '2', '2017-08-10 14:12:11', '2017-09-05 12:57:42'); INSERT INTO `sys_menu` VALUES ('7', '3', '角色管理', 'base/role/list.html', '', '1', 'fa fa-paw', '1', '2017-08-10 14:13:19', '2017-09-05 12:57:30'); INSERT INTO `sys_menu` VALUES ('11', '6', '刷新', '/sys/user/list', 'sys:user:list', '2', null, '0', '2017-08-14 10:51:05', '2017-09-05 12:47:23'); INSERT INTO `sys_menu` VALUES ('12', '6', '新增', '/sys/user/save', 'sys:user:save', '2', null, '0', '2017-08-14 10:51:35', '2017-09-05 12:47:34'); INSERT INTO `sys_menu` VALUES ('13', '6', '编辑', '/sys/user/update', 'sys:user:edit', '2', null, '0', '2017-08-14 10:52:06', '2017-09-05 12:47:46'); INSERT INTO `sys_menu` VALUES ('14', '6', '删除', '/sys/user/remove', 'sys:user:remove', '2', null, '0', '2017-08-14 10:52:24', '2017-09-05 12:48:03'); INSERT INTO `sys_menu` VALUES ('15', '7', '刷新', '/sys/role/list', 'sys:role:list', '2', null, '0', '2017-08-14 10:56:37', '2017-09-05 12:44:04'); INSERT INTO `sys_menu` VALUES ('16', '7', '新增', '/sys/role/save', 'sys:role:save', '2', null, '0', '2017-08-14 10:57:02', '2017-09-05 12:44:23'); INSERT INTO `sys_menu` VALUES ('17', '7', '编辑', '/sys/role/update', 'sys:role:edit', '2', null, '0', '2017-08-14 10:57:31', '2017-09-05 12:44:48'); INSERT INTO `sys_menu` VALUES ('18', '7', '删除', '/sys/role/remove', 'sys:role:remove', '2', null, '0', '2017-08-14 10:57:50', '2017-09-05 12:45:02'); INSERT INTO `sys_menu` VALUES ('19', '7', '操作权限', '/sys/role/authorize/opt', 'sys:role:authorizeOpt', '2', null, '0', '2017-08-14 10:58:55', '2017-09-05 12:45:29'); INSERT INTO `sys_menu` VALUES ('20', '2', '刷新', '/sys/menu/list', 'sys:menu:list', '2', null, '0', '2017-08-14 10:59:32', '2017-09-05 13:06:24'); INSERT INTO `sys_menu` VALUES ('21', '2', '新增', '/sys/menu/save', 'sys:menu:save', '2', null, '0', '2017-08-14 10:59:56', '2017-09-05 13:06:35'); INSERT INTO `sys_menu` VALUES ('22', '2', '编辑', '/sys/menu/update', 'sys:menu:edit', '2', null, '0', '2017-08-14 11:00:26', '2017-09-05 13:06:48'); INSERT INTO `sys_menu` VALUES ('23', '2', '删除', '/sys/menu/remove', 'sys:menu:remove', '2', null, '0', '2017-08-14 11:00:58', '2017-09-05 13:07:00'); INSERT INTO `sys_menu` VALUES ('24', '6', '启用', '/sys/user/enable', 'sys:user:enable', '2', null, '0', '2017-08-14 17:27:18', '2017-09-05 12:48:30'); INSERT INTO `sys_menu` VALUES ('25', '6', '停用', '/sys/user/disable', 'sys:user:disable', '2', null, '0', '2017-08-14 17:27:43', '2017-09-05 12:48:49'); INSERT INTO `sys_menu` VALUES ('26', '6', '重置密码', '/sys/user/rest', 'sys:user:resetPassword', '2', null, '0', '2017-08-14 17:28:34', '2017-09-05 12:49:17'); INSERT INTO `sys_menu` VALUES ('27', '1', '系统日志', 'base/log/list.html', null, '1', 'fa fa-warning', '3', '2017-08-14 22:11:53', '2017-08-17 09:55:19'); INSERT INTO `sys_menu` VALUES ('28', '27', '刷新', '/sys/log/list', 'sys:log:list', '2', null, '0', '2017-08-14 22:30:22', '2017-09-05 13:05:24'); INSERT INTO `sys_menu` VALUES ('29', '27', '删除', '/sys/log/remove', 'sys:log:remove', '2', null, '0', '2017-08-14 22:30:43', '2017-09-05 13:05:37'); INSERT INTO `sys_menu` VALUES ('30', '27', '清空', '/sys/log/clear', 'sys:log:clear', '2', null, '0', '2017-08-14 22:31:02', '2017-09-05 13:05:53'); INSERT INTO `sys_menu` VALUES ('32', '4', '刷新', '/sys/macro/list', 'sys:macro:list', '2', null, '0', '2017-08-15 16:55:33', '2017-09-05 13:04:00'); INSERT INTO `sys_menu` VALUES ('33', '4', '新增', '/sys/macro/save', 'sys:macro:save', '2', null, '0', '2017-08-15 16:55:52', '2017-09-05 13:04:22'); INSERT INTO `sys_menu` VALUES ('34', '4', '编辑', '/sys/macro/update', 'sys:macro:edit', '2', null, '0', '2017-08-15 16:56:09', '2017-09-05 13:04:36'); INSERT INTO `sys_menu` VALUES ('35', '4', '删除', '/sys/macro/remove', 'sys:macro:remove', '2', null, '0', '2017-08-15 16:56:29', '2017-09-05 13:04:49'); INSERT INTO `sys_menu` VALUES ('36', '3', '机构管理', 'base/org/list.html', '', '1', 'fa fa-sitemap', '0', '2017-08-17 09:57:14', '2017-09-05 12:58:53'); INSERT INTO `sys_menu` VALUES ('37', '1', '行政区域', 'base/area/list.html', 'sys:area:list', '1', 'fa fa-leaf', '0', '2017-08-17 09:59:57', '2017-09-05 12:49:47'); INSERT INTO `sys_menu` VALUES ('38', '37', '刷新', '/sys/area/list', 'sys:area:list', '2', null, '0', '2017-08-17 10:01:33', '2017-09-05 13:00:54'); INSERT INTO `sys_menu` VALUES ('39', '37', '新增', '/sys/area/save', 'sys:area:save', '2', null, '0', '2017-08-17 10:02:16', '2017-09-05 13:01:06'); INSERT INTO `sys_menu` VALUES ('40', '37', '编辑', '/sys/area/update', 'sys:area:edit', '2', null, '0', '2017-08-17 10:02:33', '2017-09-05 13:01:21'); INSERT INTO `sys_menu` VALUES ('41', '37', '删除', '/sys/area/remove', 'sys:area:remove', '2', null, '0', '2017-08-17 10:02:50', '2017-09-05 13:01:32'); INSERT INTO `sys_menu` VALUES ('42', '36', '刷新', '/sys/org/list', 'sys:org:list', '2', null, '0', '2017-08-17 10:03:36', '2017-09-05 11:47:37'); INSERT INTO `sys_menu` VALUES ('43', '36', '新增', '/sys/org/save', 'sys:org:save', '2', null, '0', '2017-08-17 10:03:54', '2017-09-05 12:40:55'); INSERT INTO `sys_menu` VALUES ('44', '36', '编辑', '/sys/org/update', 'sys:org:edit', '2', null, '0', '2017-08-17 10:04:11', '2017-09-05 12:43:06'); INSERT INTO `sys_menu` VALUES ('45', '36', '删除', '/sys/org/remove', 'sys:org:remove', '2', null, '0', '2017-08-17 10:04:30', '2017-09-05 12:42:19'); INSERT INTO `sys_menu` VALUES ('46', '7', '数据权限', '/sys/role/authorize/data', 'sys:role:authorizeData', '2', null, '0', '2017-08-17 13:48:11', '2017-09-05 12:45:54'); INSERT INTO `sys_menu` VALUES ('47', '1', '定时任务', 'base/quartz/list.html', null, '1', 'fa fa-bell', '4', '2017-08-19 23:00:08', null); INSERT INTO `sys_menu` VALUES ('48', '47', '刷新', '/quartz/job/list', 'quartz:job:list', '2', null, '0', '2017-08-19 23:00:54', '2017-09-05 13:08:18'); INSERT INTO `sys_menu` VALUES ('49', '47', '新增', '/quartz/job/save', 'quartz:job:save', '2', null, '0', '2017-08-19 23:01:29', '2017-09-05 13:08:30'); INSERT INTO `sys_menu` VALUES ('50', '47', '编辑', '/quartz/job/update', 'quartz:job:edit', '2', null, '0', '2017-08-19 23:01:58', '2017-09-05 13:08:44'); INSERT INTO `sys_menu` VALUES ('51', '47', '删除', '/quartz/job/remove', 'quartz:job:remove', '2', null, '0', '2017-08-19 23:02:30', '2017-09-05 13:08:57'); INSERT INTO `sys_menu` VALUES ('52', '63', '启用', '/quartz/job/enable', 'quartz:job:enable', '2', null, '0', '2017-08-19 23:08:59', '2017-09-13 22:12:35'); INSERT INTO `sys_menu` VALUES ('53', '63', '停用', '/quartz/job/disable', 'quartz:job:disable', '2', null, '0', '2017-08-19 23:09:31', '2017-09-13 22:12:53'); INSERT INTO `sys_menu` VALUES ('54', '63', '立即执行', '/quartz/job/run', 'quartz:job:run', '2', null, '0', '2017-08-19 23:10:09', '2017-09-13 22:13:11'); INSERT INTO `sys_menu` VALUES ('55', '47', '日志列表', null, 'quartz:job:log', '1', null, '0', '2017-08-19 23:10:40', '2017-09-13 22:21:12'); INSERT INTO `sys_menu` VALUES ('56', '55', '刷新', '/quartz/job/log/list', 'quartz:log:list', '2', null, '0', '2017-08-21 13:25:33', '2017-09-13 22:21:27'); INSERT INTO `sys_menu` VALUES ('57', '55', '删除', '/quartz/job/log/remove', 'quartz:log:remove', '2', null, '0', '2017-08-21 13:25:52', '2017-09-13 22:21:46'); INSERT INTO `sys_menu` VALUES ('58', '55', '清空', '/quartz/job/log/clear', 'quartz:log:clear', '2', null, '0', '2017-08-21 13:26:11', '2017-09-13 22:22:04'); INSERT INTO `sys_menu` VALUES ('59', '1', '敏捷开发', 'base/generator/list.html', null, '1', 'fa fa-archive', '5', '2017-09-05 10:49:04', null); INSERT INTO `sys_menu` VALUES ('60', '59', '刷新', '/sys/generator/list', 'sys:gen:list', '2', null, '0', '2017-09-05 10:49:25', '2017-09-05 13:07:33'); INSERT INTO `sys_menu` VALUES ('61', '59', '生成代码', '/sys/generator/code', 'sys:gen:code', '2', null, '0', '2017-09-05 10:49:44', '2017-09-05 13:07:48'); INSERT INTO `sys_menu` VALUES ('62', '1', '系统监控', 'druid/index.html', null, '1', 'fa fa-bug', '6', '2017-09-10 17:01:59', '2017-09-10 17:02:19'); INSERT INTO `sys_menu` VALUES ('63', '47', '更多', null, 'quartz:job:more', '1', null, '0', '2017-09-13 22:11:51', '2017-09-13 22:12:12'); INSERT INTO `sys_menu` VALUES ('64', '1', '接口管理', 'swagger-ui.html', null, '1', 'fa fa-support', '7', '2017-09-10 17:01:59', '2017-09-10 17:02:19'); -- ---------------------------- -- Table structure for sys_org -- ---------------------------- DROP TABLE IF EXISTS `sys_org`; CREATE TABLE `sys_org` ( `org_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '机构id', `parent_id` bigint(20) DEFAULT NULL COMMENT '上级机构ID，一级机构为0', `code` varchar(100) DEFAULT NULL COMMENT '机构编码', `name` varchar(100) DEFAULT NULL COMMENT '机构名称', `order_num` int(11) DEFAULT NULL COMMENT '排序', `status` tinyint(4) DEFAULT '1' COMMENT '可用标识 1：可用 0：不可用', `gmt_create` datetime DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`org_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='机构管理'; -- ---------------------------- -- Records of sys_org -- ---------------------------- INSERT INTO `sys_org` VALUES ('1', '0', 'js', '江苏省', '0', '1', '2017-08-17 12:03:15', '2017-08-17 17:06:08'); -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色id', `org_id` bigint(255) DEFAULT NULL COMMENT '所属机构', `role_name` varchar(100) DEFAULT NULL COMMENT '角色名称', `role_sign` varchar(100) DEFAULT NULL COMMENT '角色标识', `remark` varchar(100) DEFAULT NULL COMMENT '备注', `user_id_create` bigint(255) DEFAULT NULL COMMENT '创建用户id', `gmt_create` datetime DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`role_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统角色'; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1', '1', '超级管理员', 'admin', '【系统内置】', '2', '2017-08-12 00:43:52', '2017-09-05 14:02:04'); -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系'; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- INSERT INTO `sys_role_menu` VALUES (null, '1', '1'); INSERT INTO `sys_role_menu` VALUES (null, '1', '2'); INSERT INTO `sys_role_menu` VALUES (null, '1', '4'); INSERT INTO `sys_role_menu` VALUES (null, '1', '3'); INSERT INTO `sys_role_menu` VALUES (null, '1', '6'); INSERT INTO `sys_role_menu` VALUES (null, '1', '7'); INSERT INTO `sys_role_menu` VALUES (null, '1', '11'); INSERT INTO `sys_role_menu` VALUES (null, '1', '12'); INSERT INTO `sys_role_menu` VALUES (null, '1', '13'); INSERT INTO `sys_role_menu` VALUES (null, '1', '14'); INSERT INTO `sys_role_menu` VALUES (null, '1', '15'); INSERT INTO `sys_role_menu` VALUES (null, '1', '16'); INSERT INTO `sys_role_menu` VALUES (null, '1', '17'); INSERT INTO `sys_role_menu` VALUES (null, '1', '18'); INSERT INTO `sys_role_menu` VALUES (null, '1', '19'); INSERT INTO `sys_role_menu` VALUES (null, '1', '20'); INSERT INTO `sys_role_menu` VALUES (null, '1', '21'); INSERT INTO `sys_role_menu` VALUES (null, '1', '22'); INSERT INTO `sys_role_menu` VALUES (null, '1', '23'); INSERT INTO `sys_role_menu` VALUES (null, '1', '24'); INSERT INTO `sys_role_menu` VALUES (null, '1', '25'); INSERT INTO `sys_role_menu` VALUES (null, '1', '26'); INSERT INTO `sys_role_menu` VALUES (null, '1', '27'); INSERT INTO `sys_role_menu` VALUES (null, '1', '28'); INSERT INTO `sys_role_menu` VALUES (null, '1', '29'); INSERT INTO `sys_role_menu` VALUES (null, '1', '30'); INSERT INTO `sys_role_menu` VALUES (null, '1', '32'); INSERT INTO `sys_role_menu` VALUES (null, '1', '33'); INSERT INTO `sys_role_menu` VALUES (null, '1', '34'); INSERT INTO `sys_role_menu` VALUES (null, '1', '35'); INSERT INTO `sys_role_menu` VALUES (null, '1', '36'); INSERT INTO `sys_role_menu` VALUES (null, '1', '37'); INSERT INTO `sys_role_menu` VALUES (null, '1', '38'); INSERT INTO `sys_role_menu` VALUES (null, '1', '39'); INSERT INTO `sys_role_menu` VALUES (null, '1', '40'); INSERT INTO `sys_role_menu` VALUES (null, '1', '41'); INSERT INTO `sys_role_menu` VALUES (null, '1', '42'); INSERT INTO `sys_role_menu` VALUES (null, '1', '43'); INSERT INTO `sys_role_menu` VALUES (null, '1', '44'); INSERT INTO `sys_role_menu` VALUES (null, '1', '45'); INSERT INTO `sys_role_menu` VALUES (null, '1', '46'); INSERT INTO `sys_role_menu` VALUES (null, '1', '47'); INSERT INTO `sys_role_menu` VALUES (null, '1', '48'); INSERT INTO `sys_role_menu` VALUES (null, '1', '49'); INSERT INTO `sys_role_menu` VALUES (null, '1', '50'); INSERT INTO `sys_role_menu` VALUES (null, '1', '51'); INSERT INTO `sys_role_menu` VALUES (null, '1', '55'); INSERT INTO `sys_role_menu` VALUES (null, '1', '56'); INSERT INTO `sys_role_menu` VALUES (null, '1', '57'); INSERT INTO `sys_role_menu` VALUES (null, '1', '58'); INSERT INTO `sys_role_menu` VALUES (null, '1', '63'); INSERT INTO `sys_role_menu` VALUES (null, '1', '52'); INSERT INTO `sys_role_menu` VALUES (null, '1', '53'); INSERT INTO `sys_role_menu` VALUES (null, '1', '54'); INSERT INTO `sys_role_menu` VALUES (null, '1', '59'); INSERT INTO `sys_role_menu` VALUES (null, '1', '60'); INSERT INTO `sys_role_menu` VALUES (null, '1', '61'); INSERT INTO `sys_role_menu` VALUES (null, '1', '62'); INSERT INTO `sys_role_menu` VALUES (null, '1', '64'); -- ---------------------------- -- Table structure for sys_role_org -- ---------------------------- DROP TABLE IF EXISTS `sys_role_org`; CREATE TABLE `sys_role_org` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `org_id` bigint(20) DEFAULT NULL COMMENT '机构ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='角色与机构对应关系'; -- ---------------------------- -- Records of sys_role_org -- ---------------------------- INSERT INTO `sys_role_org` VALUES (null, '1', '1'); -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户id', `org_id` bigint(255) DEFAULT NULL COMMENT '所属机构', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `password` varchar(50) DEFAULT NULL COMMENT '密码', `email` varchar(100) DEFAULT NULL COMMENT '邮箱', `mobile` varchar(100) DEFAULT NULL COMMENT '手机号', `status` tinyint(255) DEFAULT NULL COMMENT '状态 0:禁用，1:正常', `remark` varchar(500) DEFAULT NULL COMMENT '备注', `user_id_create` bigint(255) DEFAULT NULL COMMENT '创建用户id', `gmt_create` datetime DEFAULT NULL COMMENT '创建时间', `gmt_modified` datetime DEFAULT NULL COMMENT '修改时间', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统用户'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1', '1', 'admin', '33808479d49ca8a3cdc93d4f976d1e3d', 'admin@example.com', '123456', '1', null, '1', '2017-08-15 21:40:39', '2017-08-15 21:41:00'); -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录id', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系'; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES (null, '1', '1'); -- ---------------------------- -- Table structure for sys_user_token -- ---------------------------- DROP TABLE IF EXISTS `sys_user_token`; CREATE TABLE `sys_user_token` ( `user_id` bigint(20) NOT NULL COMMENT '用户id', `token` varchar(100) NOT NULL COMMENT 'token', `gmt_expire` datetime DEFAULT NULL COMMENT '过期时间', `gmt_modified` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`user_id`), UNIQUE KEY `token` (`token`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户Token'; -- ---------------------------- -- Records of sys_user_token -- ---------------------------- insert into `sys_user_token`(`user_id`,`token`,`gmt_expire`,`gmt_modified`) values (1,'a3c646202882f1213b63fe74dc118e9d','2017-10-26 22:10:52','2017-10-26 10:10:52');