kknongchang_2506/app/Module/GameItems/Databases/createsql/kku_item_dismantle_rules.sql

-- 表 kku_item_dismantle_rules 的创建SQL

DROP TABLE IF EXISTS `kku_item_dismantle_rules`;
CREATE TABLE `kku_item_dismantle_rules` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '规则ID，主键',
  `item_id` int DEFAULT NULL COMMENT '物品ID，外键关联kku_item_items表',
  `category_id` int DEFAULT NULL COMMENT '分类ID，外键关联kku_item_categories表',
  `min_rarity` tinyint DEFAULT '1' COMMENT '最小适用稀有度',
  `max_rarity` tinyint DEFAULT '1' COMMENT '最大适用稀有度',
  `priority` int DEFAULT '0' COMMENT '规则优先级',
  `is_active` tinyint DEFAULT '1' COMMENT '是否激活（0:否, 1:是）',
  `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_item_id` (`item_id`),
  KEY `idx_category_id` (`category_id`),
  KEY `idx_priority` (`priority`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='物品分解规则表';