DROP TABLE IF EXISTS qrtz_blob_triggers; DROP TABLE IF EXISTS qrtz_calendars; DROP TABLE IF EXISTS qrtz_cron_triggers; DROP TABLE IF EXISTS qrtz_fired_triggers; DROP TABLE IF EXISTS qrtz_locks; DROP TABLE IF EXISTS qrtz_paused_trigger_grps; DROP TABLE IF EXISTS qrtz_scheduler_state; DROP TABLE IF EXISTS qrtz_simple_triggers; DROP TABLE IF EXISTS qrtz_simprop_triggers; DROP TABLE IF EXISTS qrtz_task_triggers; DROP TABLE IF EXISTS qrtz_triggers; DROP TABLE IF EXISTS qrtz_job_details; -- -- Table structure for table `qrtz_job_details` -- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `JOB_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `JOB_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `DESCRIPTION` varchar(250) COLLATE utf8_bin DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) COLLATE utf8_bin NOT NULL, `IS_DURABLE` varchar(1) COLLATE utf8_bin NOT NULL, `IS_NONCONCURRENT` varchar(1) COLLATE utf8_bin NOT NULL, `IS_UPDATE_DATA` varchar(1) COLLATE utf8_bin NOT NULL, `REQUESTS_RECOVERY` varchar(1) COLLATE utf8_bin NOT NULL, `JOB_DATA` longblob, PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_triggers` -- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `JOB_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `JOB_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `DESCRIPTION` varchar(250) COLLATE utf8_bin DEFAULT NULL, `NEXT_FIRE_TIME` decimal(13,0) DEFAULT NULL, `PREV_FIRE_TIME` decimal(13,0) DEFAULT NULL, `PRIORITY` decimal(13,0) DEFAULT NULL, `TRIGGER_STATE` varchar(16) COLLATE utf8_bin NOT NULL, `TRIGGER_TYPE` varchar(8) COLLATE utf8_bin NOT NULL, `START_TIME` decimal(13,0) NOT NULL, `END_TIME` decimal(13,0) DEFAULT NULL, `CALENDAR_NAME` varchar(200) COLLATE utf8_bin DEFAULT NULL, `MISFIRE_INSTR` decimal(2,0) DEFAULT NULL, `JOB_DATA` longblob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_J` (`JOB_NAME`,`JOB_GROUP`,`SCHED_NAME`), KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`NEXT_FIRE_TIME`,`SCHED_NAME`), KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_ST` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`,`SCHED_NAME`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`,`SCHED_NAME`,`MISFIRE_INSTR`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`TRIGGER_GROUP`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`,`MISFIRE_INSTR`,`SCHED_NAME`), KEY `IDX_QRTZ_T_N_G_STATE` (`TRIGGER_GROUP`,`TRIGGER_STATE`,`SCHED_NAME`), KEY `IDX_QRTZ_T_N_STATE` (`TRIGGER_STATE`,`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_STATE` (`TRIGGER_STATE`,`SCHED_NAME`), KEY `QRTZ_TRIGGER_TO_JOBS_FK` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), CONSTRAINT `QRTZ_TRIGGER_TO_JOBS_FK` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_blob_triggers` -- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `BLOB_DATA` longblob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `QRTZ_BLOB_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_calendars` -- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `CALENDAR_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `CALENDAR` longblob NOT NULL, PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_cron_triggers` -- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `CRON_EXPRESSION` varchar(120) COLLATE utf8_bin NOT NULL, `TIME_ZONE_ID` varchar(80) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `QRTZ_CRON_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_fired_triggers` -- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `ENTRY_ID` varchar(95) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `INSTANCE_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `FIRED_TIME` decimal(13,0) NOT NULL, `SCHED_TIME` decimal(13,0) NOT NULL, `PRIORITY` decimal(13,0) NOT NULL, `STATE` varchar(16) COLLATE utf8_bin NOT NULL, `JOB_NAME` varchar(200) COLLATE utf8_bin DEFAULT NULL, `JOB_GROUP` varchar(200) COLLATE utf8_bin DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) COLLATE utf8_bin DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), KEY `IDX_QRTZ_FT_JG` (`JOB_GROUP`,`SCHED_NAME`), KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_locks` -- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `LOCK_NAME` varchar(40) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_paused_trigger_grps` -- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_scheduler_state` -- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `INSTANCE_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `LAST_CHECKIN_TIME` decimal(13,0) NOT NULL, `CHECKIN_INTERVAL` decimal(13,0) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_simple_triggers` -- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `REPEAT_COUNT` decimal(7,0) NOT NULL, `REPEAT_INTERVAL` decimal(12,0) NOT NULL, `TIMES_TRIGGERED` decimal(10,0) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `QRTZ_SIMPLE_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- -- Table structure for table `qrtz_simprop_triggers` -- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL, `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL, `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL, `STR_PROP_1` text COLLATE utf8_bin, `STR_PROP_2` text COLLATE utf8_bin, `STR_PROP_3` text COLLATE utf8_bin, `INT_PROP_1` decimal(10,0) DEFAULT NULL, `INT_PROP_2` decimal(10,0) DEFAULT NULL, `LONG_PROP_1` decimal(13,0) DEFAULT NULL, `LONG_PROP_2` decimal(13,0) DEFAULT NULL, `DEC_PROP_1` decimal(13,4) DEFAULT NULL, `DEC_PROP_2` decimal(13,4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) COLLATE utf8_bin DEFAULT NULL, `BOOL_PROP_2` varchar(1) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `QRTZ_SIMPROP_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
文章评论