/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50728
Source Host           : localhost:3306
Source Database       : easydo_admin

Target Server Type    : MYSQL
Target Server Version : 50728
File Encoding         : 65001

Date: 2021-02-26 11:05:59
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '用户名称',
  `nickname` varchar(50) CHARACTER SET utf8 NOT NULL COMMENT '用户昵称',
  `password_hash` varchar(255) CHARACTER SET utf8 NOT NULL COMMENT '密码',
  `password_reset_token` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '重置密码时的验证字串',
  `email` varchar(60) CHARACTER SET utf8 DEFAULT NULL COMMENT '邮箱',
  `auth_key` varchar(255) DEFAULT NULL,
  `admin_avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `login_ip` int(11) unsigned DEFAULT NULL COMMENT '登录地址',
  `login_at` datetime DEFAULT NULL COMMENT '登录时间',
  `login_num` bigint(20) unsigned DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(2) unsigned NOT NULL DEFAULT '10' COMMENT '0禁止登陆，10允许登陆',
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='管理员用户表';

-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES ('1', 'admin', '$2y$13$nKXIfHwMpwvaRBs9EXn2NeEA3nMvL1sgkYjUE4pX0livTPq2LIxKu', null, 'aasdssss@qq.com', null, '/images/avatar.png', '2130706433', '2021-02-26 10:39:39', '8', '10', '2021-02-26 10:39:39', '2018-03-07 15:37:42');

-- ----------------------------
-- Table structure for admin_user_session
-- ----------------------------
DROP TABLE IF EXISTS `admin_user_session`;
CREATE TABLE `admin_user_session` (
  `id` varchar(255) NOT NULL,
  `expire` int(11) DEFAULT NULL,
  `data` longblob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理用户登录 session 表';

-- ----------------------------
-- Records of admin_user_session
-- ----------------------------

-- ----------------------------
-- Table structure for app_modules
-- ----------------------------
DROP TABLE IF EXISTS `app_modules`;
CREATE TABLE `app_modules` (
  `id` varchar(50) NOT NULL COMMENT '编号',
  `type` varchar(255) DEFAULT '' COMMENT '类型',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `class` varchar(100) NOT NULL COMMENT '对应类名',
  `config` varchar(500) DEFAULT NULL COMMENT '配置',
  `status` tinyint(3) unsigned DEFAULT '0' COMMENT '状态 0禁用 1启用',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='应用模块';

-- ----------------------------
-- Records of app_modules
-- ----------------------------

-- ----------------------------
-- Table structure for auth_assignment
-- ----------------------------
DROP TABLE IF EXISTS `auth_assignment`;
CREATE TABLE `auth_assignment` (
  `item_name` varchar(64) NOT NULL,
  `user_id` varchar(64) NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`item_name`,`user_id`),
  KEY `auth_assignment_user_id_idx` (`user_id`),
  CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限分配';

-- ----------------------------
-- Records of auth_assignment
-- ----------------------------
INSERT INTO `auth_assignment` VALUES ('超级管理员', '1', '1603269893');

-- ----------------------------
-- Table structure for auth_item
-- ----------------------------
DROP TABLE IF EXISTS `auth_item`;
CREATE TABLE `auth_item` (
  `name` varchar(64) NOT NULL,
  `type` smallint(6) NOT NULL,
  `description` text,
  `rule_name` varchar(64) DEFAULT NULL,
  `data` blob,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`),
  KEY `rule_name` (`rule_name`),
  KEY `type` (`type`),
  CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='路由列表';

-- ----------------------------
-- Records of auth_item
-- ----------------------------
INSERT INTO `auth_item` VALUES ('/*', '2', null, null, null, '1603269871', '1603269871');
INSERT INTO `auth_item` VALUES ('/admin-user/*', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/admin-user/create', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/admin-user/delete', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/admin-user/index', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/admin-user/toggle', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/admin-user/update', '2', null, null, null, '1606486539', '1606486539');
INSERT INTO `auth_item` VALUES ('/app-modules/*', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/app-modules/create', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/app-modules/delete', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/app-modules/index', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/app-modules/toggle', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/app-modules/update', '2', null, null, null, '1609740855', '1609740855');
INSERT INTO `auth_item` VALUES ('/auth/assignment/assign', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/assignment/revoke', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/assignment/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/assign', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/delete', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/remove', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/update', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/item/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/delete', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/toggle-column', '2', null, null, null, '1608354219', '1608354219');
INSERT INTO `auth_item` VALUES ('/auth/menu/update', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/menu/update-order', '2', null, null, null, '1609907813', '1609907813');
INSERT INTO `auth_item` VALUES ('/auth/menu/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/assign', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/delete', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/remove', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/update', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/permission/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/assign', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/delete', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/remove', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/update', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/role/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/assign', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/refresh', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/route/remove', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/*', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/create', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/delete', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/index', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/update', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/auth/rule/view', '2', null, null, null, '1607428184', '1607428184');
INSERT INTO `auth_item` VALUES ('/file/*', '2', null, null, null, '1609826163', '1609826163');
INSERT INTO `auth_item` VALUES ('/file/image', '2', null, null, null, '1609826162', '1609826162');
INSERT INTO `auth_item` VALUES ('/file/thumb', '2', null, null, null, '1609826163', '1609826163');
INSERT INTO `auth_item` VALUES ('/file/video', '2', null, null, null, '1609826162', '1609826162');
INSERT INTO `auth_item` VALUES ('/file/voice', '2', null, null, null, '1609826162', '1609826162');
INSERT INTO `auth_item` VALUES ('/file/wand-editor-image', '2', null, null, null, '1610008412', '1610008412');
INSERT INTO `auth_item` VALUES ('/log/*', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/log/default/*', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/log/default/archive', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/log/default/history', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/log/default/index', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/log/default/view', '2', null, null, null, '1614225809', '1614225809');
INSERT INTO `auth_item` VALUES ('/site/index', '2', null, null, null, '1603269723', '1603269723');
INSERT INTO `auth_item` VALUES ('/system/*', '2', null, null, null, '1607350738', '1607350738');
INSERT INTO `auth_item` VALUES ('/system/cache', '2', null, null, null, '1606656427', '1606656427');
INSERT INTO `auth_item` VALUES ('/system/cdn', '2', null, null, null, '1606656427', '1606656427');
INSERT INTO `auth_item` VALUES ('/system/ocp', '2', null, null, null, '1606656427', '1606656427');
INSERT INTO `auth_item` VALUES ('/wp/reply-rule/*', '2', null, null, null, '1611286480', '1611286480');
INSERT INTO `auth_item` VALUES ('应用模块', '2', null, null, null, '1609740872', '1609740872');
INSERT INTO `auth_item` VALUES ('文件上传', '2', null, null, null, '1609826170', '1609826170');
INSERT INTO `auth_item` VALUES ('服务环境', '2', null, null, null, '1603269744', '1603471385');
INSERT INTO `auth_item` VALUES ('权限管理', '2', null, null, null, '1607428211', '1607428211');
INSERT INTO `auth_item` VALUES ('查看日志', '2', null, null, null, '1614225823', '1614225823');
INSERT INTO `auth_item` VALUES ('管理员账号', '2', null, null, null, '1606486526', '1607261382');
INSERT INTO `auth_item` VALUES ('系统管理', '2', null, null, null, '1606656452', '1606656452');
INSERT INTO `auth_item` VALUES ('超级管理员', '1', null, null, null, '1603269859', '1614237346');

-- ----------------------------
-- Table structure for auth_item_child
-- ----------------------------
DROP TABLE IF EXISTS `auth_item_child`;
CREATE TABLE `auth_item_child` (
  `parent` varchar(64) NOT NULL,
  `child` varchar(64) NOT NULL,
  PRIMARY KEY (`parent`,`child`),
  KEY `child` (`child`),
  CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='权限列表';

-- ----------------------------
-- Records of auth_item_child
-- ----------------------------
INSERT INTO `auth_item_child` VALUES ('超级管理员', '/*');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/*');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/create');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/delete');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/index');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/toggle');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/update');
INSERT INTO `auth_item_child` VALUES ('管理员账号', '/admin-user/view');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/*');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/create');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/delete');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/index');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/toggle');
INSERT INTO `auth_item_child` VALUES ('应用模块', '/app-modules/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/assignment/assign');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/assignment/revoke');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/assignment/view');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/assign');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/delete');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/remove');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/item/view');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/delete');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/toggle-column');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/menu/view');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/assign');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/delete');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/remove');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/permission/view');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/assign');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/delete');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/remove');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/role/view');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/assign');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/refresh');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/route/remove');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/*');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/create');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/delete');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/index');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/update');
INSERT INTO `auth_item_child` VALUES ('权限管理', '/auth/rule/view');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/*');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/image');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/thumb');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/video');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/voice');
INSERT INTO `auth_item_child` VALUES ('文件上传', '/file/wand-editor-image');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/*');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/default/*');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/default/archive');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/default/history');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/default/index');
INSERT INTO `auth_item_child` VALUES ('查看日志', '/log/default/view');
INSERT INTO `auth_item_child` VALUES ('服务环境', '/site/index');
INSERT INTO `auth_item_child` VALUES ('系统管理', '/system/cache');
INSERT INTO `auth_item_child` VALUES ('系统管理', '/system/cdn');
INSERT INTO `auth_item_child` VALUES ('系统管理', '/system/ocp');

-- ----------------------------
-- Table structure for auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `auth_rule`;
CREATE TABLE `auth_rule` (
  `name` varchar(64) NOT NULL,
  `data` blob,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='规则列表';

-- ----------------------------
-- Records of auth_rule
-- ----------------------------

-- ----------------------------
-- Table structure for cdn_config
-- ----------------------------
DROP TABLE IF EXISTS `cdn_config`;
CREATE TABLE `cdn_config` (
  `class` varchar(100) NOT NULL COMMENT '存储名称',
  `appId` varchar(100) DEFAULT NULL COMMENT 'appId',
  `accessKey` varchar(100) DEFAULT NULL COMMENT 'accessKey',
  `accessSecret` varchar(255) DEFAULT NULL COMMENT 'accessSecret',
  `bucket` varchar(100) DEFAULT NULL COMMENT '存储空间(bucket)',
  `endPoint` varchar(50) DEFAULT NULL COMMENT '存储节点(endPoint)',
  `host` varchar(255) DEFAULT NULL COMMENT '存储域名(host)',
  `status` int(1) DEFAULT NULL COMMENT '状态',
  PRIMARY KEY (`class`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='云存储配置';

-- ----------------------------
-- Records of cdn_config
-- ----------------------------
INSERT INTO `cdn_config` VALUES ('feehi\\cdn\\AliossTarget', null, null, null, null, null, null, '0');
INSERT INTO `cdn_config` VALUES ('feehi\\cdn\\NeteaseTarget', null, null, null, null, null, null, '0');
INSERT INTO `cdn_config` VALUES ('feehi\\cdn\\QcloudTarget', null, null, null, null, null, null, '0');
INSERT INTO `cdn_config` VALUES ('feehi\\cdn\\QiniuTarget', null, null, null, null, null, null, '0');

-- ----------------------------
-- Table structure for menu
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `parent` int(11) DEFAULT NULL,
  `route` varchar(255) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `data` blob,
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `menu` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='菜单列表';

-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('1', '基础管理', null, null, '1', 0x7B2269636F6E223A22636F6773227D);
INSERT INTO `menu` VALUES ('2', '服务环境', '1', '/site/index', '0', 0x7B2269636F6E223A22686F6D65227D);
INSERT INTO `menu` VALUES ('3', '系统用户', '1', '/admin-user/index', '10', 0x7B2269636F6E223A2275736572227D);
INSERT INTO `menu` VALUES ('4', '系统管理', '1', null, '20', 0x7B2269636F6E223A22636F67222C2276697369626C65223A2231227D);
INSERT INTO `menu` VALUES ('5', '缓存管理', '4', '/system/cache', '1', 0x7B2269636F6E223A2266696C652D636F64652D6F222C2276697369626C65223A2231227D);
INSERT INTO `menu` VALUES ('6', '云存储', '4', '/system/cdn', '10', 0x7B2269636F6E223A22636C6F75642D75706C6F6164227D);
INSERT INTO `menu` VALUES ('7', '权限管理', '1', null, '30', 0x7B2269636F6E223A226C6F636B227D);
INSERT INTO `menu` VALUES ('9', '角色列表', '7', '/auth/role/index', '20', null);
INSERT INTO `menu` VALUES ('10', '权限列表', '7', '/auth/permission/index', '30', null);
INSERT INTO `menu` VALUES ('11', '路由列表', '7', '/auth/route/index', '40', null);
INSERT INTO `menu` VALUES ('12', '规则列表', '7', '/auth/rule/index', '50', null);
INSERT INTO `menu` VALUES ('13', '菜单列表', '7', '/auth/menu/index', '60', null);
INSERT INTO `menu` VALUES ('20', '应用模块', '1', '/app-modules/index', '15', 0x7B2269636F6E223A226375626573222C2276697369626C65223A2231227D);
INSERT INTO `menu` VALUES ('21', 'Opcache', '4', '/system/ocp', '20', 0x7B2269636F6E223A22666C617368222C2276697369626C65223A2231227D);
INSERT INTO `menu` VALUES ('58', '查看日志', '4', '/log/default/index', '30', 0x7B2269636F6E223A2266696C652D746578742D6F222C2276697369626C65223A2231227D);