11 张 quartz 表的新建顺序

已于 2022-06-29 13:55:40 修改
阅读量367 收藏 1
点赞数
分类专栏： MYSQL 数据库 quartz 文章标签： mysql sql 数据库 java quartz
于 2022-06-29 13:33:24 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/heshiyuan1406146854/article/details/125520072
版权
MYSQL 同时被 3 个专栏收录
12 篇文章 0 订阅
订阅专栏
数据库
5 篇文章 0 订阅
订阅专栏
quartz
2 篇文章 0 订阅
订阅专栏

 因为存在外键依赖，11张表必须按照如下顺序新建：

CREATE TABLE `xxxxxxxx_job_details` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `JOB_NAME` VARCHAR(200) NOT NULL,
  `JOB_GROUP` VARCHAR(200) NOT NULL,
  `DESCRIPTION` VARCHAR(250) DEFAULT 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,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_XXXXXXXX_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_XXXXXXXX_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  `JOB_NAME` VARCHAR(200) NOT NULL,
  `JOB_GROUP` VARCHAR(200) NOT NULL,
  `DESCRIPTION` VARCHAR(250) 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) NOT NULL,
  `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
  `START_TIME` BIGINT(13) NOT NULL,
  `END_TIME` BIGINT(13) DEFAULT NULL,
  `CALENDAR_NAME` VARCHAR(200) DEFAULT NULL,
  `MISFIRE_INSTR` SMALLINT(2) DEFAULT NULL,
  `JOB_DATA` BLOB,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_XXXXXXXX_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,
  KEY `IDX_XXXXXXXX_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,
  CONSTRAINT `xxxxxxxx_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `xxxxxxxx_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_blob_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  `BLOB_DATA` BLOB,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  CONSTRAINT `xxxxxxxx_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxxxxxxx_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_calendars` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `CALENDAR_NAME` VARCHAR(200) NOT NULL,
  `CALENDAR` BLOB NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_cron_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
  `TIME_ZONE_ID` VARCHAR(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `xxxxxxxx_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxxxxxxx_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_fired_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `ENTRY_ID` VARCHAR(95) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  `INSTANCE_NAME` VARCHAR(200) NOT NULL,
  `FIRED_TIME` BIGINT(13) NOT NULL,
  `SCHED_TIME` BIGINT(13) NOT NULL,
  `PRIORITY` INT(11) NOT NULL,
  `STATE` VARCHAR(16) NOT NULL,
  `JOB_NAME` VARCHAR(200) DEFAULT NULL,
  `JOB_GROUP` VARCHAR(200) DEFAULT NULL,
  `IS_NONCONCURRENT` VARCHAR(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` VARCHAR(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_XXXXXXXX_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE,
  KEY `IDX_XXXXXXXX_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`) USING BTREE,
  KEY `IDX_XXXXXXXX_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_FT_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,
  KEY `IDX_XXXXXXXX_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_locks` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `LOCK_NAME` VARCHAR(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_paused_trigger_grps` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_scheduler_state` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `INSTANCE_NAME` VARCHAR(200) 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=utf8;

CREATE TABLE `xxxxxxxx_simple_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) 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 `xxxxxxxx_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxxxxxxx_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `xxxxxxxx_simprop_triggers` (
  `SCHED_NAME` VARCHAR(120) NOT NULL,
  `TRIGGER_NAME` VARCHAR(200) NOT NULL,
  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
  `STR_PROP_1` VARCHAR(512) DEFAULT NULL,
  `STR_PROP_2` VARCHAR(512) DEFAULT NULL,
  `STR_PROP_3` VARCHAR(512) 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) DEFAULT NULL,
  `BOOL_PROP_2` VARCHAR(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `xxxxxxxx_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `xxxxxxxx_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

public class Quartz11TableCreateSqlPrinter {
    public static void main(String[] args) {
        String projectName = "my_test_project";
        String projectNameUppercase = projectName.toUpperCase();
        String sql = "因为存在外键依赖，11张表必须按照这个顺序新建：\n" +
                "CREATE TABLE `" + projectName + "_job_details` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `JOB_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `JOB_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `DESCRIPTION` VARCHAR(250) DEFAULT NULL,\n" +
                "  `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,\n" +
                "  `IS_DURABLE` VARCHAR(1) NOT NULL,\n" +
                "  `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,\n" +
                "  `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,\n" +
                "  `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,\n" +
                "  `JOB_DATA` BLOB,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),\n" +
                "  KEY `IDX_" + projectNameUppercase + "_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `JOB_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `JOB_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `DESCRIPTION` VARCHAR(250) DEFAULT NULL,\n" +
                "  `NEXT_FIRE_TIME` BIGINT(13) DEFAULT NULL,\n" +
                "  `PREV_FIRE_TIME` BIGINT(13) DEFAULT NULL,\n" +
                "  `PRIORITY` INT(11) DEFAULT NULL,\n" +
                "  `TRIGGER_STATE` VARCHAR(16) NOT NULL,\n" +
                "  `TRIGGER_TYPE` VARCHAR(8) NOT NULL,\n" +
                "  `START_TIME` BIGINT(13) NOT NULL,\n" +
                "  `END_TIME` BIGINT(13) DEFAULT NULL,\n" +
                "  `CALENDAR_NAME` VARCHAR(200) DEFAULT NULL,\n" +
                "  `MISFIRE_INSTR` SMALLINT(2) DEFAULT NULL,\n" +
                "  `JOB_DATA` BLOB,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_C` (`SCHED_NAME`,`CALENDAR_NAME`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`) USING BTREE,\n" +
                "  CONSTRAINT `" + projectName + "_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `" + projectName + "_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_blob_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `BLOB_DATA` BLOB,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),\n" +
                "  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,\n" +
                "  CONSTRAINT `" + projectName + "_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `" + projectName + "_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_calendars` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `CALENDAR_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `CALENDAR` BLOB NOT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_cron_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `CRON_EXPRESSION` VARCHAR(120) NOT NULL,\n" +
                "  `TIME_ZONE_ID` VARCHAR(80) DEFAULT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),\n" +
                "  CONSTRAINT `" + projectName + "_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `" + projectName + "_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_fired_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `ENTRY_ID` VARCHAR(95) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `INSTANCE_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `FIRED_TIME` BIGINT(13) NOT NULL,\n" +
                "  `SCHED_TIME` BIGINT(13) NOT NULL,\n" +
                "  `PRIORITY` INT(11) NOT NULL,\n" +
                "  `STATE` VARCHAR(16) NOT NULL,\n" +
                "  `JOB_NAME` VARCHAR(200) DEFAULT NULL,\n" +
                "  `JOB_GROUP` VARCHAR(200) DEFAULT NULL,\n" +
                "  `IS_NONCONCURRENT` VARCHAR(1) DEFAULT NULL,\n" +
                "  `REQUESTS_RECOVERY` VARCHAR(1) DEFAULT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_JG` (`SCHED_NAME`,`JOB_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`) USING BTREE,\n" +
                "  KEY `IDX_" + projectNameUppercase + "_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) USING BTREE\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_locks` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `LOCK_NAME` VARCHAR(40) NOT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_paused_trigger_grps` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_scheduler_state` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `INSTANCE_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,\n" +
                "  `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_simple_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `REPEAT_COUNT` BIGINT(7) NOT NULL,\n" +
                "  `REPEAT_INTERVAL` BIGINT(12) NOT NULL,\n" +
                "  `TIMES_TRIGGERED` BIGINT(10) NOT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),\n" +
                "  CONSTRAINT `" + projectName + "_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `" + projectName + "_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n" +
                "\n" +
                "CREATE TABLE `" + projectName + "_simprop_triggers` (\n" +
                "  `SCHED_NAME` VARCHAR(120) NOT NULL,\n" +
                "  `TRIGGER_NAME` VARCHAR(200) NOT NULL,\n" +
                "  `TRIGGER_GROUP` VARCHAR(200) NOT NULL,\n" +
                "  `STR_PROP_1` VARCHAR(512) DEFAULT NULL,\n" +
                "  `STR_PROP_2` VARCHAR(512) DEFAULT NULL,\n" +
                "  `STR_PROP_3` VARCHAR(512) DEFAULT NULL,\n" +
                "  `INT_PROP_1` INT(11) DEFAULT NULL,\n" +
                "  `INT_PROP_2` INT(11) DEFAULT NULL,\n" +
                "  `LONG_PROP_1` BIGINT(20) DEFAULT NULL,\n" +
                "  `LONG_PROP_2` BIGINT(20) DEFAULT NULL,\n" +
                "  `DEC_PROP_1` DECIMAL(13,4) DEFAULT NULL,\n" +
                "  `DEC_PROP_2` DECIMAL(13,4) DEFAULT NULL,\n" +
                "  `BOOL_PROP_1` VARCHAR(1) DEFAULT NULL,\n" +
                "  `BOOL_PROP_2` VARCHAR(1) DEFAULT NULL,\n" +
                "  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),\n" +
                "  CONSTRAINT `" + projectName + "_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `" + projectName + "_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)\n" +
                ") ENGINE=INNODB DEFAULT CHARSET=utf8;\n";
        System.out.println( sql );
    }
}

狄龙疤
关注
  • 0
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
quartz框架mysql表结构 2.3版本 共11张表（tables_mysql_innodb.sql）
03-22
这是quartz的mysql类型的11个管理quartz的建表语句，全部来自于官网下载，全名：tables_mysql_innodb.sql
Quartz集群原理及配置应用
weixin_34345560的博客
08-25 479
1、Quartz任务调度的基本实现原理 　　Quartz是OpenSymphony开源组织在任务调度领域的一个开源项目，完全基于Java实现。作为一个优秀的开源调度框架，Quartz具有以下特点： 　　　　（1）强大的调度功能，例如支持丰富多样的调度方法，可以满足各种常规及特殊需求； 　　　　（2）灵活的应用方式，例如支持任务和调度的多种组合方式，支持调度数据的多种存储方式； 　　　　（3...
quartz-与table结合
cxu123321的博客
08-10 206
MindMaster 界面 Class public class QuartzClass { public string Year { get; set; } public string DayofWeek { get; set; } public string Month { get; set; } public string DayofMonth { get; set; } public string H..
Quartz存储与持久化--mysql--建表
dengkuan1023的博客
05-30 1861
Quartz存储与持久化--mysql--建表 <p>Quartz提供两种基本作业存储类型。</p> 第一种类型叫做RAMJobStore。 第二种类型叫做JDBC作业存储。 在默认情况下Quartz将任务调度的运行信息保存在内存中，这种方法提供了最佳的性能，因为内存中数据访问...
Quartz V2.3.1版本sql初始化文件
mathlpz126的博客
10-24 1304
# # Quartz seems to work best with the driver mm.mysql-2.0.7-bin.jar # # PLEASE consider using mysql with innodb tables to avoid locking issues # # In your Quartz properties file, you'll need to set #...
Quartz定时任务常用的11张数据库脚本表结构
11-30
这里我们将详细探讨Quartz定时任务在数据库中的11张核心表结构。 1. **QRTZ_JOB_DETAILS**：此表存储所有Job的详细信息，如Job类名、Job数据映射等。每个Job实例在此表中对应一条记录，Job的唯一标识由`SCHED_NAME`...
quartz内部表.sql
08-02
quartz内部表.sql。
quartz 持久化数据库表结构sql
最新发布
10-13
Quartz的持久化机制依赖于一组特定的数据库表，这些表存储了Job（任务）和Trigger（触发器）的信息。以下是Quartz默认使用的数据库表： 1. QRTZ_JOB_DETAILS：存储Job的详细信息，如Job类名、是否持久化、组名等。 ...
Quartz定时任务持久化数据表
09-21
在提供的&quot;quartz.sql&quot;文件中，很可能是包含了Quartz框架所需的数据库表结构和初始化数据。这些表通常包括以下几部分： 1. `QRTZ_JOB_DETAILS`：这个表存储了作业的详细信息，如作业类名、作业组名、描述等。每个...
Quartz定时器表.sql
03-31
Quartz定时器表 执行语句 方便部署处理数据
quartz创建表sql
07-01
quartz创建表sql,里面包含oracle，mysql,db2,sqlserver等各种关系型数据库的sql
Quartz创建表sql文件
02-01
使用Quartz定时任务所需的11张表的创建表sql语句。
quartz各种数据库的建表语句
09-12
建表语句基于quartz-2.2.3版本，使用时请注意！如有不适合亲自行到官网下载
spring-boot 中自动生成 quartz 所需的表
冬无雪的博客
11-08 5738
1、添加依赖： <!--mysql--> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.17</version> </dependency>
Quartz 建表语句SQL文件
weixin_44371237的博客
09-22 1109
SQL文件在jar里面，github下载解压，sql文件路径：quartz-core\src\main\resources\org\quartz\impl\jdbcjobstore。
【Java】Quartz定时作业的创建
Do_GH的博客
08-13 839
本文主要介绍了Quartz的应用。
quartz各版本MySQL数据库存储建表SQL语句
愿我如星君如月 ... 夜夜流光相皎洁 ...
04-10 3469
见：https://blog.csdn.net/zhu19774279/article/details/44946645用quartz管理任务计划很方便，但是当使用数据库作为存储介质的时候，必须要先创建表，不然就会报错。1.x和2.x的建表语句不同，以下是两个版本使用MySQL时的建表语句。1.x建表语句为：[sql]view plaincopy##InyourQuartzprop...
SQL Server数据库中，QUARTZ建表语句
mnimxq的博客
02-14 775
quartz 定时任务
quartz mysql 建表_quartz创建表语句
weixin_36284848的博客
02-21 1371
quartz创建表语句目录 :该建表语句适用2.xx版本,每个表的用途可以问度娘.(oracle)该建表语句适用2.xx版本,每个表的用途可以问度娘.(mysql)-- 存储每一个已配置的 Job 的详细信息CREATE TABLE qrtz_job_details(SCHED_NAME VARCHAR2(120) NOT NULL,JOB_NAME VARCHAR2(200) NOT NULL...
quartz数据库表
08-28
Quartz数据库包含了11张表用于存储调度信息和实现分布式锁。这些表包括： 1. QRTZ_JOB_DETAILS：存储Job的详细信息，如Job的类名、组名、描述等。 2. QRTZ_TRIGGERS：存储Trigger的详细信息，如Trigger的名称、组名...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值