-- Licensed to the Apache Software Foundation (ASF) under one
-- or more contributor license agreements. See the NOTICE file
-- distributed with this work for additional information
-- regarding copyright ownership. The ASF licenses this file
-- to you under the Apache License, Version 2.0 (the
-- "License"); you may not use this file except in compliance
-- with the License. You may obtain a copy of the License at
--
-- http://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing,
-- software distributed under the License is distributed on an
-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-- KIND, either express or implied. See the License for the
-- specific language governing permissions and limitations
-- under the License.
-- In your Quartz properties file, you'll need to set
-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
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_cron_triggers;
DROP TABLE IF EXISTS qrtz_simprop_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 BOOL NOT NULL,
IS_NONCONCURRENT BOOL NOT NULL,
IS_UPDATE_DATA BOOL NOT NULL,
REQUESTS_RECOVERY BOOL NOT NULL,
JOB_DATA BYTEA 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 NULL,
PREV_FIRE_TIME BIGINT NULL,
PRIORITY INTEGER NULL,
TRIGGER_STATE VARCHAR(16) NOT NULL,
TRIGGER_TYPE VARCHAR(8) NOT NULL,
START_TIME BIGINT NOT NULL,
END_TIME BIGINT NULL,
CALENDAR_NAME VARCHAR(200) NULL,
MISFIRE_INSTR SMALLINT NULL,
JOB_DATA BYTEA 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 NOT NULL,
REPEAT_INTERVAL BIGINT NOT NULL,
TIMES_TRIGGERED BIGINT 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(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)
);
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 BOOL NULL,
BOOL_PROP_2 BOOL 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 BYTEA 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 BYTEA 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 NOT NULL,
SCHED_TIME BIGINT NOT NULL,
PRIORITY INTEGER NOT NULL,
STATE VARCHAR(16) NOT NULL,
JOB_NAME VARCHAR(200) NULL,
JOB_GROUP VARCHAR(200) NULL,
IS_NONCONCURRENT BOOL NULL,
REQUESTS_RECOVERY BOOL 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 NOT NULL,
CHECKIN_INTERVAL BIGINT 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)
);
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);
commit;
没有合适的资源?快使用搜索试试~ 我知道了~
griffin 0.7.0发布包
需积分: 11 2 下载量 90 浏览量
2022-03-29
17:19:04
上传
评论
收藏 144.15MB GZ 举报
温馨提示
共269个文件
jar:246个
properties:6个
sql:5个
griffin 0.7.0 发布 打包 成品包
资源详情
资源评论
资源推荐
收起资源包目录
griffin 0.7.0发布包 (269个子文件)
fastutil-6.5.6.jar 16.12MB
hadoop-hdfs-2.7.1.jar 7.88MB
hive-metastore-2.2.0.jar 7.51MB
scala-library-2.10.4.jar 6.8MB
org.eclipse.persistence.core-2.6.0.jar 5.07MB
service-0.7.0-SNAPSHOT.jar 4.53MB
hbase-protocol-1.1.1.jar 4.01MB
netty-all-4.1.38.Final.jar 3.87MB
hbase-server-1.1.1.jar 3.79MB
hadoop-common-2.7.1.jar 3.27MB
tomcat-embed-core-9.0.22.jar 3.19MB
derby-10.14.2.0.jar 3.08MB
parquet-hadoop-bundle-1.8.1.jar 2.77MB
guava-14.0.1.jar 2.09MB
h2-1.4.199.jar 2.08MB
aspectjweaver-1.9.4.jar 1.95MB
hadoop-yarn-api-2.7.1.jar 1.92MB
datanucleus-core-4.1.6.jar 1.92MB
ant-1.9.1.jar 1.9MB
datanucleus-rdbms-4.1.7.jar 1.8MB
slider-core-0.90.2-incubating.jar 1.7MB
hadoop-yarn-common-2.7.1.jar 1.58MB
log4j-core-2.11.2.jar 1.55MB
commons-math3-3.1.1.jar 1.53MB
hadoop-yarn-server-resourcemanager-2.8.0.jar 1.52MB
hive-service-rpc-2.2.0.jar 1.48MB
hadoop-mapreduce-client-core-2.7.1.jar 1.47MB
htrace-core-3.1.0-incubating.jar 1.41MB
org.eclipse.persistence.jpa-2.6.0.jar 1.36MB
org.eclipse.persistence.jpa.jpql-2.6.0.jar 1.35MB
spring-web-5.1.9.RELEASE.jar 1.32MB
jackson-databind-2.9.9.3.jar 1.29MB
spring-core-5.1.9.RELEASE.jar 1.23MB
jcodings-1.0.8.jar 1.23MB
spring-boot-autoconfigure-2.1.7.RELEASE.jar 1.21MB
snappy-java-1.0.5.jar 1.19MB
hbase-client-1.1.1.jar 1.19MB
xercesImpl-2.9.1.jar 1.17MB
netty-3.7.0.Final.jar 1.15MB
spring-data-commons-2.1.10.RELEASE.jar 1.12MB
hibernate-validator-6.0.17.Final.jar 1.1MB
spring-context-5.1.9.RELEASE.jar 1.05MB
leveldbjni-all-1.8.jar 1021KB
ant-1.6.5.jar 1010KB
jsp-2.1-6.1.14.jar 1001KB
mysql-connector-java-5.1.47.jar 984KB
commons-math-2.2.jar 965KB
spring-boot-2.1.7.RELEASE.jar 933KB
hive-serde-2.2.0.jar 889KB
jaxb-impl-2.2.3-1.jar 869KB
spring-webmvc-5.1.9.RELEASE.jar 782KB
zookeeper-3.4.6.jar 774KB
jackson-mapper-asl-1.9.13.jar 762KB
javassist-3.24.0-GA.jar 759KB
httpclient-4.5.9.jar 756KB
hadoop-mapreduce-client-common-2.7.1.jar 735KB
hive-orc-2.2.0.jar 698KB
jersey-server-1.9.jar 696KB
guice-3.0.jar 694KB
hive-llap-server-2.2.0.jar 683KB
apacheds-kerberos-codec-2.0.0-M15.jar 675KB
postgresql-9.4.1212.jre7.jar 661KB
spring-beans-5.1.9.RELEASE.jar 658KB
quartz-2.2.2.jar 645KB
joda-time-2.10.3.jar 628KB
tephra-core-0.6.0.jar 620KB
c3p0-0.9.1.1.jar 594KB
commons-collections-3.2.1.jar 562KB
jetty-6.1.26.jar 527KB
zookeeper-3.4.6-tests.jar 527KB
protobuf-java-2.5.0.jar 521KB
hbase-common-1.1.1.jar 517KB
hive-service-2.2.0.jar 504KB
hadoop-mapreduce-client-app-2.7.1.jar 504KB
commons-lang3-3.8.1.jar 490KB
log4j-1.2.16.jar 470KB
jersey-core-1.9.jar 448KB
antlr-2.7.7.jar 435KB
kryo-2.22.jar 432KB
avro-1.7.7.jar 426KB
spring-security-core-5.1.6.RELEASE.jar 423KB
hive-common-2.2.0.jar 400KB
jasper-compiler-5.5.23.jar 399KB
spring-jdbc-5.1.9.RELEASE.jar 395KB
javolution-5.5.1.jar 386KB
spring-aop-5.1.9.RELEASE.jar 360KB
datanucleus-api-jdo-4.2.1.jar 358KB
httpcore-nio-4.4.11.jar 357KB
hadoop-yarn-server-common-2.7.1.jar 355KB
spring-data-jpa-2.1.10.RELEASE.jar 352KB
commons-codec-1.11.jar 327KB
httpcore-4.4.11.jar 319KB
hive-llap-common-2.2.0.jar 318KB
jackson-core-2.9.9.jar 318KB
org.eclipse.persistence.asm-2.6.0.jar 316KB
libfb303-0.9.3.jar 306KB
commons-httpclient-3.1.jar 298KB
snakeyaml-1.23.jar 294KB
commons-configuration-1.6.jar 292KB
commons-lang-2.6.jar 278KB
共 269 条
- 1
- 2
- 3
梦想成真那天
- 粉丝: 56
- 资源: 26
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0