博客信息
spring quartz 分布式集群设置之数据库脚本
发布时间：『 2016-08-09 11:39』 博客类别：Java 阅读(1753) 评论(0)
创建数据库脚本
DROP TABLE IF EXISTS qrtz_job_listeners;
DROP TABLE IF EXISTS qrtz_simple_triggers;
DROP TABLE IF EXISTS qrtz_cron_triggers;
DROP TABLE IF EXISTS qrtz_blob_triggers;
DROP TABLE IF EXISTS qrtz_trigger_listeners;
DROP TABLE IF EXISTS qrtz_calendars;
DROP TABLE IF EXISTS qrtz_paused_trigger_grps;
DROP TABLE IF EXISTS qrtz_fired_triggers;
DROP TABLE IF EXISTS qrtz_scheduler_state;
DROP TABLE IF EXISTS qrtz_locks;
DROP TABLE IF EXISTS qrtz_triggers;
DROP TABLE IF EXISTS qrtz_job_details;
DROP TABLE IF EXISTS qrtz_job_running_info;
CREATE TABLE `qrtz_job_details` (
`JOB_NAME` varchar(80) NOT NULL COMMENT 'job名字',
`JOB_GROUP` varchar(80) NOT NULL COMMENT 'job组',
`DESCRIPTION` varchar(120) DEFAULT NULL COMMENT '描述',
`JOB_CLASS_NAME` varchar(128) NOT NULL COMMENT 'job类名',
`IS_DURABLE` varchar(1) NOT NULL COMMENT '是否持久化',
`IS_VOLATILE` varchar(1) NOT NULL COMMENT '是否可变',
`IS_STATEFUL` varchar(1) NOT NULL COMMENT '是否有状态',
`REQUESTS_RECOVERY` varchar(1) NOT NULL COMMENT '请求恢复',
`JOB_DATA` blob COMMENT 'job数据',
PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`),
KEY `idx_qrtz_j_req_recovery` (`REQUESTS_RECOVERY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='job明细表';
CREATE TABLE `qrtz_triggers` (
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'tigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`JOB_NAME` varchar(80) NOT NULL COMMENT 'job名称',
`JOB_GROUP` varchar(80) NOT NULL COMMENT 'job组',
`IS_VOLATILE` varchar(1) NOT NULL COMMENT '是否可变',
`DESCRIPTION` varchar(120) DEFAULT NULL COMMENT '描述',
`NEXT_FIRE_TIME` decimal(13,0) DEFAULT NULL COMMENT '下次触发时间',
`PREV_FIRE_TIME` decimal(13,0) DEFAULT NULL COMMENT '前次触发时间',
`PRIORITY` decimal(13,0) DEFAULT NULL COMMENT '优先级',
`TRIGGER_STATE` varchar(16) NOT NULL COMMENT 'trigger状态',
`TRIGGER_TYPE` varchar(8) NOT NULL COMMENT 'trigger类型',
`START_TIME` decimal(13,0) NOT NULL COMMENT '开始时间',
`END_TIME` decimal(13,0) DEFAULT NULL COMMENT '结束时间',
`CALENDAR_NAME` varchar(80) DEFAULT NULL COMMENT '日历名',
`MISFIRE_INSTR` decimal(2,0) DEFAULT NULL COMMENT '没有触发次数',
`JOB_DATA` blob COMMENT 'job数据',
PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `idx_qrtz_t_next_fire_time` (`NEXT_FIRE_TIME`),
KEY `idx_qrtz_t_state` (`TRIGGER_STATE`),
KEY `idx_qrtz_t_nft_st` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
KEY `idx_qrtz_t_volatile` (`IS_VOLATILE`),
KEY `FK_qrtz_TR` (`JOB_NAME`,`JOB_GROUP`),
CONSTRAINT `FK_qrtz_TR` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='trigger表';
CREATE TABLE `qrtz_job_listeners` (
`JOB_NAME` varchar(80) NOT NULL COMMENT 'job名称',
`JOB_GROUP` varchar(80) NOT NULL COMMENT 'job组',
`JOB_LISTENER` varchar(80) NOT NULL COMMENT 'job监听器',
PRIMARY KEY (`JOB_NAME`,`JOB_GROUP`,`JOB_LISTENER`),
CONSTRAINT `FK_qrtz_JL` FOREIGN KEY (`JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='job监听器表';
CREATE TABLE `qrtz_simple_triggers` (
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'tigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`REPEAT_COUNT` decimal(7,0) NOT NULL COMMENT '重复计数',
`REPEAT_INTERVAL` decimal(12,0) NOT NULL COMMENT '重复间隔',
`TIMES_TRIGGERED` decimal(7,0) NOT NULL COMMENT '触发次数',
PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `FK_qrtz_ST` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='simple trigger表';
CREATE TABLE `qrtz_cron_triggers` (
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'trigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`CRON_EXPRESSION` varchar(80) NOT NULL COMMENT '克龙表达式',
`TIME_ZONE_ID` varchar(80) DEFAULT NULL COMMENT '时区ID',
PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `FK_QRTZ_CT` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='cron trigger表';
CREATE TABLE `qrtz_blob_triggers` (
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'trigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`BLOB_DATA` blob COMMENT 'blob数据',
PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`),
CONSTRAINT `FK_QRTZ_BT` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='blob trigger表';
CREATE TABLE `qrtz_trigger_listeners` (
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'tigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`TRIGGER_LISTENER` varchar(80) NOT NULL COMMENT '监听器',
PRIMARY KEY (`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_LISTENER`),
CONSTRAINT `FK_qrtz_TL` FOREIGN KEY (`TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE `qrtz_calendars` (
`CALENDAR_NAME` varchar(80) NOT NULL COMMENT '日历名称',
`CALENDAR` blob NOT NULL COMMENT '日历blob',
PRIMARY KEY (`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日历表';
CREATE TABLE `qrtz_paused_trigger_grps` (
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
PRIMARY KEY (`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='暂停tigger组表';
CREATE TABLE `qrtz_fired_triggers` (
`ENTRY_ID` varchar(95) NOT NULL COMMENT '条目ID',
`TRIGGER_NAME` varchar(80) NOT NULL COMMENT 'trigger名称',
`TRIGGER_GROUP` varchar(80) NOT NULL COMMENT 'trigger组',
`IS_VOLATILE` varchar(1) NOT NULL COMMENT '是否可变',
`INSTANCE_NAME` varchar(80) NOT NULL COMMENT '实例名',
`FIRED_TIME` decimal(13,0) NOT NULL COMMENT '触发时间',
`PRIORITY` decimal(13,0) NOT NULL COMMENT '优先级',
`STATE` varchar(16) NOT NULL COMMENT '状态',
`JOB_NAME` varchar(80) DEFAULT NULL COMMENT 'job名称',
`JOB_GROUP` varchar(80) DEFAULT NULL COMMENT 'job组',
`IS_STATEFUL` varchar(1) DEFAULT NULL COMMENT '是否有状态',
`REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
PRIMARY KEY (`ENTRY_ID`),
KEY `idx_qrtz_ft_trig_name` (`TRIGGER_NAME`),
KEY `idx_qrtz_ft_trig_group` (`TRIGGER_GROUP`),
KEY `idx_qrtz_ft_trig_nm_gp` (`TRIGGER_NAME`,`TRIGGER_GROUP`),
KEY `idx_qrtz_ft_trig_volatile` (`IS_VOLATILE`),
KEY `idx_qrtz_ft_trig_inst_name` (`INSTANCE_NAME`),
KEY `idx_qrtz_ft_job_name` (`JOB_NAME`),
KEY `idx_qrtz_ft_job_group` (`JOB_GROUP`),
KEY `idx_qrtz_ft_job_stateful` (`IS_STATEFUL`),
KEY `idx_qrtz_ft_job_req_recovery` (`REQUESTS_RECOVERY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='触发了的trigger表';
CREATE TABLE `qrtz_scheduler_state` (
`INSTANCE_NAME` varchar(80) NOT NULL COMMENT '实例名',
`LAST_CHECKIN_TIME` decimal(13,0) NOT NULL COMMENT '上次checkin时间',
`CHECKIN_INTERVAL` decimal(13,0) NOT NULL COMMENT 'checkin时间间隔',
`GROUP_NAME` varchar(80) NOT NULL COMMENT '组名',
PRIMARY KEY (`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='scheduler状态表';
CREATE TABLE `qrtz_locks` (
`LOCK_NAME` varchar(40) NOT NULL COMMENT '锁名',
PRIMARY KEY (`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='quartz锁定义表';
CREATE TABLE `qrtz_job_running_info` (
`running_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键任务执行ID',
`job_name` varchar(80) NOT NULL COMMENT '任务名称',
`job_group` varchar(80) NOT NULL COMMENT '任务分组',
`start_run_time` datetime NOT NULL COMMENT '执行开始时间',
`end_run_time` datetime NOT NULL COMMENT '执行结束时间',
`cost_time` int(11) NOT NULL COMMENT '执行花费时间 ms',
`status` tinyint(2) NOT NULL COMMENT '执行状态 0 失败 1 成功 2 异常',
`error_message` varchar(4000) DEFAULT NULL COMMENT '错误信息',
PRIMARY KEY (`running_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COMMENT='任务执行情况表';
INSERT INTO qrtz_locks values('TRIGGER_ACCESS');
INSERT INTO qrtz_locks values('JOB_ACCESS');
INSERT INTO qrtz_locks values('CALENDAR_ACCESS');
INSERT INTO qrtz_locks values('STATE_ACCESS');
INSERT INTO qrtz_locks values('MISFIRE_ACCESS');
commit;
关键字：
quartz
评论信息
暂无评论
发表评论
验证码： 
博主信息
仧尐
用专业的技术，做有益的事情
按日志类别
按日志日期
友情链接
Powered by IMZHANGJIE.CN Copyright © 2015-2025 粤ICP备14056181号