-- This file collects all quartz table create statement required for quartz 2.2.1
--
-- We are using Quartz 2.2.1 tables, the original place of which can be found at
-- https://github.com/quartz-scheduler/quartz/blob/quartz-2.2.1/distribution/src/main/assembly/root/docs/dbTables/tables_mysql.sql
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(200) NOT NULL,
JOB_GROUP VARCHAR(200) 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)
);
CREATE TABLE QRTZ_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) 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(200) 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)
);
CREATE TABLE QRTZ_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),
FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
);
CREATE TABLE QRTZ_CRON_TRIGGERS
(
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(200) NOT NULL,
TRIGGER_GROUP VARCHAR(200) NOT NULL,
CRON_EXPRESSION VARCHAR(200) 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)
);
CREATE TABLE QRTZ_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) 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)
);
CREATE TABLE QRTZ_BLOB_TRIGGERS
(
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_NAME VARCHAR(200) NOT NULL,
TRIGGER_GROUP VARCHAR(200) NOT NULL,
BLOB_DATA BLOB 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)
);
CREATE TABLE QRTZ_CALENDARS
(
SCHED_NAME VARCHAR(120) NOT NULL,
CALENDAR_NAME VARCHAR(200) NOT NULL,
CALENDAR BLOB NOT NULL,
PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
);
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
(
SCHED_NAME VARCHAR(120) NOT NULL,
TRIGGER_GROUP VARCHAR(200) NOT NULL,
PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
);
CREATE TABLE QRTZ_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 INTEGER NOT NULL,
STATE VARCHAR(16) NOT NULL,
JOB_NAME VARCHAR(200) NULL,
JOB_GROUP VARCHAR(200) NULL,
IS_NONCONCURRENT VARCHAR(1) NULL,
REQUESTS_RECOVERY VARCHAR(1) NULL,
PRIMARY KEY (SCHED_NAME,ENTRY_ID)
);
CREATE TABLE QRTZ_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)
);
CREATE TABLE QRTZ_LOCKS
(
SCHED_NAME VARCHAR(120) NOT NULL,
LOCK_NAME VARCHAR(40) NOT NULL,
PRIMARY KEY (SCHED_NAME,LOCK_NAME)
);
commit;
没有合适的资源?快使用搜索试试~ 我知道了~
azkaban-solo-server-亲测可用
3星 · 超过75%的资源 需积分: 44 17 下载量 165 浏览量
2018-12-24
18:06:28
上传
评论 1
收藏 22.77MB GZ 举报
温馨提示
共298个文件
js:113个
jar:80个
png:44个
azkaban 的单机版本,直接进入到目录下,执行、bin/start-solo.sh便可以使用
资源推荐
资源详情
资源评论
收起资源包目录
azkaban-solo-server-亲测可用 (298个子文件)
bootstrap.css 123KB
jquery-ui-1.10.1.custom.css 32KB
jquery-ui.css 32KB
azkaban.css 22KB
style.css 6KB
style.css 5KB
bootstrap-datetimepicker.css 4KB
style.css 4KB
style.css 4KB
azkaban-graph.css 2KB
jquery.contextMenu.css 1KB
jquery.autocomplete.css 824B
jquery-ui-timepicker-addon.css 522B
morris.css 512B
jquery.svg.css 444B
glyphicons-halflings-regular.eot 20KB
d.gif 3KB
d.gif 3KB
throbber.gif 2KB
throbber.gif 2KB
throbber.gif 2KB
throbber.gif 2KB
animated-overlay.gif 2KB
dots.gif 132B
dot_for_ie.gif 43B
dot_for_ie.gif 43B
favicon.ico 943B
guava-21.0.jar 2.4MB
h2-1.4.193.jar 1.71MB
commons-math3-3.0.jar 1.23MB
snappy-java-1.1.2.4.jar 1.01MB
mysql-connector-java-5.1.28.jar 855KB
netty-3.2.3.Final.jar 768KB
jackson-mapper-asl-1.9.5.jar 761KB
httpclient-4.5.3.jar 730KB
kafka-clients-0.10.0.0.jar 726KB
guice-4.1.0.jar 658KB
quartz-2.2.1.jar 645KB
c3p0-0.9.1.1.jar 594KB
commons-collections-3.2.2.jar 575KB
joda-time-2.0.jar 556KB
azkaban-common-0.1.0-SNAPSHOT.jar 529KB
jetty-6.1.26.jar 527KB
mail-1.4.5.jar 496KB
log4j-1.2.17.jar 478KB
dom4j-1.1.jar 446KB
velocity-1.7.jar 439KB
data-1.15.7.jar 379KB
antlr-2.7.2.jar 350KB
velocity-tools-2.0.jar 338KB
struts-core-1.3.8.jar 321KB
httpcore-4.4.6.jar 316KB
cglib-nodep-2.2.jar 315KB
mina-core-1.1.7.jar 308KB
snakeyaml-1.18.jar 278KB
commons-lang-2.6.jar 278KB
azkaban-web-server-0.1.0-SNAPSHOT.jar 271KB
restli-server-1.15.7.jar 263KB
commons-jexl-2.1.1.jar 261KB
commons-codec-1.9.jar 258KB
r2-1.15.7.jar 248KB
struts-taglib-1.3.8.jar 246KB
lz4-1.3.0.jar 231KB
gson-2.8.1.jar 227KB
jackson-core-asl-1.9.5.jar 223KB
restli-common-1.15.7.jar 188KB
jackson-core-2.2.2.jar 187KB
commons-beanutils-1.7.0.jar 184KB
commons-io-2.4.jar 181KB
jetty-util-6.1.26.jar 173KB
commons-dbcp2-2.1.1.jar 170KB
commons-compress-1.2.jar 165KB
azkaban-exec-server-0.1.0-SNAPSHOT.jar 152KB
commons-digester-1.8.jar 140KB
commons-validator-1.3.1.jar 136KB
servlet-api-2.5-20081211.jar 131KB
struts-tiles-1.3.8.jar 117KB
commons-pool2-2.4.2.jar 109KB
metrics-core-3.1.0.jar 109KB
parseq-1.3.6.jar 93KB
commons-chain-1.1.jar 88KB
javax.servlet-api-3.0.1.jar 83KB
oro-2.0.8.jar 64KB
activation-1.1.jar 62KB
commons-dbutils-1.5.jar 60KB
commons-logging-1.2.jar 60KB
commons-fileupload-1.2.1.jar 56KB
jopt-simple-4.3.jar 53KB
data-transform-1.15.7.jar 53KB
snappy-0.3.jar 48KB
json-20070829.jar 41KB
slf4j-api-1.7.21.jar 40KB
li-jersey-uri-1.15.7.jar 35KB
az-core-0.1.0-SNAPSHOT.jar 35KB
metrics-jvm-3.1.0.jar 35KB
sslext-1.2-0.jar 26KB
azkaban-hadoop-security-plugin-0.1.0-SNAPSHOT.jar 25KB
jsr305-3.0.2.jar 19KB
pegasus-common-1.15.7.jar 19KB
kafka-log4j-appender-0.10.0.0.jar 13KB
共 298 条
- 1
- 2
- 3
资源评论
- qq_206692672022-03-10运行后azkaban主页中,没有菜单simple_chenc2024-01-09有web页面的
- ruanjianxuqiu1262019-11-10可以没问题
simple_chenc
- 粉丝: 962
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功