kknongchang_2506/app/Module/Pet/Databases/GenerateSql/pet_battle_seasons.sql

-- ******************************************************************
-- 表 kku_pet_battle_seasons 的创建SQL
-- 对应的Model: App\Module\Pet\Models\PetBattleSeason
-- 警告: 此文件由系统自动生成，禁止修改！
-- ******************************************************************

CREATE TABLE `kku_pet_battle_seasons` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '赛季名称',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '开始时间',
  `end_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '结束时间',
  `boss_power` int(10) unsigned NOT NULL COMMENT 'Boss战力',
  `reward_pool` json NOT NULL COMMENT '奖池配置',
  `status` tinyint(3) unsigned DEFAULT '0' COMMENT '状态：0未开始，1进行中，2已结束',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_time` (`start_time`,`end_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='争霸赛赛季';