qrtz_locks.sql 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 测试mysql
  4. Source Server Type : MySQL
  5. Source Server Version : 80403
  6. Source Host : 192.168.110.241:3306
  7. Source Schema : national-motion
  8. Target Server Type : MySQL
  9. Target Server Version : 80403
  10. File Encoding : 65001
  11. Date: 01/07/2025 11:28:22
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for qrtz_locks
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `qrtz_locks`;
  19. CREATE TABLE `qrtz_locks` (
  20. `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  21. `LOCK_NAME` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  22. PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
  23. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;
  24. -- ----------------------------
  25. -- Records of qrtz_locks
  26. -- ----------------------------
  27. INSERT INTO `qrtz_locks` VALUES ('MyScheduler', 'STATE_ACCESS');
  28. INSERT INTO `qrtz_locks` VALUES ('MyScheduler', 'TRIGGER_ACCESS');
  29. SET FOREIGN_KEY_CHECKS = 1;