text: /*
   Navicat Premium Data Transfer
  
   Source Server         : 49.234.85.17
   Source Server Type    : MySQL
   Source Server Version : 80022
   Source Host           : 49.234.85.17:3306
   Source Schema         : data-integration-system
  
   Target Server Type    : MySQL
   Target Server Version : 80022
   File Encoding         : 65001
  
   Date: 23/02/2021 10:38:46
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for data_collection_data_source
  -- ----------------------------
  DROP TABLE IF EXISTS `data_collection_data_source`;
  CREATE TABLE `data_collection_data_source`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据源名称',
    `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据源说明（描述）',
    `type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据源类型',
    `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据源状态',
    `driver_class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库驱动名',
    `linked_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库连接URL',
    `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库用户名',
    `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据库密码',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '数据源创建时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of data_collection_data_source
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for data_collection_schedule_job
  -- ----------------------------
  DROP TABLE IF EXISTS `data_collection_schedule_job`;
  CREATE TABLE `data_collection_schedule_job`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键，任务id',
    `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时任务名称',
    `data_collection_task_id` bigint(0) NULL DEFAULT NULL COMMENT '数据采集任务id',
    `cron_expression` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'cron表达式',
    `type` int(0) NULL DEFAULT NULL COMMENT '定时任务类型',
    `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时任务状态',
    `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述信息',
    `create_time` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_collection_schedule_job
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for data_collection_task
  -- ----------------------------
  DROP TABLE IF EXISTS `data_collection_task`;
  CREATE TABLE `data_collection_task`  (
    `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `task_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '采集任务名称',
    `task_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '采集任务描述',
    `import_data_source_id` bigint(0) NULL DEFAULT NULL COMMENT '输入数据源id',
    `selected_tables_fields` json NULL COMMENT '已选择的输入数据源的库表字段信息',
    `export_data_source_id` bigint(0) NULL DEFAULT NULL COMMENT '输出数据源id',
    `is_need_mapper` int(0) NULL DEFAULT NULL COMMENT '是否需要配置字段映射，0:否；1:是',
    `map_tables_fields` json NULL COMMENT '已选择的库表字段及映射',
    `status` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '采集任务创建时间',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of data_collection_task
  -- ----------------------------
  
  -- ----------------------------
  -- 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 NULL,
    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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_blob_triggers
  -- ----------------------------
  
  -- ----------------------------
  -- 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_calendars
  -- ----------------------------
  
  -- ----------------------------
  -- 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 NULL 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_cron_triggers
  -- ----------------------------
  INSERT INTO `qrtz_cron_triggers` VALUES ('DataIntegrationScheduler', 'DB_JOB_46', 'DEFAULT', '0 */10 * * * ?', 'Asia/Shanghai');
  
  -- ----------------------------
  -- 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(0) NOT NULL,
    `SCHED_TIME` bigint(0) NOT NULL,
    `PRIORITY` int(0) 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 NULL DEFAULT NULL,
    `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_fired_triggers
  -- ----------------------------
  
  -- ----------------------------
  -- 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 NULL 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 NULL,
    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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_job_details
  -- ----------------------------
  INSERT INTO `qrtz_job_details` VALUES ('DataIntegrationScheduler', 'DB_JOB_46', 'DEFAULT', NULL, 'com.softline.quartz.job.DataCollectionJob', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000944425F4A4F425F343673720030636F6D2E736F66746C696E652E6D62672E6D6F64656C2E44617461436F6C6C656374696F6E5363686564756C654A6F6200000000000000010200084C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C000E63726F6E45787072657373696F6E7400124C6A6176612F6C616E672F537472696E673B4C001464617461436F6C6C656374696F6E5461736B49647400104C6A6176612F6C616E672F4C6F6E673B4C000B6465736372697074696F6E71007E000A4C0002696471007E000B4C00046E616D6571007E000A4C000673746174757371007E000A4C0004747970657400134C6A6176612F6C616E672F496E74656765723B78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000177760092027874000E30202A2F3130202A202A202A203F7372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000000174000B6D7973716C2D6D7973716C7371007E0011000000000000002E74000B6D7973716C2D6D7973716C74000743524541544544707800);
  
  -- ----------------------------
  -- 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_locks
  -- ----------------------------
  INSERT INTO `qrtz_locks` VALUES ('DataIntegrationScheduler', 'STATE_ACCESS');
  INSERT INTO `qrtz_locks` VALUES ('DataIntegrationScheduler', 'TRIGGER_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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_paused_trigger_grps
  -- ----------------------------
  
  -- ----------------------------
  -- 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(0) NOT NULL,
    `CHECKIN_INTERVAL` bigint(0) NOT NULL,
    PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_scheduler_state
  -- ----------------------------
  INSERT INTO `qrtz_scheduler_state` VALUES ('DataIntegrationScheduler', 'LAPTOP-I0101J891613803176889', 1613803224485, 15000);
  
  -- ----------------------------
  -- 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(0) NOT NULL,
    `REPEAT_INTERVAL` bigint(0) NOT NULL,
    `TIMES_TRIGGERED` bigint(0) 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_simple_triggers
  -- ----------------------------
  
  -- ----------------------------
  -- 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 NULL DEFAULT NULL,
    `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `INT_PROP_1` int(0) NULL DEFAULT NULL,
    `INT_PROP_2` int(0) NULL DEFAULT NULL,
    `LONG_PROP_1` bigint(0) NULL DEFAULT NULL,
    `LONG_PROP_2` bigint(0) NULL DEFAULT NULL,
    `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
    `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
    `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL 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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_simprop_triggers
  -- ----------------------------
  
  -- ----------------------------
  -- 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 NULL DEFAULT NULL,
    `NEXT_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
    `PREV_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
    `PRIORITY` int(0) NULL 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(0) NOT NULL,
    `END_TIME` bigint(0) NULL DEFAULT NULL,
    `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `MISFIRE_INSTR` smallint(0) NULL DEFAULT NULL,
    `JOB_DATA` blob NULL,
    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 = Dynamic;
  
  -- ----------------------------
  -- Records of qrtz_triggers
  -- ----------------------------
  INSERT INTO `qrtz_triggers` VALUES ('DataIntegrationScheduler', 'DB_JOB_46', 'DEFAULT', 'DB_JOB_46', 'DEFAULT', NULL, 1614048000000, 1614047400000, 5, 'WAITING', 'CRON', 1612592484000, 0, NULL, 2, '');
  
  -- ----------------------------
  -- Table structure for sys_admin_login_log
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_admin_login_log`;
  CREATE TABLE `sys_admin_login_log`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `admin_id` bigint(0) NULL DEFAULT NULL COMMENT 'admin用户id',
    `admin_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'admin用户名',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `ip` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问ip',
    `address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问地址',
    `user_agent` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '浏览器登录类型',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户登录日志表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_admin_login_log
  -- ----------------------------
  INSERT INTO `sys_admin_login_log` VALUES (76, 1, 'admin', '2021-02-23 10:37:48', '192.168.4.89', '本地局域网', 'chrome');
  
  -- ----------------------------
  -- Table structure for sys_admin_role_relation
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_admin_role_relation`;
  CREATE TABLE `sys_admin_role_relation`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `admin_id` bigint(0) NULL DEFAULT NULL COMMENT 'admin用户id',
    `role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色id',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户和角色关系表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_admin_role_relation
  -- ----------------------------
  INSERT INTO `sys_admin_role_relation` VALUES (1, 1, 1);
  
  -- ----------------------------
  -- Table structure for sys_admin_user
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_admin_user`;
  CREATE TABLE `sys_admin_user`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `username` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
    `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
    `email` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
    `nick_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
    `note` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注信息',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
    `status` int(0) NULL DEFAULT 1 COMMENT '帐号启用状态：0->禁用；1->启用',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_admin_user
  -- ----------------------------
  INSERT INTO `sys_admin_user` VALUES (1, 'admin', '$2a$10$JLwPU1I9s7FxBb/8A0fADeJCaP8m0SPjZR4MmFINLBYvQiCDWLd6a', 'admin@163.com', '系统管理员', '系统管理员', '2020-11-25 13:32:47', '2020-11-25 13:35:16', 1);
  
  -- ----------------------------
  -- Table structure for sys_menu
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_menu`;
  CREATE TABLE `sys_menu`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `parent_id` bigint(0) NULL DEFAULT NULL COMMENT '父级ID',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
    `level` int(0) NULL DEFAULT NULL COMMENT '菜单级数',
    `sort` int(0) NULL DEFAULT NULL COMMENT '菜单排序',
    `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前端名称',
    `icon` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '前端图标',
    `hidden` int(0) NULL DEFAULT NULL COMMENT '前端隐藏',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台菜单表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_menu
  -- ----------------------------
  INSERT INTO `sys_menu` VALUES (1, 0, '2020-02-07 16:29:13', '系统管理', 0, 0, 'sys', 'sys', 0);
  INSERT INTO `sys_menu` VALUES (2, 1, '2020-02-07 16:29:51', '用户管理', 1, 0, 'admin', 'sys-admin', 0);
  INSERT INTO `sys_menu` VALUES (3, 1, '2020-02-07 16:30:13', '角色管理', 1, 0, 'role', 'sys-role', 0);
  INSERT INTO `sys_menu` VALUES (4, 1, '2020-02-07 16:30:53', '菜单管理', 1, 0, 'menu', 'sys-menu', 0);
  INSERT INTO `sys_menu` VALUES (5, 1, '2020-11-25 20:07:34', '登录日志', 1, 0, 'adminLog', 'sys-admin-log', 0);
  INSERT INTO `sys_menu` VALUES (6, 0, '2020-12-02 15:45:32', '数据采集管理', 0, 1, 'dataCollection', 'data-collection', 0);
  INSERT INTO `sys_menu` VALUES (7, 6, '2020-12-02 15:46:10', '数据源管理', 1, 0, 'dataSource', 'data-source', 0);
  INSERT INTO `sys_menu` VALUES (8, 6, '2020-12-02 15:50:20', '采集任务管理', 1, 0, 'collectionTask', 'collection-task', 0);
  INSERT INTO `sys_menu` VALUES (9, 6, '2020-12-02 15:51:54', '定时任务管理', 1, 0, 'scheduleJob', 'schedule-job', 0);
  
  -- ----------------------------
  -- Table structure for sys_role
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role`;
  CREATE TABLE `sys_role`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
    `admin_count` int(0) NULL DEFAULT NULL COMMENT '后台用户数量',
    `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
    `status` int(0) NULL DEFAULT 1 COMMENT '启用状态：0->禁用；1->启用',
    `sort` int(0) NULL DEFAULT 0 COMMENT '排序',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台用户角色表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_role
  -- ----------------------------
  INSERT INTO `sys_role` VALUES (1, '超级管理员', '拥有所有查看和操作功能', 0, '2020-02-02 15:11:05', 1, 0);
  
  -- ----------------------------
  -- Table structure for sys_role_menu_relation
  -- ----------------------------
  DROP TABLE IF EXISTS `sys_role_menu_relation`;
  CREATE TABLE `sys_role_menu_relation`  (
    `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '主键id',
    `role_id` bigint(0) NULL DEFAULT NULL COMMENT '角色id',
    `menu_id` bigint(0) NULL DEFAULT NULL COMMENT '菜单id',
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '后台角色菜单关系表' ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of sys_role_menu_relation
  -- ----------------------------
  INSERT INTO `sys_role_menu_relation` VALUES (1, 1, 1);
  INSERT INTO `sys_role_menu_relation` VALUES (2, 1, 2);
  INSERT INTO `sys_role_menu_relation` VALUES (3, 1, 3);
  INSERT INTO `sys_role_menu_relation` VALUES (4, 1, 4);
  INSERT INTO `sys_role_menu_relation` VALUES (5, 1, 5);
  INSERT INTO `sys_role_menu_relation` VALUES (6, 1, 6);
  INSERT INTO `sys_role_menu_relation` VALUES (7, 1, 7);
  INSERT INTO `sys_role_menu_relation` VALUES (8, 1, 8);
  INSERT INTO `sys_role_menu_relation` VALUES (9, 1, 9);
  
  SET FOREIGN_KEY_CHECKS = 1;
  