此表存储角色保存的装备套装配置信息。
| 字段名 | 类型 | 说明 | 默认值 | 示例 |
|---|---|---|---|---|
| guid | int(10) unsigned | 角色全局唯一标识符，关联characters表 | NOT NULL DEFAULT 0 | 123456 |
| setguid | bigint(20) unsigned | 套装全局唯一标识符 | NOT NULL DEFAULT 0 | 123456789 |
| setindex | tinyint(3) unsigned | 套装索引(0-19) | NOT NULL DEFAULT 0 | 1 |
| name | varchar(31) | 套装名称 | '' | "PVP套装" |
| iconname | varchar(100) | 套装图标名称 | '' | "Ability_Warrior_BattleShout" |
| ignore_mask | int(11) unsigned | 忽略掩码 | 0 | 0 |
| item0 | int(10) unsigned | 头部装备 | 0 | 12345 |
| item1 | int(10) unsigned | 颈部装备 | 0 | 12346 |
| item2 | int(10) unsigned | 肩部装备 | 0 | 12347 |
| item3 | int(10) unsigned | 胸部装备 | 0 | 12348 |
| item4 | int(10) unsigned | 腰部装备 | 0 | 12349 |
| item5 | int(10) unsigned | 腿部装备 | 0 | 12350 |
| item6 | int(10) unsigned | 脚部装备 | 0 | 12351 |
| item7 | int(10) unsigned | 手腕装备 | 0 | 12352 |
| item8 | int(10) unsigned | 手部装备 | 0 | 12353 |
| item9 | int(10) unsigned | 手指1装备 | 0 | 12354 |
| item10 | int(10) unsigned | 手指2装备 | 0 | 12355 |
| item11 | int(10) unsigned | 饰品1装备 | 0 | 12356 |
| item12 | int(10) unsigned | 饰品2装备 | 0 | 12357 |
| item13 | int(10) unsigned | 背部装备 | 0 | 12358 |
| item14 | int(10) unsigned | 主手装备 | 0 | 12359 |
| item15 | int(10) unsigned | 副手装备 | 0 | 12360 |
| item16 | int(10) unsigned | 远程武器 | 0 | 12361 |
| item17 | int(10) unsigned | 战袍 | 0 | 12362 |
| item18 | int(10) unsigned | 衬衣 | 0 | 12363 |
-- 查询角色所有装备套装
SELECT * FROM character_equipmentsets WHERE guid = 12345;
-- 删除特定装备套装
DELETE FROM character_equipmentsets
WHERE guid = 12345 AND setguid = 1;
-- 更新套装名称
UPDATE character_equipmentsets
SET name = '新套装名称'
WHERE guid = 12345 AND setguid = 1;