-- 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