job_batches.sql 932 B

12345678910111213141516171819
  1. -- ******************************************************************
  2. -- 表 kku_job_batches 的创建SQL
  3. -- 对应的Model: App\Module\System\Models\JobBatch
  4. -- 警告: 此文件由系统自动生成,禁止修改!
  5. -- ******************************************************************
  6. CREATE TABLE `kku_job_batches` (
  7. `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  8. `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  9. `total_jobs` int NOT NULL,
  10. `pending_jobs` int NOT NULL,
  11. `failed_jobs` int NOT NULL,
  12. `failed_job_ids` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  13. `options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  14. `cancelled_at` int DEFAULT NULL,
  15. `created_at` int NOT NULL,
  16. `finished_at` int DEFAULT NULL,
  17. PRIMARY KEY (`id`) USING BTREE
  18. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;