sql.patch.1.1.0.sql Maven / Gradle / Ivy
The newest version!
ALTER TABLE `sys_menu`
AUTO_INCREMENT=1000;
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE IF NOT EXISTS `sys_notice` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID',
`title` varchar(200) DEFAULT NULL COMMENT '公告标题',
`type` varchar(50) DEFAULT NULL COMMENT '类别',
`content` longtext DEFAULT NULL COMMENT '公告内容',
`start_time` datetime DEFAULT NULL COMMENT '公告开始时间',
`end_time` datetime DEFAULT NULL COMMENT '公告结束时间',
`status` int(11) DEFAULT NULL COMMENT '状态(0正常，1停用)',
`is_del` tinyint(1) DEFAULT NULL COMMENT '是否删除(0正常，1已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
PRIMARY KEY (`id`),
INDEX `index_date`(`start_time`,`end_time`,`status`,`is_del`) USING BTREE COMMENT '按时间查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公告表';
DROP TABLE IF EXISTS `sys_user_notice`;
CREATE TABLE IF NOT EXISTS `sys_user_notice` (
`user_id` bigint(20) NOT NULL COMMENT '用户ID',
`notice_id` bigint(20) NOT NULL COMMENT '公告ID',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`user_id`, `notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户已读公告表';
DROP TABLE IF EXISTS `sys_job`;
CREATE TABLE IF NOT EXISTS `sys_job` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID',
`name` varchar(200) DEFAULT NULL COMMENT '任务名称',
`group` varchar(200) DEFAULT NULL COMMENT '任务组',
`remark` varchar(3000) DEFAULT NULL COMMENT '备注',
`exec_clazz` varchar(200) DEFAULT NULL COMMENT '执行类',
`exec_method` varchar(200) DEFAULT NULL COMMENT '执行方法',
`exec_param` varchar(3000) DEFAULT NULL COMMENT '执行参数JSON',
`concurrent` tinyint(1) DEFAULT NULL COMMENT '是否并发',
`error_mail` varchar(3000) DEFAULT NULL COMMENT '异常通知邮件',
`status` int(11) DEFAULT NULL COMMENT '状态(0正常，1停用)',
`is_del` tinyint(1) DEFAULT NULL COMMENT '是否删除(0正常，1已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务表';
DROP TABLE IF EXISTS `sys_job_trigger`;
CREATE TABLE IF NOT EXISTS `sys_job_trigger` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`job_id` bigint(20) NOT NULL COMMENT '任务ID',
`name` varchar(200) DEFAULT NULL COMMENT '触发器名称',
`group` varchar(200) DEFAULT NULL COMMENT '触发器组',
`exec_type` int(11) DEFAULT NULL COMMENT '执行方式，定时，循环',
`exec_expression` varchar(3000) DEFAULT NULL COMMENT '执行方式表达式',
`exec_start` datetime DEFAULT NULL COMMENT '开始执行时间',
`exec_end` datetime DEFAULT NULL COMMENT '结束执行时间',
`misfire_strategy` int(11) DEFAULT NULL COMMENT '未正常调度任务的执行策略',
`priority` int(11) DEFAULT NULL COMMENT '优先级',
`status` int(11) DEFAULT NULL COMMENT '状态(0正常，1停用，2暂停)',
`is_del` tinyint(1) DEFAULT NULL COMMENT '是否删除(0正常，1已删除)',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`create_user` bigint(20) DEFAULT NULL COMMENT '创建人',
`update_time` datetime DEFAULT NULL COMMENT '修改时间',
`update_user` bigint(20) DEFAULT NULL COMMENT '修改人',
PRIMARY KEY (`id`),
INDEX `index_job`(`job_id`) USING BTREE COMMENT '按任务查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务触发器表';
DROP TABLE IF EXISTS `sys_job_log`;
CREATE TABLE IF NOT EXISTS `sys_job_log` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`job_id` bigint(20) NOT NULL COMMENT '任务ID',
`trigger_id` varchar(200) NOT NULL COMMENT '触发器ID',
`start_time` datetime(3) DEFAULT NULL COMMENT '开始时间',
`end_time` datetime(3) DEFAULT NULL COMMENT '结束时间',
`cost_time` int(11) DEFAULT NULL COMMENT '耗时（毫秒）',
`exec_clazz` varchar(200) DEFAULT NULL COMMENT '执行类',
`exec_method` varchar(200) DEFAULT NULL COMMENT '执行方法',
`exec_param` varchar(3000) DEFAULT NULL COMMENT '执行参数JSON',
`host_ip` varchar(200) DEFAULT NULL COMMENT '主机IP',
`host_name` varchar(200) DEFAULT NULL COMMENT '主机名称',
`job_result` varchar(3000) DEFAULT NULL COMMENT '输出结果',
`state` int(11) DEFAULT NULL COMMENT '运行状态',
PRIMARY KEY (`id`),
INDEX `index_job_trigger`(`job_id`,`trigger_id`,`start_time`) USING BTREE COMMENT '按触发器查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务日志表';
DROP TABLE IF EXISTS `sys_job_log_detail`;
CREATE TABLE IF NOT EXISTS `sys_job_log_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`job_log_id` bigint(20) NOT NULL COMMENT '任务日志ID',
`level` int(11) DEFAULT NULL COMMENT '级别',
`msg` text DEFAULT NULL COMMENT '信息',
`create_time` datetime(3) DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`),
INDEX `index_job`(`job_log_id`,`create_time`) USING BTREE COMMENT '按日志查询'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='定时任务日志详情表';
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('7', 'SysNoticeType', '公告类型', NULL, '0', '0', '2024-05-23 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('8', 'SysJobLogLevel', '定时任务日志级别', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('9', 'SysJobHistoryState', '定时任务执行结果', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('10', 'SysJobTriggerType', '定时任务触发器类型', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('11', 'SysJobState', '定时任务状态', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('12', 'SysJobCronMisfireStrategy', '定时任务CRON异常恢复策略', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('13', 'SysJobSimpleMisfireStrategy', '定时任务SIMPLE异常恢复策略', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict_type` (`id`, `code`, `name`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('14', 'SysJobTriggerPriority', '定时任务触发器级别', NULL, '0', '0', '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (14, 'notice', '通知', 'notification', '7', NULL, 0, 0, '2024-05-23 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (15, '1', 'DEBUG', 'DEBUG', '8', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (16, '2', 'INFO', 'INFO', '8', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (17, '3', 'WARN', 'WARN', '8', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (18, '4', 'ERROR', 'ERROR', '8', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (19, '0', '运行中', 'running', '9', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (20, '1', '成功', 'sucess', '9', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (21, '2', '失败', 'error', '9', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (22, '1', 'CRON', 'CRON', '10', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (23, '2', 'SIMPLE', 'SIMPLE', '10', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (24, '0', '已停止', 'stopped', '11', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (25, '1', '运行中', 'running', '11', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (26, '2', '已暂停', 'paused', '11', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (27, '0', '不处理', 'DONOTHING', '12', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (28, '1', '重新执行', 'IGNORE', '12', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (29, '2', '执行一次', 'ONCE', '12', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (30, '0', '立即执行', 'FIRE NOW', '13', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (31, '1', '重新执行', 'IGNORE', '13', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (32, '2', '下次执行', 'NEXT EXISTING', '13', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (33, '3', '剩下的下次', 'NEXT REMAIN', '13', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (34, '4', '现在执行', 'NOW EXIST', '13', NULL, 0, 0, '2024-05-28 09:32:03', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (35, '5', '剩下的现在', 'NOW REMAIN', '13', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (36, '2', '低', 'LOW', '14', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (37, '5', '中', 'MEDIUM', '14', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_dict` (`id`, `value`, `label_zh`, `label_en`, `type_id`, `remark`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES (38, '8', '高', 'HIGH', '14', NULL, 0, 0, '2024-05-28 14:11:57', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('43', 'system:notice', '公告管理', '1', '/notice', NULL, 'Notice/NoticeList', 1, 'Coin', 1, 1, 0, 0, 0, 1, 0, 0, '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('44', 'system:notice:list', '查询公告', '1', NULL, NULL, NULL, '43', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('45', 'system:notice:add', '新增公告', '1', NULL, NULL, NULL, '43', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('46', 'system:notice:edit', '修改公告', '1', NULL, NULL, NULL, '43', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('47', 'system:notice:del', '删除公告', '1', NULL, NULL, NULL, '43', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('48', 'system:job', '定时任务管理', '1', '/job', NULL, 'Job/JobList', 1, 'Coin', 1, 1, 0, 0, 0, 1, 0, 0, '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('49', 'system:job:list', '查询任务', '1', NULL, NULL, NULL, '48', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('50', 'system:job:add', '新增任务', '1', NULL, NULL, NULL, '48', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('51', 'system:job:edit', '修改任务', '1', NULL, NULL, NULL, '48', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('52', 'system:job:del', '删除任务', '1', NULL, NULL, NULL, '48', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `code`, `name`, `order`, `path`, `query`, `component`, `parent_id`, `icon`, `type`, `is_visible`, `is_frame`, `is_cache`, `is_fullscreen`, `is_tag`, `status`, `is_del`, `create_time`, `create_user`, `update_time`, `update_user`) VALUES ('53', 'system:job:trigger', '调度配置', '1', NULL, NULL, NULL, '48', NULL, '2', '1', '0', '0', '0', '1', '0', '0', '2024-03-06 13:49:40', NULL, NULL, NULL);
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
DROP TABLE IF EXISTS QRTZ_LOCKS;
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_TRIGGERS;
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
DROP TABLE IF EXISTS QRTZ_CALENDARS;
CREATE TABLE QRTZ_JOB_DETAILS(
SCHED_NAME VARCHAR(120) NOT NULL,
JOB_NAME VARCHAR(190) NOT NULL,
JOB_GROUP VARCHAR(190) NOT NULL,
DESCRIPTION VARCHAR(250) NULL,
JOB_CLASS_NAME VARCHAR(250) NOT NULL,
IS_DURABLE VARCHAR(1) NOT NULL,
IS_NONCONCURRENT VARCHAR(1) NOT NULL,
IS_UPDATE_DATA VARCHAR(1) NOT NULL,
REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_TRIGGERS (
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
JOB_NAME VARCHAR(190) NOT NULL,
JOB_GROUP VARCHAR(190) NOT NULL,
DESCRIPTION VARCHAR(250) NULL,
NEXT_FIRE_TIME BIGINT(13) NULL,
PREV_FIRE_TIME BIGINT(13) NULL,
PRIORITY INTEGER NULL,
TRIGGER_STATE VARCHAR(16) NOT NULL,
TRIGGER_TYPE VARCHAR(8) NOT NULL,
START_TIME BIGINT(13) NOT NULL,
END_TIME BIGINT(13) NULL,
CALENDAR_NAME VARCHAR(190) NULL,
MISFIRE_INSTR SMALLINT(2) NULL,
JOB_DATA BLOB NULL,
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_SIMPLE_TRIGGERS (
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) 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),
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_CRON_TRIGGERS (
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
CRON_EXPRESSION VARCHAR(120) NOT NULL,
TIME_ZONE_ID VARCHAR(80),
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_SIMPROP_TRIGGERS
(
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
STR_PROP_1 VARCHAR(512) NULL,
STR_PROP_2 VARCHAR(512) NULL,
STR_PROP_3 VARCHAR(512) NULL,
INT_PROP_1 INT NULL,
INT_PROP_2 INT NULL,
LONG_PROP_1 BIGINT NULL,
LONG_PROP_2 BIGINT NULL,
DEC_PROP_1 NUMERIC(13,4) NULL,
DEC_PROP_2 NUMERIC(13,4) NULL,
BOOL_PROP_1 VARCHAR(1) NULL,
BOOL_PROP_2 VARCHAR(1) NULL,
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_BLOB_TRIGGERS (
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
BLOB_DATA BLOB NULL,
PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_CALENDARS (
SCHED_NAME VARCHAR(120) NOT NULL,
CALENDAR_NAME VARCHAR(190) NOT NULL,
CALENDAR BLOB NOT NULL,
PRIMARY KEY (SCHED_NAME,CALENDAR_NAME))
ENGINE=InnoDB;
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP))
ENGINE=InnoDB;
CREATE TABLE QRTZ_FIRED_TRIGGERS (
SCHED_NAME VARCHAR(120) NOT NULL,
ENTRY_ID VARCHAR(95) NOT NULL,
TRIGGER_NAME VARCHAR(190) NOT NULL,
TRIGGER_GROUP VARCHAR(190) NOT NULL,
INSTANCE_NAME VARCHAR(190) NOT NULL,
FIRED_TIME BIGINT(13) NOT NULL,
SCHED_TIME BIGINT(13) NOT NULL,
PRIORITY INTEGER NOT NULL,
STATE VARCHAR(16) NOT NULL,
JOB_NAME VARCHAR(190) NULL,
JOB_GROUP VARCHAR(190) NULL,
IS_NONCONCURRENT VARCHAR(1) NULL,
REQUESTS_RECOVERY VARCHAR(1) NULL,
PRIMARY KEY (SCHED_NAME,ENTRY_ID))
ENGINE=InnoDB;
CREATE TABLE QRTZ_SCHEDULER_STATE (
SCHED_NAME VARCHAR(120) NOT NULL,
INSTANCE_NAME VARCHAR(190) NOT NULL,
LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
CHECKIN_INTERVAL BIGINT(13) NOT NULL,
PRIMARY KEY (SCHED_NAME,INSTANCE_NAME))
ENGINE=InnoDB;
CREATE TABLE QRTZ_LOCKS (
SCHED_NAME VARCHAR(120) NOT NULL,
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (SCHED_NAME,LOCK_NAME))
ENGINE=InnoDB;
CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(SCHED_NAME,REQUESTS_RECOVERY);
CREATE INDEX IDX_QRTZ_J_GRP ON QRTZ_JOB_DETAILS(SCHED_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_J ON QRTZ_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_JG ON QRTZ_TRIGGERS(SCHED_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_T_C ON QRTZ_TRIGGERS(SCHED_NAME,CALENDAR_NAME);
CREATE INDEX IDX_QRTZ_T_G ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);
CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_N_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_N_G_STATE ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(SCHED_NAME,NEXT_FIRE_TIME);
CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
CREATE INDEX IDX_QRTZ_T_NFT_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_T_NFT_ST_MISFIRE_GRP ON QRTZ_TRIGGERS(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME);
CREATE INDEX IDX_QRTZ_FT_INST_JOB_REQ_RCVRY ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
CREATE INDEX IDX_QRTZ_FT_J_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_FT_JG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,JOB_GROUP);
CREATE INDEX IDX_QRTZ_FT_T_G ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
CREATE INDEX IDX_QRTZ_FT_TG ON QRTZ_FIRED_TRIGGERS(SCHED_NAME,TRIGGER_GROUP);© 2015 - 2024 Weber Informatics LLC | Privacy Policy