-- hh
|
|
-- 日志字段修改
|
|
ALTER TABLE `log_common_rank_role` MODIFY COLUMN `value` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '值' AFTER `rank`;
|
|
|
|
-- 藏宝图限时商品信息
|
|
CREATE TABLE `role_treasure_map_shop_info`(
|
|
`role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
|
|
`time` int(11) UNSIGNED NOT NULL COMMENT '过期时间',
|
|
`limit_shops` varchar(500) NOT NULL DEFAULT '[]' COMMENT '限时商品信息',
|
|
PRIMARY KEY(`role_id`, `time`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="藏宝图珍宝商品信息";
|