yzySrv/db/20-11/20-11-03.sql

-- hh
-- 时装套装

CREATE TABLE `role_fashion_suit`(
    `role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
    `suit_id` int(11) UNSIGNED NOT NULL COMMENT '套装id',
    `suit_list` varchar(1000) NOT NULL DEFAULT '[]' COMMENT '套装数据',
    `active` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已激活',
    PRIMARY KEY(`role_id`, `suit_id`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="时装套装数据";