forked from liferay/liferay-portal
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathquartz-tables.sql
146 lines (132 loc) · 5.07 KB
/
quartz-tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
create table QUARTZ_BLOB_TRIGGERS (
SCHED_NAME VARCHAR(120) not null,
TRIGGER_NAME VARCHAR(200) not null,
TRIGGER_GROUP VARCHAR(200) not null,
BLOB_DATA SBLOB null,
primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
create table QUARTZ_CALENDARS (
SCHED_NAME VARCHAR(120) not null,
CALENDAR_NAME VARCHAR(200) not null,
CALENDAR SBLOB not null,
primary key (SCHED_NAME,CALENDAR_NAME)
);
create table QUARTZ_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)
);
create table QUARTZ_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 LONG not null,
PRIORITY INTEGER not null,
STATE VARCHAR(16) not null,
JOB_NAME VARCHAR(200) null,
JOB_GROUP VARCHAR(200) null,
IS_NONCONCURRENT BOOLEAN null,
REQUESTS_RECOVERY BOOLEAN null,
primary key (SCHED_NAME, ENTRY_ID)
);
create table QUARTZ_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 BOOLEAN not null,
IS_NONCONCURRENT BOOLEAN not null,
IS_UPDATE_DATA BOOLEAN not null,
REQUESTS_RECOVERY BOOLEAN not null,
JOB_DATA SBLOB null,
primary key (SCHED_NAME, JOB_NAME, JOB_GROUP)
);
create table QUARTZ_LOCKS (
SCHED_NAME VARCHAR(120) not null,
LOCK_NAME VARCHAR(40) not null ,
primary key (SCHED_NAME, LOCK_NAME)
);
create table QUARTZ_PAUSED_TRIGGER_GRPS (
SCHED_NAME VARCHAR(120) not null,
TRIGGER_GROUP VARCHAR(200) not null,
primary key (SCHED_NAME, TRIGGER_GROUP)
);
create table QUARTZ_SCHEDULER_STATE (
SCHED_NAME VARCHAR(120) not null,
INSTANCE_NAME VARCHAR(200) not null,
LAST_CHECKIN_TIME LONG not null,
CHECKIN_INTERVAL LONG not null,
primary key (SCHED_NAME, INSTANCE_NAME)
);
create table QUARTZ_SIMPLE_TRIGGERS (
SCHED_NAME VARCHAR(120) not null,
TRIGGER_NAME VARCHAR(200) not null,
TRIGGER_GROUP VARCHAR(200) not null,
REPEAT_COUNT LONG not null,
REPEAT_INTERVAL LONG not null,
TIMES_TRIGGERED LONG not null,
primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
create table QUARTZ_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 INTEGER null,
INT_PROP_2 INTEGER null,
LONG_PROP_1 LONG null,
LONG_PROP_2 LONG null,
DEC_PROP_1 NUMERIC(13,4) null,
DEC_PROP_2 NUMERIC(13,4) null,
BOOL_PROP_1 BOOLEAN null,
BOOL_PROP_2 BOOLEAN null,
primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
create table QUARTZ_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 LONG null,
PREV_FIRE_TIME LONG null,
PRIORITY INTEGER null,
TRIGGER_STATE VARCHAR(16) not null,
TRIGGER_TYPE VARCHAR(8) not null,
START_TIME LONG not null,
END_TIME LONG null,
CALENDAR_NAME VARCHAR(200) null,
MISFIRE_INSTR INTEGER null,
JOB_DATA SBLOB null,
primary key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP)
);
COMMIT_TRANSACTION;
create index IX_88328984 on QUARTZ_JOB_DETAILS (SCHED_NAME, JOB_GROUP);
create index IX_779BCA37 on QUARTZ_JOB_DETAILS (SCHED_NAME, REQUESTS_RECOVERY);
create index IX_BE3835E5 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP);
create index IX_4BD722BM on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, TRIGGER_GROUP);
create index IX_204D31E8 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, INSTANCE_NAME);
create index IX_339E078M on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, INSTANCE_NAME, REQUESTS_RECOVERY);
create index IX_5005E3AF on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_NAME, JOB_GROUP);
create index IX_BC2F03B0 on QUARTZ_FIRED_TRIGGERS (SCHED_NAME, JOB_GROUP);
create index IX_186442A4 on QUARTZ_TRIGGERS (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_STATE);
create index IX_1BA1F9DC on QUARTZ_TRIGGERS (SCHED_NAME, TRIGGER_GROUP);
create index IX_91CA7CCE on QUARTZ_TRIGGERS (SCHED_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, TRIGGER_STATE, MISFIRE_INSTR);
create index IX_D219AFDE on QUARTZ_TRIGGERS (SCHED_NAME, TRIGGER_GROUP, TRIGGER_STATE);
create index IX_A85822A0 on QUARTZ_TRIGGERS (SCHED_NAME, JOB_NAME, JOB_GROUP);
create index IX_8AA50BE1 on QUARTZ_TRIGGERS (SCHED_NAME, JOB_GROUP);
create index IX_EEFE382A on QUARTZ_TRIGGERS (SCHED_NAME, NEXT_FIRE_TIME);
create index IX_F026CF4C on QUARTZ_TRIGGERS (SCHED_NAME, NEXT_FIRE_TIME, TRIGGER_STATE);
create index IX_F2DD7C7E on QUARTZ_TRIGGERS (SCHED_NAME, NEXT_FIRE_TIME, TRIGGER_STATE, MISFIRE_INSTR);
create index IX_1F92813C on QUARTZ_TRIGGERS (SCHED_NAME, NEXT_FIRE_TIME, MISFIRE_INSTR);
create index IX_99108B6E on QUARTZ_TRIGGERS (SCHED_NAME, TRIGGER_STATE);
create index IX_CD7132D0 on QUARTZ_TRIGGERS (SCHED_NAME, CALENDAR_NAME);