jobs.sql 862 B

1234567891011121314151617
  1. -- ******************************************************************
  2. -- 表 kku_jobs 的创建SQL
  3. -- 对应的Model: App\Module\System\Models\Job
  4. -- 警告: 此文件由系统自动生成,禁止修改!
  5. -- ******************************************************************
  6. CREATE TABLE `kku_jobs` (
  7. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  8. `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  9. `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  10. `attempts` tinyint(3) unsigned NOT NULL,
  11. `reserved_at` int(10) unsigned DEFAULT NULL,
  12. `available_at` int(10) unsigned NOT NULL,
  13. `created_at` int(10) unsigned NOT NULL,
  14. PRIMARY KEY (`id`) USING BTREE,
  15. KEY `jobs_queue_index` (`queue`) USING BTREE
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;