| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355 |
- -- MySQL dump 10.13 Distrib 8.0.46, for Linux (x86_64)
- --
- -- Host: localhost Database: quartz
- -- ------------------------------------------------------
- -- Server version 8.0.46
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40103 SET TIME_ZONE='+00:00' */;
- /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
- --
- -- Table structure for table `t_qrtz_blob_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_blob_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_blob_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `blob_data` blob,
- PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- KEY `sched_name` (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_blob_triggers`
- --
- LOCK TABLES `t_qrtz_blob_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_blob_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_blob_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_calendars`
- --
- DROP TABLE IF EXISTS `t_qrtz_calendars`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_calendars` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `calendar_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `calendar` blob NOT NULL,
- PRIMARY KEY (`sched_name`,`calendar_name`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_calendars`
- --
- LOCK TABLES `t_qrtz_calendars` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_calendars` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_calendars` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_cron_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_cron_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_cron_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `cron_expression` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_cron_triggers`
- --
- LOCK TABLES `t_qrtz_cron_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_cron_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_cron_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_fired_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_fired_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_fired_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `instance_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `fired_time` bigint NOT NULL,
- `sched_time` bigint NOT NULL,
- `priority` int NOT NULL,
- `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- PRIMARY KEY (`sched_name`,`entry_id`) USING BTREE,
- KEY `idx_qrtz_ft_trig_inst_name` (`sched_name`,`instance_name`) USING BTREE,
- KEY `idx_qrtz_ft_inst_job_req_rcvry` (`sched_name`,`instance_name`,`requests_recovery`) USING BTREE,
- KEY `idx_qrtz_ft_j_g` (`sched_name`,`job_name`,`job_group`) USING BTREE,
- KEY `idx_qrtz_ft_jg` (`sched_name`,`job_group`) USING BTREE,
- KEY `idx_qrtz_ft_t_g` (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- KEY `idx_qrtz_ft_tg` (`sched_name`,`trigger_group`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_fired_triggers`
- --
- LOCK TABLES `t_qrtz_fired_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_fired_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_fired_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_job_details`
- --
- DROP TABLE IF EXISTS `t_qrtz_job_details`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_job_details` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_data` blob,
- PRIMARY KEY (`sched_name`,`job_name`,`job_group`) USING BTREE,
- KEY `idx_qrtz_j_req_recovery` (`sched_name`,`requests_recovery`) USING BTREE,
- KEY `idx_qrtz_j_grp` (`sched_name`,`job_group`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_job_details`
- --
- LOCK TABLES `t_qrtz_job_details` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_job_details` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_job_details` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_locks`
- --
- DROP TABLE IF EXISTS `t_qrtz_locks`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_locks` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- PRIMARY KEY (`sched_name`,`lock_name`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_locks`
- --
- LOCK TABLES `t_qrtz_locks` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_locks` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_locks` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_paused_trigger_grps`
- --
- DROP TABLE IF EXISTS `t_qrtz_paused_trigger_grps`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_paused_trigger_grps` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- PRIMARY KEY (`sched_name`,`trigger_group`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_paused_trigger_grps`
- --
- LOCK TABLES `t_qrtz_paused_trigger_grps` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_paused_trigger_grps` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_paused_trigger_grps` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_scheduler_state`
- --
- DROP TABLE IF EXISTS `t_qrtz_scheduler_state`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_scheduler_state` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `instance_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `last_checkin_time` bigint NOT NULL,
- `checkin_interval` bigint NOT NULL,
- PRIMARY KEY (`sched_name`,`instance_name`) USING BTREE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_scheduler_state`
- --
- LOCK TABLES `t_qrtz_scheduler_state` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_scheduler_state` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_scheduler_state` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_simple_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_simple_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_simple_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci 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`) USING BTREE,
- 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_simple_triggers`
- --
- LOCK TABLES `t_qrtz_simple_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_simple_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_simple_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_simprop_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_simprop_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_simprop_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `int_prop_1` int DEFAULT NULL,
- `int_prop_2` int DEFAULT NULL,
- `long_prop_1` bigint DEFAULT NULL,
- `long_prop_2` bigint DEFAULT NULL,
- `dec_prop_1` decimal(13,4) DEFAULT NULL,
- `dec_prop_2` decimal(13,4) DEFAULT NULL,
- `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_simprop_triggers`
- --
- LOCK TABLES `t_qrtz_simprop_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_simprop_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_simprop_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `t_qrtz_triggers`
- --
- DROP TABLE IF EXISTS `t_qrtz_triggers`;
- /*!40101 SET @saved_cs_client = @@character_set_client */;
- /*!50503 SET character_set_client = utf8mb4 */;
- CREATE TABLE `t_qrtz_triggers` (
- `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `job_group` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `next_fire_time` bigint DEFAULT NULL,
- `prev_fire_time` bigint DEFAULT NULL,
- `priority` int DEFAULT NULL,
- `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
- `start_time` bigint NOT NULL,
- `end_time` bigint DEFAULT NULL,
- `calendar_name` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
- `misfire_instr` smallint DEFAULT NULL,
- `job_data` blob,
- PRIMARY KEY (`sched_name`,`trigger_name`,`trigger_group`) USING BTREE,
- KEY `idx_qrtz_t_j` (`sched_name`,`job_name`,`job_group`) USING BTREE,
- KEY `idx_qrtz_t_jg` (`sched_name`,`job_group`) USING BTREE,
- KEY `idx_qrtz_t_c` (`sched_name`,`calendar_name`) USING BTREE,
- KEY `idx_qrtz_t_g` (`sched_name`,`trigger_group`) USING BTREE,
- KEY `idx_qrtz_t_state` (`sched_name`,`trigger_state`) USING BTREE,
- KEY `idx_qrtz_t_n_state` (`sched_name`,`trigger_name`,`trigger_group`,`trigger_state`) USING BTREE,
- KEY `idx_qrtz_t_n_g_state` (`sched_name`,`trigger_group`,`trigger_state`) USING BTREE,
- KEY `idx_qrtz_t_next_fire_time` (`sched_name`,`next_fire_time`) USING BTREE,
- KEY `idx_qrtz_t_nft_st` (`sched_name`,`trigger_state`,`next_fire_time`) USING BTREE,
- KEY `idx_qrtz_t_nft_misfire` (`sched_name`,`misfire_instr`,`next_fire_time`) USING BTREE,
- KEY `idx_qrtz_t_nft_st_misfire` (`sched_name`,`misfire_instr`,`next_fire_time`,`trigger_state`) USING BTREE,
- KEY `idx_qrtz_t_nft_st_misfire_grp` (`sched_name`,`misfire_instr`,`next_fire_time`,`trigger_group`,`trigger_state`) USING BTREE,
- 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
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;
- /*!40101 SET character_set_client = @saved_cs_client */;
- --
- -- Dumping data for table `t_qrtz_triggers`
- --
- LOCK TABLES `t_qrtz_triggers` WRITE;
- /*!40000 ALTER TABLE `t_qrtz_triggers` DISABLE KEYS */;
- /*!40000 ALTER TABLE `t_qrtz_triggers` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
- -- Dump completed on 2026-06-17 14:50:30
|