yzySrv/db/20-10/20-10-30.sql

-- hh
-- 排行榜点赞数据保存

CREATE TABLE `role_praise_target`(
    `role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
    `rank_type` int(11) UNSIGNED NOT NULL COMMENT '排行类型',
    `praise_id` bigint(20) UNSIGNED NOT NULL COMMENT '点赞玩家',
    `time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '点赞时间',
    PRIMARY KEY(`role_id`, `rank_type`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="排行榜点赞数据";