quartz.sql 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355
  1. -- MySQL dump 10.13 Distrib 8.0.46, for Linux (x86_64)
  2. --
  3. -- Host: localhost Database: quartz
  4. -- ------------------------------------------------------
  5. -- Server version 8.0.46
  6. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  7. /*!40103 SET TIME_ZONE='+00:00' */;
  8. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  9. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  10. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  11. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  12. --
  13. -- Table structure for table `t_qrtz_blob_triggers`
  14. --
  15. DROP TABLE IF EXISTS `t_qrtz_blob_triggers`;
  16. /*!40101 SET @saved_cs_client = @@character_set_client */;
  17. /*!50503 SET character_set_client = utf8mb4 */;
  18. CREATE TABLE `t_qrtz_blob_triggers` (
  19. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  20. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  21. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  22. `blob_data` blob,
  23. PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  24. KEY `sched_name` (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  25. CONSTRAINT `t_qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `t_qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
  26. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  27. /*!40101 SET character_set_client = @saved_cs_client */;
  28. --
  29. -- Dumping data for table `t_qrtz_blob_triggers`
  30. --
  31. LOCK TABLES `t_qrtz_blob_triggers` WRITE;
  32. /*!40000 ALTER TABLE `t_qrtz_blob_triggers` DISABLE KEYS */;
  33. /*!40000 ALTER TABLE `t_qrtz_blob_triggers` ENABLE KEYS */;
  34. UNLOCK TABLES;
  35. --
  36. -- Table structure for table `t_qrtz_calendars`
  37. --
  38. DROP TABLE IF EXISTS `t_qrtz_calendars`;
  39. /*!40101 SET @saved_cs_client = @@character_set_client */;
  40. /*!50503 SET character_set_client = utf8mb4 */;
  41. CREATE TABLE `t_qrtz_calendars` (
  42. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  43. `calendar_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  44. `calendar` blob NOT NULL,
  45. PRIMARY KEY (`sched_name`,`calendar_name`) USING BTREE
  46. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  47. /*!40101 SET character_set_client = @saved_cs_client */;
  48. --
  49. -- Dumping data for table `t_qrtz_calendars`
  50. --
  51. LOCK TABLES `t_qrtz_calendars` WRITE;
  52. /*!40000 ALTER TABLE `t_qrtz_calendars` DISABLE KEYS */;
  53. /*!40000 ALTER TABLE `t_qrtz_calendars` ENABLE KEYS */;
  54. UNLOCK TABLES;
  55. --
  56. -- Table structure for table `t_qrtz_cron_triggers`
  57. --
  58. DROP TABLE IF EXISTS `t_qrtz_cron_triggers`;
  59. /*!40101 SET @saved_cs_client = @@character_set_client */;
  60. /*!50503 SET character_set_client = utf8mb4 */;
  61. CREATE TABLE `t_qrtz_cron_triggers` (
  62. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  63. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  64. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  65. `cron_expression` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  66. `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  67. PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  68. CONSTRAINT `t_qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `t_qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
  69. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  70. /*!40101 SET character_set_client = @saved_cs_client */;
  71. --
  72. -- Dumping data for table `t_qrtz_cron_triggers`
  73. --
  74. LOCK TABLES `t_qrtz_cron_triggers` WRITE;
  75. /*!40000 ALTER TABLE `t_qrtz_cron_triggers` DISABLE KEYS */;
  76. /*!40000 ALTER TABLE `t_qrtz_cron_triggers` ENABLE KEYS */;
  77. UNLOCK TABLES;
  78. --
  79. -- Table structure for table `t_qrtz_fired_triggers`
  80. --
  81. DROP TABLE IF EXISTS `t_qrtz_fired_triggers`;
  82. /*!40101 SET @saved_cs_client = @@character_set_client */;
  83. /*!50503 SET character_set_client = utf8mb4 */;
  84. CREATE TABLE `t_qrtz_fired_triggers` (
  85. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  86. `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  87. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  88. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  89. `instance_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  90. `fired_time` bigint NOT NULL,
  91. `sched_time` bigint NOT NULL,
  92. `priority` int NOT NULL,
  93. `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  94. `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  95. `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  96. `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  97. `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  98. PRIMARY KEY (`sched_name`,`entry_id`) USING BTREE,
  99. KEY `idx_qrtz_ft_trig_inst_name` (`sched_name`,`instance_name`) USING BTREE,
  100. KEY `idx_qrtz_ft_inst_job_req_rcvry` (`sched_name`,`instance_name`,`requests_recovery`) USING BTREE,
  101. KEY `idx_qrtz_ft_j_g` (`sched_name`,`job_name`,`job_group`) USING BTREE,
  102. KEY `idx_qrtz_ft_jg` (`sched_name`,`job_group`) USING BTREE,
  103. KEY `idx_qrtz_ft_t_g` (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  104. KEY `idx_qrtz_ft_tg` (`sched_name`,`trigger_group`) USING BTREE
  105. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  106. /*!40101 SET character_set_client = @saved_cs_client */;
  107. --
  108. -- Dumping data for table `t_qrtz_fired_triggers`
  109. --
  110. LOCK TABLES `t_qrtz_fired_triggers` WRITE;
  111. /*!40000 ALTER TABLE `t_qrtz_fired_triggers` DISABLE KEYS */;
  112. /*!40000 ALTER TABLE `t_qrtz_fired_triggers` ENABLE KEYS */;
  113. UNLOCK TABLES;
  114. --
  115. -- Table structure for table `t_qrtz_job_details`
  116. --
  117. DROP TABLE IF EXISTS `t_qrtz_job_details`;
  118. /*!40101 SET @saved_cs_client = @@character_set_client */;
  119. /*!50503 SET character_set_client = utf8mb4 */;
  120. CREATE TABLE `t_qrtz_job_details` (
  121. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  122. `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  123. `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  124. `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  125. `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  126. `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  127. `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  128. `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  129. `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  130. `job_data` blob,
  131. PRIMARY KEY (`sched_name`,`job_name`,`job_group`) USING BTREE,
  132. KEY `idx_qrtz_j_req_recovery` (`sched_name`,`requests_recovery`) USING BTREE,
  133. KEY `idx_qrtz_j_grp` (`sched_name`,`job_group`) USING BTREE
  134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  135. /*!40101 SET character_set_client = @saved_cs_client */;
  136. --
  137. -- Dumping data for table `t_qrtz_job_details`
  138. --
  139. LOCK TABLES `t_qrtz_job_details` WRITE;
  140. /*!40000 ALTER TABLE `t_qrtz_job_details` DISABLE KEYS */;
  141. /*!40000 ALTER TABLE `t_qrtz_job_details` ENABLE KEYS */;
  142. UNLOCK TABLES;
  143. --
  144. -- Table structure for table `t_qrtz_locks`
  145. --
  146. DROP TABLE IF EXISTS `t_qrtz_locks`;
  147. /*!40101 SET @saved_cs_client = @@character_set_client */;
  148. /*!50503 SET character_set_client = utf8mb4 */;
  149. CREATE TABLE `t_qrtz_locks` (
  150. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  151. `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  152. PRIMARY KEY (`sched_name`,`lock_name`) USING BTREE
  153. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  154. /*!40101 SET character_set_client = @saved_cs_client */;
  155. --
  156. -- Dumping data for table `t_qrtz_locks`
  157. --
  158. LOCK TABLES `t_qrtz_locks` WRITE;
  159. /*!40000 ALTER TABLE `t_qrtz_locks` DISABLE KEYS */;
  160. /*!40000 ALTER TABLE `t_qrtz_locks` ENABLE KEYS */;
  161. UNLOCK TABLES;
  162. --
  163. -- Table structure for table `t_qrtz_paused_trigger_grps`
  164. --
  165. DROP TABLE IF EXISTS `t_qrtz_paused_trigger_grps`;
  166. /*!40101 SET @saved_cs_client = @@character_set_client */;
  167. /*!50503 SET character_set_client = utf8mb4 */;
  168. CREATE TABLE `t_qrtz_paused_trigger_grps` (
  169. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  170. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  171. PRIMARY KEY (`sched_name`,`trigger_group`) USING BTREE
  172. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  173. /*!40101 SET character_set_client = @saved_cs_client */;
  174. --
  175. -- Dumping data for table `t_qrtz_paused_trigger_grps`
  176. --
  177. LOCK TABLES `t_qrtz_paused_trigger_grps` WRITE;
  178. /*!40000 ALTER TABLE `t_qrtz_paused_trigger_grps` DISABLE KEYS */;
  179. /*!40000 ALTER TABLE `t_qrtz_paused_trigger_grps` ENABLE KEYS */;
  180. UNLOCK TABLES;
  181. --
  182. -- Table structure for table `t_qrtz_scheduler_state`
  183. --
  184. DROP TABLE IF EXISTS `t_qrtz_scheduler_state`;
  185. /*!40101 SET @saved_cs_client = @@character_set_client */;
  186. /*!50503 SET character_set_client = utf8mb4 */;
  187. CREATE TABLE `t_qrtz_scheduler_state` (
  188. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  189. `instance_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  190. `last_checkin_time` bigint NOT NULL,
  191. `checkin_interval` bigint NOT NULL,
  192. PRIMARY KEY (`sched_name`,`instance_name`) USING BTREE
  193. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  194. /*!40101 SET character_set_client = @saved_cs_client */;
  195. --
  196. -- Dumping data for table `t_qrtz_scheduler_state`
  197. --
  198. LOCK TABLES `t_qrtz_scheduler_state` WRITE;
  199. /*!40000 ALTER TABLE `t_qrtz_scheduler_state` DISABLE KEYS */;
  200. /*!40000 ALTER TABLE `t_qrtz_scheduler_state` ENABLE KEYS */;
  201. UNLOCK TABLES;
  202. --
  203. -- Table structure for table `t_qrtz_simple_triggers`
  204. --
  205. DROP TABLE IF EXISTS `t_qrtz_simple_triggers`;
  206. /*!40101 SET @saved_cs_client = @@character_set_client */;
  207. /*!50503 SET character_set_client = utf8mb4 */;
  208. CREATE TABLE `t_qrtz_simple_triggers` (
  209. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  210. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  211. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  212. `repeat_count` bigint NOT NULL,
  213. `repeat_interval` bigint NOT NULL,
  214. `times_triggered` bigint NOT NULL,
  215. PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  216. CONSTRAINT `t_qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `t_qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
  217. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  218. /*!40101 SET character_set_client = @saved_cs_client */;
  219. --
  220. -- Dumping data for table `t_qrtz_simple_triggers`
  221. --
  222. LOCK TABLES `t_qrtz_simple_triggers` WRITE;
  223. /*!40000 ALTER TABLE `t_qrtz_simple_triggers` DISABLE KEYS */;
  224. /*!40000 ALTER TABLE `t_qrtz_simple_triggers` ENABLE KEYS */;
  225. UNLOCK TABLES;
  226. --
  227. -- Table structure for table `t_qrtz_simprop_triggers`
  228. --
  229. DROP TABLE IF EXISTS `t_qrtz_simprop_triggers`;
  230. /*!40101 SET @saved_cs_client = @@character_set_client */;
  231. /*!50503 SET character_set_client = utf8mb4 */;
  232. CREATE TABLE `t_qrtz_simprop_triggers` (
  233. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  234. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  235. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  236. `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  237. `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  238. `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  239. `int_prop_1` int DEFAULT NULL,
  240. `int_prop_2` int DEFAULT NULL,
  241. `long_prop_1` bigint DEFAULT NULL,
  242. `long_prop_2` bigint DEFAULT NULL,
  243. `dec_prop_1` decimal(13,4) DEFAULT NULL,
  244. `dec_prop_2` decimal(13,4) DEFAULT NULL,
  245. `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  246. `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  247. PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  248. CONSTRAINT `t_qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `trigger_name`, `trigger_group`) REFERENCES `t_qrtz_triggers` (`sched_name`, `trigger_name`, `trigger_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
  249. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  250. /*!40101 SET character_set_client = @saved_cs_client */;
  251. --
  252. -- Dumping data for table `t_qrtz_simprop_triggers`
  253. --
  254. LOCK TABLES `t_qrtz_simprop_triggers` WRITE;
  255. /*!40000 ALTER TABLE `t_qrtz_simprop_triggers` DISABLE KEYS */;
  256. /*!40000 ALTER TABLE `t_qrtz_simprop_triggers` ENABLE KEYS */;
  257. UNLOCK TABLES;
  258. --
  259. -- Table structure for table `t_qrtz_triggers`
  260. --
  261. DROP TABLE IF EXISTS `t_qrtz_triggers`;
  262. /*!40101 SET @saved_cs_client = @@character_set_client */;
  263. /*!50503 SET character_set_client = utf8mb4 */;
  264. CREATE TABLE `t_qrtz_triggers` (
  265. `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  266. `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  267. `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  268. `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  269. `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  270. `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  271. `next_fire_time` bigint DEFAULT NULL,
  272. `prev_fire_time` bigint DEFAULT NULL,
  273. `priority` int DEFAULT NULL,
  274. `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  275. `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  276. `start_time` bigint NOT NULL,
  277. `end_time` bigint DEFAULT NULL,
  278. `calendar_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  279. `misfire_instr` smallint DEFAULT NULL,
  280. `job_data` blob,
  281. PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
  282. KEY `idx_qrtz_t_j` (`sched_name`,`job_name`,`job_group`) USING BTREE,
  283. KEY `idx_qrtz_t_jg` (`sched_name`,`job_group`) USING BTREE,
  284. KEY `idx_qrtz_t_c` (`sched_name`,`calendar_name`) USING BTREE,
  285. KEY `idx_qrtz_t_g` (`sched_name`,`trigger_group`) USING BTREE,
  286. KEY `idx_qrtz_t_state` (`sched_name`,`trigger_state`) USING BTREE,
  287. KEY `idx_qrtz_t_n_state` (`sched_name`,`trigger_name`,`trigger_group`,`trigger_state`) USING BTREE,
  288. KEY `idx_qrtz_t_n_g_state` (`sched_name`,`trigger_group`,`trigger_state`) USING BTREE,
  289. KEY `idx_qrtz_t_next_fire_time` (`sched_name`,`next_fire_time`) USING BTREE,
  290. KEY `idx_qrtz_t_nft_st` (`sched_name`,`trigger_state`,`next_fire_time`) USING BTREE,
  291. KEY `idx_qrtz_t_nft_misfire` (`sched_name`,`misfire_instr`,`next_fire_time`) USING BTREE,
  292. KEY `idx_qrtz_t_nft_st_misfire` (`sched_name`,`misfire_instr`,`next_fire_time`,`trigger_state`) USING BTREE,
  293. KEY `idx_qrtz_t_nft_st_misfire_grp` (`sched_name`,`misfire_instr`,`next_fire_time`,`trigger_group`,`trigger_state`) USING BTREE,
  294. CONSTRAINT `t_qrtz_triggers_ibfk_1` FOREIGN KEY (`sched_name`, `job_name`, `job_group`) REFERENCES `t_qrtz_job_details` (`sched_name`, `job_name`, `job_group`) ON DELETE RESTRICT ON UPDATE RESTRICT
  295. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
  296. /*!40101 SET character_set_client = @saved_cs_client */;
  297. --
  298. -- Dumping data for table `t_qrtz_triggers`
  299. --
  300. LOCK TABLES `t_qrtz_triggers` WRITE;
  301. /*!40000 ALTER TABLE `t_qrtz_triggers` DISABLE KEYS */;
  302. /*!40000 ALTER TABLE `t_qrtz_triggers` ENABLE KEYS */;
  303. UNLOCK TABLES;
  304. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  305. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  306. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  307. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  308. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  309. -- Dump completed on 2026-06-17 14:50:30