qrtz表初始化脚本_mysql

旭洋

1. DROP TABLE IF EXISTS qrtz_blob_triggers;
2. DROP TABLE IF EXISTS qrtz_calendars;
3. DROP TABLE IF EXISTS qrtz_cron_triggers;
4. DROP TABLE IF EXISTS qrtz_fired_triggers;
5. DROP TABLE IF EXISTS qrtz_locks;
6. DROP TABLE IF EXISTS qrtz_paused_trigger_grps;
7. DROP TABLE IF EXISTS qrtz_scheduler_state;
8. DROP TABLE IF EXISTS qrtz_simple_triggers;
9. DROP TABLE IF EXISTS qrtz_simprop_triggers;
10. DROP TABLE IF EXISTS qrtz_task_triggers;
11. DROP TABLE IF EXISTS qrtz_triggers;
12. DROP TABLE IF EXISTS qrtz_job_details;
15. --
16. -- Table structure for table `qrtz_job_details`
17. --
19. DROP TABLE IF EXISTS `qrtz_job_details`;
20. CREATE TABLE `qrtz_job_details` (
21.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
22.   `JOB_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
23.   `JOB_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
24.   `DESCRIPTION` varchar(250) COLLATE utf8_bin DEFAULT NULL,
25.   `JOB_CLASS_NAME` varchar(250) COLLATE utf8_bin NOT NULL,
26.   `IS_DURABLE` varchar(1) COLLATE utf8_bin NOT NULL,
27.   `IS_NONCONCURRENT` varchar(1) COLLATE utf8_bin NOT NULL,
28.   `IS_UPDATE_DATA` varchar(1) COLLATE utf8_bin NOT NULL,
29.   `REQUESTS_RECOVERY` varchar(1) COLLATE utf8_bin NOT NULL,
30.   `JOB_DATA` longblob,
31.   PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
32.   KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`),
33.   KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`)
34. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
37. --
38. -- Table structure for table `qrtz_triggers`
39. --
41. DROP TABLE IF EXISTS `qrtz_triggers`;
42. CREATE TABLE `qrtz_triggers` (
43.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
44.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
45.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
46.   `JOB_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
47.   `JOB_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
48.   `DESCRIPTION` varchar(250) COLLATE utf8_bin DEFAULT NULL,
49.   `NEXT_FIRE_TIME` decimal(13,0) DEFAULT NULL,
50.   `PREV_FIRE_TIME` decimal(13,0) DEFAULT NULL,
51.   `PRIORITY` decimal(13,0) DEFAULT NULL,
52.   `TRIGGER_STATE` varchar(16) COLLATE utf8_bin NOT NULL,
53.   `TRIGGER_TYPE` varchar(8) COLLATE utf8_bin NOT NULL,
54.   `START_TIME` decimal(13,0) NOT NULL,
55.   `END_TIME` decimal(13,0) DEFAULT NULL,
56.   `CALENDAR_NAME` varchar(200) COLLATE utf8_bin DEFAULT NULL,
57.   `MISFIRE_INSTR` decimal(2,0) DEFAULT NULL,
58.   `JOB_DATA` longblob,
59.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
60.   KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
61.   KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
62.   KEY `IDX_QRTZ_T_J` (`JOB_NAME`,`JOB_GROUP`,`SCHED_NAME`),
63.   KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
64.   KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`NEXT_FIRE_TIME`,`SCHED_NAME`),
65.   KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
66.   KEY `IDX_QRTZ_T_NFT_ST` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`,`SCHED_NAME`),
67.   KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`NEXT_FIRE_TIME`,`TRIGGER_STATE`,`SCHED_NAME`,`MISFIRE_INSTR`),
68.   KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`TRIGGER_GROUP`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`,`MISFIRE_INSTR`,`SCHED_NAME`),
69.   KEY `IDX_QRTZ_T_N_G_STATE` (`TRIGGER_GROUP`,`TRIGGER_STATE`,`SCHED_NAME`),
70.   KEY `IDX_QRTZ_T_N_STATE` (`TRIGGER_STATE`,`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
71.   KEY `IDX_QRTZ_T_STATE` (`TRIGGER_STATE`,`SCHED_NAME`),
72.   KEY `QRTZ_TRIGGER_TO_JOBS_FK` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
73.   CONSTRAINT `QRTZ_TRIGGER_TO_JOBS_FK` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
74. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
76. --
77. -- Table structure for table `qrtz_blob_triggers`
78. --
80. DROP TABLE IF EXISTS `qrtz_blob_triggers`;
81. CREATE TABLE `qrtz_blob_triggers` (
82.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
83.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
84.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
85.   `BLOB_DATA` longblob,
86.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
87.   CONSTRAINT `QRTZ_BLOB_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
88. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
91. --
92. -- Table structure for table `qrtz_calendars`
93. --
95. DROP TABLE IF EXISTS `qrtz_calendars`;
96. CREATE TABLE `qrtz_calendars` (
97.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
98.   `CALENDAR_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
99.   `CALENDAR` longblob NOT NULL,
100.   PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
101. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
103. --
104. -- Table structure for table `qrtz_cron_triggers`
105. --
107. DROP TABLE IF EXISTS `qrtz_cron_triggers`;
108. CREATE TABLE `qrtz_cron_triggers` (
109.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
110.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
111.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
112.   `CRON_EXPRESSION` varchar(120) COLLATE utf8_bin NOT NULL,
113.   `TIME_ZONE_ID` varchar(80) COLLATE utf8_bin DEFAULT NULL,
114.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
115.   CONSTRAINT `QRTZ_CRON_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
116. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
119. --
120. -- Table structure for table `qrtz_fired_triggers`
121. --
123. DROP TABLE IF EXISTS `qrtz_fired_triggers`;
124. CREATE TABLE `qrtz_fired_triggers` (
125.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
126.   `ENTRY_ID` varchar(95) COLLATE utf8_bin NOT NULL,
127.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
128.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
129.   `INSTANCE_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
130.   `FIRED_TIME` decimal(13,0) NOT NULL,
131.   `SCHED_TIME` decimal(13,0) NOT NULL,
132.   `PRIORITY` decimal(13,0) NOT NULL,
133.   `STATE` varchar(16) COLLATE utf8_bin NOT NULL,
134.   `JOB_NAME` varchar(200) COLLATE utf8_bin DEFAULT NULL,
135.   `JOB_GROUP` varchar(200) COLLATE utf8_bin DEFAULT NULL,
136.   `IS_NONCONCURRENT` varchar(1) COLLATE utf8_bin DEFAULT NULL,
137.   `REQUESTS_RECOVERY` varchar(1) COLLATE utf8_bin DEFAULT NULL,
138.   PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
139.   KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
140.   KEY `IDX_QRTZ_FT_JG` (`JOB_GROUP`,`SCHED_NAME`),
141.   KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
142.   KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`),
143.   KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
144.   KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`)
145. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
147. --
148. -- Table structure for table `qrtz_locks`
149. --
151. DROP TABLE IF EXISTS `qrtz_locks`;
152. CREATE TABLE `qrtz_locks` (
153.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
154.   `LOCK_NAME` varchar(40) COLLATE utf8_bin NOT NULL,
155.   PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
156. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
159. --
160. -- Table structure for table `qrtz_paused_trigger_grps`
161. --
163. DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
164. CREATE TABLE `qrtz_paused_trigger_grps` (
165.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
166.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
167.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
168. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
171. --
172. -- Table structure for table `qrtz_scheduler_state`
173. --
175. DROP TABLE IF EXISTS `qrtz_scheduler_state`;
176. CREATE TABLE `qrtz_scheduler_state` (
177.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
178.   `INSTANCE_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
179.   `LAST_CHECKIN_TIME` decimal(13,0) NOT NULL,
180.   `CHECKIN_INTERVAL` decimal(13,0) NOT NULL,
181.   PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
182. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
185. --
186. -- Table structure for table `qrtz_simple_triggers`
187. --
189. DROP TABLE IF EXISTS `qrtz_simple_triggers`;
190. CREATE TABLE `qrtz_simple_triggers` (
191.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
192.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
193.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
194.   `REPEAT_COUNT` decimal(7,0) NOT NULL,
195.   `REPEAT_INTERVAL` decimal(12,0) NOT NULL,
196.   `TIMES_TRIGGERED` decimal(10,0) NOT NULL,
197.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
198.   CONSTRAINT `QRTZ_SIMPLE_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
199. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
202. --
203. -- Table structure for table `qrtz_simprop_triggers`
204. --
206. DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
207. CREATE TABLE `qrtz_simprop_triggers` (
208.   `SCHED_NAME` varchar(120) COLLATE utf8_bin NOT NULL,
209.   `TRIGGER_NAME` varchar(200) COLLATE utf8_bin NOT NULL,
210.   `TRIGGER_GROUP` varchar(200) COLLATE utf8_bin NOT NULL,
211.   `STR_PROP_1` text COLLATE utf8_bin,
212.   `STR_PROP_2` text COLLATE utf8_bin,
213.   `STR_PROP_3` text COLLATE utf8_bin,
214.   `INT_PROP_1` decimal(10,0) DEFAULT NULL,
215.   `INT_PROP_2` decimal(10,0) DEFAULT NULL,
216.   `LONG_PROP_1` decimal(13,0) DEFAULT NULL,
217.   `LONG_PROP_2` decimal(13,0) DEFAULT NULL,
218.   `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
219.   `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
220.   `BOOL_PROP_1` varchar(1) COLLATE utf8_bin DEFAULT NULL,
221.   `BOOL_PROP_2` varchar(1) COLLATE utf8_bin DEFAULT NULL,
222.   PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
223.   CONSTRAINT `QRTZ_SIMPROP_TRIG_TO_TRIG_FK` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
224. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

复制代码

 

来源:https://www.cnblogs.com/chinazhou-wang/p/17311874.html
免责声明：由于采集信息均来自互联网，如果侵犯了您的权益，请联系我们【E-Mail:cb@itdo.tech】 我们会及时删除侵权内容，谢谢合作！