failed_jobs.sql 1.3 KB

123456789101112131415161718192021222324252627282930313233343536
  1. /*
  2. Navicat Premium Data Transfer
  3. Source Server : 101.43.185.169
  4. Source Server Type : MySQL
  5. Source Server Version : 80024 (8.0.24)
  6. Source Host : localhost:3306
  7. Source Schema : panda_admin_v1
  8. Target Server Type : MySQL
  9. Target Server Version : 80024 (8.0.24)
  10. File Encoding : 65001
  11. Date: 11/01/2024 21:17:03
  12. */
  13. SET NAMES utf8mb4;
  14. SET FOREIGN_KEY_CHECKS = 0;
  15. -- ----------------------------
  16. -- Table structure for failed_jobs
  17. -- ----------------------------
  18. DROP TABLE IF EXISTS `failed_jobs`;
  19. CREATE TABLE `failed_jobs` (
  20. `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT,
  21. `uuid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  22. `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  23. `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  24. `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  25. `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  26. `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  27. PRIMARY KEY (`id`) USING BTREE,
  28. UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid` ASC) USING BTREE
  29. ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '【队列】任务列表' ROW_FORMAT = Dynamic;
  30. SET FOREIGN_KEY_CHECKS = 1;