text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 47.95.232.28_3306
   Source Server Type    : MySQL
   Source Server Version : 50640
   Source Host           : 47.95.232.28:3306
   Source Schema         : f1st
  
   Target Server Type    : MySQL
   Target Server Version : 50640
   File Encoding         : 65001
  
   Date: 18/07/2018 20:23:19
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for QRTZ_BLOB_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
  CREATE TABLE `QRTZ_BLOB_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `BLOB_DATA` blob,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    INDEX `SCHED_NAME`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_CALENDARS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
  CREATE TABLE `QRTZ_CALENDARS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `CALENDAR` blob NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_CRON_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
  CREATE TABLE `QRTZ_CRON_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_FIRED_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
  CREATE TABLE `QRTZ_FIRED_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `FIRED_TIME` bigint(13) NOT NULL,
    `SCHED_TIME` bigint(13) NOT NULL,
    `PRIORITY` int(11) NOT NULL,
    `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE,
    INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`(`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE,
    INDEX `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY`(`SCHED_NAME`, `INSTANCE_NAME`, `REQUESTS_RECOVERY`) USING BTREE,
    INDEX `IDX_QRTZ_FT_J_G`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_FT_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_FT_T_G`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_FT_TG`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_JOB_DETAILS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
  CREATE TABLE `QRTZ_JOB_DETAILS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_DATA` blob,
    PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME`, `REQUESTS_RECOVERY`) USING BTREE,
    INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_LOCKS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_LOCKS`;
  CREATE TABLE `QRTZ_LOCKS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of QRTZ_LOCKS
  -- ----------------------------
  INSERT INTO `QRTZ_LOCKS` VALUES ('QuartzScheduler', 'STATE_ACCESS');
  
  -- ----------------------------
  -- Table structure for QRTZ_PAUSED_TRIGGER_GRPS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
  CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_SCHEDULER_STATE
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
  CREATE TABLE `QRTZ_SCHEDULER_STATE`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
    `CHECKIN_INTERVAL` bigint(13) NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of QRTZ_SCHEDULER_STATE
  -- ----------------------------
  INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('QuartzScheduler', 'NON_CLUSTERED', 1531916603463, 7500);
  
  -- ----------------------------
  -- Table structure for QRTZ_SIMPLE_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
  CREATE TABLE `QRTZ_SIMPLE_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `REPEAT_COUNT` bigint(7) NOT NULL,
    `REPEAT_INTERVAL` bigint(12) NOT NULL,
    `TIMES_TRIGGERED` bigint(10) NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    CONSTRAINT `QRTZ_SIMPLE_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_SIMPROP_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_SIMPROP_TRIGGERS`;
  CREATE TABLE `QRTZ_SIMPROP_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `INT_PROP_1` int(11) DEFAULT NULL,
    `INT_PROP_2` int(11) DEFAULT NULL,
    `LONG_PROP_1` bigint(20) DEFAULT NULL,
    `LONG_PROP_2` bigint(20) DEFAULT NULL,
    `DEC_PROP_1` decimal(13, 4) DEFAULT NULL,
    `DEC_PROP_2` decimal(13, 4) DEFAULT NULL,
    `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    CONSTRAINT `QRTZ_SIMPROP_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for QRTZ_TRIGGERS
  -- ----------------------------
  DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
  CREATE TABLE `QRTZ_TRIGGERS`  (
    `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
    `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
    `PRIORITY` int(11) DEFAULT NULL,
    `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `START_TIME` bigint(13) NOT NULL,
    `END_TIME` bigint(13) DEFAULT NULL,
    `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
    `JOB_DATA` blob,
    PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_T_J`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_T_C`(`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE,
    INDEX `IDX_QRTZ_T_G`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE,
    INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME`, `TRIGGER_STATE`) USING BTREE,
    INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
    INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
    INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME`, `NEXT_FIRE_TIME`) USING BTREE,
    INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME`, `TRIGGER_STATE`, `NEXT_FIRE_TIME`) USING BTREE,
    INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`) USING BTREE,
    INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_STATE`) USING BTREE,
    INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
    CONSTRAINT `QRTZ_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `QRTZ_JOB_DETAILS` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for blog_article
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_article`;
  CREATE TABLE `blog_article`  (
    `article_id` int(16) NOT NULL,
    `user_id` int(16) NOT NULL,
    `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
    `category_id` int(16) DEFAULT NULL,
    `click_count` int(10) UNSIGNED DEFAULT 0,
    `is_recommend` tinyint(1) UNSIGNED ZEROFILL DEFAULT NULL,
    `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    `publish_time` datetime(0) DEFAULT NULL,
    `article_state` tinyint(1) NOT NULL,
    PRIMARY KEY (`article_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for blog_article_tag
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_article_tag`;
  CREATE TABLE `blog_article_tag`  (
    `id` int(16) NOT NULL,
    `article_id` int(16) NOT NULL,
    `tagId` int(16) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for blog_category
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_category`;
  CREATE TABLE `blog_category`  (
    `category_id` int(16) NOT NULL,
    `pid` int(16) NOT NULL,
    `user_id` int(16) NOT NULL,
    `category_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    PRIMARY KEY (`category_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for blog_comment
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_comment`;
  CREATE TABLE `blog_comment`  (
    `comment_id` int(16) NOT NULL,
    `pid` int(16) NOT NULL,
    `comment_user_id` int(16) NOT NULL,
    `content` varchar(225) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `article_id` int(16) NOT NULL,
    `user_id` int(16) NOT NULL,
    `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    PRIMARY KEY (`comment_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for blog_tag
  -- ----------------------------
  DROP TABLE IF EXISTS `blog_tag`;
  CREATE TABLE `blog_tag`  (
    `tag_id` int(16) NOT NULL,
    `pid` int(16) NOT NULL,
    `user_id` int(16) NOT NULL,
    `tag_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    PRIMARY KEY (`tag_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Table structure for sys_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_permission`;
  CREATE TABLE `sys_permission`  (
    `permission_id` int(16) NOT NULL AUTO_INCREMENT,
    `permission_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `permission_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `parent_id` int(16) DEFAULT NULL,
    `seq` int(16) UNSIGNED ZEROFILL DEFAULT NULL,
    `create_time` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    `permission_pic` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    PRIMARY KEY (`permission_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_permission
  -- ----------------------------
  INSERT INTO `sys_permission` VALUES (1, '系统管理', 'menu', '', '', 0, 0000000000000098, '2018-06-26 20:58:47', '2018-07-12 20:58:41', 'fa-home');
  INSERT INTO `sys_permission` VALUES (2, '用户管理', 'menu', 'sys/base/sysUserList.html', 'userInfo:view', 1, 0000000000000001, '2018-06-17 00:11:49', '2018-06-26 21:15:07', 'fa-user-plus');
  INSERT INTO `sys_permission` VALUES (3, '角色管理', 'menu', 'sys/base/sysRoleList.html', '', 1, 0000000000000002, '2018-06-16 22:26:17', '2018-06-26 21:14:44', 'fa-user-circle');
  INSERT INTO `sys_permission` VALUES (4, '权限管理', 'menu', 'sys/base/sysPermissionList.html', '', 1, 0000000000000003, '2018-06-16 23:10:45', '2018-06-26 21:27:24', 'fa-folder');
  INSERT INTO `sys_permission` VALUES (5, '角色权限管理', 'menu', 'sys/base/sysRolePermissionList.html', '', 1, 0000000000000004, '2018-06-26 21:25:50', '2018-06-26 21:21:14', 'fa-address-card-o');
  INSERT INTO `sys_permission` VALUES (7, '个人管理', 'menu', '', '', 0, 0000000000000099, '2018-06-17 12:00:17', '2018-07-12 20:58:28', 'fa-cog');
  INSERT INTO `sys_permission` VALUES (8, '修改密码', 'menu', '', '', 7, 0000000000000001, '2018-06-26 21:27:58', '2018-06-17 12:00:40', 'fa-address-book-o');
  INSERT INTO `sys_permission` VALUES (9, '博客', 'menu', '', '', 0, 0000000000000001, '2018-07-12 20:51:06', '2018-07-12 21:08:07', 'fa-envelope');
  INSERT INTO `sys_permission` VALUES (11, '个人博客', 'menu', 'blog/myblog.html', '', 9, 0000000000000000, '2018-07-12 20:44:03', '2018-07-12 21:08:23', '');
  INSERT INTO `sys_permission` VALUES (12, '任务管理', 'menu', 'sys/base/sysQuartzInfoList.html', '', 1, 0000000000000005, '2018-07-18 20:20:21', '2018-07-18 20:20:38', 'fa-clock-o');
  
  -- ----------------------------
  -- Table structure for sys_role
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role`;
  CREATE TABLE `sys_role`  (
    `role_id` int(16) NOT NULL AUTO_INCREMENT,
    `role_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
    `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `state` tinyint(1) UNSIGNED ZEROFILL DEFAULT 0,
    `create_time` datetime(0) DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    `is_admin` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
    PRIMARY KEY (`role_id`) USING BTREE,
    INDEX `role_name`(`role_name`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_role
  -- ----------------------------
  INSERT INTO `sys_role` VALUES (1, '超级管理员', '管理员', 0, '2018-07-15 20:49:39', '2018-05-10 22:10:24', 0);
  INSERT INTO `sys_role` VALUES (2, '会员', 'VIP会员', 0, '2018-07-11 21:14:12', '2018-05-10 22:10:27', 1);
  INSERT INTO `sys_role` VALUES (3, '测试', 'test', 0, '2018-07-11 21:14:19', '2018-05-10 22:10:31', 1);
  
  -- ----------------------------
  -- Table structure for sys_role_permission
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role_permission`;
  CREATE TABLE `sys_role_permission`  (
    `role_id` int(16) NOT NULL,
    `permission_id` int(16) NOT NULL,
    INDEX `FKomxrs8a388bknvhjokh440waq`(`permission_id`) USING BTREE,
    INDEX `FK9q28ewrhntqeipl1t04kh1be7`(`role_id`) USING BTREE,
    CONSTRAINT `FK9q28ewrhntqeipl1t04kh1be7` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT `FKomxrs8a388bknvhjokh440waq` FOREIGN KEY (`permission_id`) REFERENCES `sys_permission` (`permission_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT `sys_role_permission.permission_id` FOREIGN KEY (`permission_id`) REFERENCES `sys_permission` (`permission_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `sys_role_permission.role_id` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_role_permission
  -- ----------------------------
  INSERT INTO `sys_role_permission` VALUES (3, 7);
  INSERT INTO `sys_role_permission` VALUES (3, 8);
  INSERT INTO `sys_role_permission` VALUES (2, 1);
  INSERT INTO `sys_role_permission` VALUES (2, 2);
  INSERT INTO `sys_role_permission` VALUES (2, 3);
  INSERT INTO `sys_role_permission` VALUES (2, 7);
  INSERT INTO `sys_role_permission` VALUES (2, 8);
  
  -- ----------------------------
  -- Table structure for sys_user
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user`;
  CREATE TABLE `sys_user`  (
    `user_id` int(16) NOT NULL AUTO_INCREMENT COMMENT '用户主键ID',
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '用户登录名',
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录密码',
    `real_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '真实名称',
    `salt` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
    `state` tinyint(1) UNSIGNED ZEROFILL NOT NULL DEFAULT 0,
    `create_time` datetime(0) NOT NULL ON UPDATE CURRENT_TIMESTAMP(0),
    `modify_time` datetime(0) DEFAULT NULL,
    PRIMARY KEY (`user_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_user
  -- ----------------------------
  INSERT INTO `sys_user` VALUES (14, 'admin14', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-14 23:00:49');
  INSERT INTO `sys_user` VALUES (15, 'admin15', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 1, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (16, 'admin16', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (17, 'admin17', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (18, 'admin18', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (19, 'admin19', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (20, 'admin20', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (21, 'admin21', 'd3c59d25033dbf980d29554025c23a75', '海森堡格', '8d78869f470951332959580424d4bf4f', 0, '2018-05-10 22:07:50', '2018-05-09 21:44:49');
  INSERT INTO `sys_user` VALUES (24, 'zx', 'zx', 'zx', NULL, 0, '2018-05-13 15:13:57', '2018-06-21 21:56:06');
  INSERT INTO `sys_user` VALUES (25, 'admin', 'c84268b9c1bdbad9df0996a533504f3c', '海森堡格', 'c3f2657847c4dc2a47a07fae5023e472', 0, '2018-07-09 22:54:00', '2018-07-09 22:54:00');
  
  -- ----------------------------
  -- Table structure for sys_user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_user_role`;
  CREATE TABLE `sys_user_role`  (
    `user_id` int(16) NOT NULL,
    `role_id` int(16) NOT NULL,
    INDEX `FKhh52n8vd4ny9ff4x9fb8v65qx`(`role_id`) USING BTREE,
    INDEX `FKb40xxfch70f5qnyfw8yme1n1s`(`user_id`) USING BTREE,
    CONSTRAINT `FKb40xxfch70f5qnyfw8yme1n1s` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT `FKhh52n8vd4ny9ff4x9fb8v65qx` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
    CONSTRAINT `sys_user_role.role_id` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE CASCADE ON UPDATE CASCADE,
    CONSTRAINT `sys_user_role.user_id` FOREIGN KEY (`user_id`) REFERENCES `sys_user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_user_role
  -- ----------------------------
  INSERT INTO `sys_user_role` VALUES (24, 3);
  INSERT INTO `sys_user_role` VALUES (25, 1);
  
  SET FOREIGN_KEY_CHECKS = 1;
  