text: 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) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `blob_data` blob,
    PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
    CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_calendars`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_calendars`;
  CREATE TABLE `qrtz_calendars` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `calendar_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `calendar` blob NOT NULL,
    PRIMARY KEY (`sched_name`,`calendar_name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_cron_triggers`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_cron_triggers`;
  CREATE TABLE `qrtz_cron_triggers` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `cron_expression` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `time_zone_id` varchar(80) COLLATE utf8mb4_bin DEFAULT NULL,
    PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
    CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_fired_triggers`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_fired_triggers`;
  CREATE TABLE `qrtz_fired_triggers` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `entry_id` varchar(95) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `instance_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `fired_time` bigint(13) NOT NULL,
    `sched_time` bigint(13) NOT NULL,
    `priority` int(11) NOT NULL,
    `state` varchar(16) COLLATE utf8mb4_bin NOT NULL,
    `job_name` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
    `job_group` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
    `is_nonconcurrent` varchar(1) COLLATE utf8mb4_bin DEFAULT NULL,
    `requests_recovery` varchar(1) COLLATE utf8mb4_bin DEFAULT NULL,
    PRIMARY KEY (`sched_name`,`entry_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_job_details`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_job_details`;
  CREATE TABLE `qrtz_job_details` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `job_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `job_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `description` varchar(250) COLLATE utf8mb4_bin DEFAULT NULL,
    `job_class_name` varchar(250) COLLATE utf8mb4_bin NOT NULL,
    `is_durable` varchar(1) COLLATE utf8mb4_bin NOT NULL,
    `is_nonconcurrent` varchar(1) COLLATE utf8mb4_bin NOT NULL,
    `is_update_data` varchar(1) COLLATE utf8mb4_bin NOT NULL,
    `requests_recovery` varchar(1) COLLATE utf8mb4_bin NOT NULL,
    `job_data` blob,
    PRIMARY KEY (`sched_name`,`job_name`,`job_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_locks`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_locks`;
  CREATE TABLE `qrtz_locks` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `lock_name` varchar(40) COLLATE utf8mb4_bin NOT NULL,
    PRIMARY KEY (`sched_name`,`lock_name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  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) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    PRIMARY KEY (`sched_name`,`trigger_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_scheduler_state`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_scheduler_state`;
  CREATE TABLE `qrtz_scheduler_state` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `instance_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `last_checkin_time` bigint(13) NOT NULL,
    `checkin_interval` bigint(13) NOT NULL,
    PRIMARY KEY (`sched_name`,`instance_name`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_simple_triggers`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_simple_triggers`;
  CREATE TABLE `qrtz_simple_triggers` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin 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`),
    CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_simprop_triggers`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
  CREATE TABLE `qrtz_simprop_triggers` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `str_prop_1` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
    `str_prop_2` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL,
    `str_prop_3` varchar(512) COLLATE utf8mb4_bin 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) COLLATE utf8mb4_bin DEFAULT NULL,
    `bool_prop_2` varchar(1) COLLATE utf8mb4_bin DEFAULT NULL,
    PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
    CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  -- ----------------------------
  --  Table structure for `qrtz_triggers`
  -- ----------------------------
  DROP TABLE IF EXISTS `qrtz_triggers`;
  CREATE TABLE `qrtz_triggers` (
    `sched_name` varchar(120) COLLATE utf8mb4_bin NOT NULL,
    `trigger_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `trigger_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `job_name` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `job_group` varchar(200) COLLATE utf8mb4_bin NOT NULL,
    `description` varchar(250) COLLATE utf8mb4_bin 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) COLLATE utf8mb4_bin NOT NULL,
    `trigger_type` varchar(8) COLLATE utf8mb4_bin NOT NULL,
    `start_time` bigint(13) NOT NULL,
    `end_time` bigint(13) DEFAULT NULL,
    `calendar_name` varchar(200) COLLATE utf8mb4_bin DEFAULT NULL,
    `misfire_instr` smallint(2) DEFAULT NULL,
    `job_data` blob,
    PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`),
    KEY `sched_name` (`sched_name`,`job_name`,`job_group`),
    CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `qrtz_job_details` (`sched_name`, `job_name`, `job_group`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
  
  SET FOREIGN_KEY_CHECKS = 1;
  