kknongchang_2506/app/Module/Game/Databases/GenerateSql/game_condition_items.sql

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

CREATE TABLE `kku_game_condition_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `group_id` int unsigned NOT NULL COMMENT '条件组ID，外键关联game_condition_groups表',
  `condition_type` tinyint unsigned NOT NULL COMMENT '条件类型（1:土地等级, 2:房屋等级, 3:宠物等级, 4:物品持有数, 5:代币持有数）',
  `target_id` int unsigned NOT NULL DEFAULT '0' COMMENT '目标ID（土地类型ID、宠物ID、物品ID、代币ID等，根据condition_type解释）',
  `operator` tinyint unsigned NOT NULL COMMENT '比较运算符（1:等于, 2:不等于, 3:大于, 4:大于等于, 5:小于, 6:小于等于）',
  `value` int NOT NULL COMMENT '比较值',
  `param1` int NOT NULL DEFAULT '0' COMMENT '参数1（根据condition_type不同含义）',
  `param2` int NOT NULL DEFAULT '0' COMMENT '参数2（根据condition_type不同含义）',
  `extra_data` json DEFAULT NULL COMMENT '额外数据（JSON格式，可存储特定条件类型的额外参数）',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `game_condition_items_group_id_foreign` (`group_id`),
  CONSTRAINT `game_condition_items_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `kku_game_condition_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='条件项';