-- tyl
|
|
-- 扭蛋次数奖励
|
|
CREATE TABLE IF NOT EXISTS `capsule_egg_times_reward` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`pool_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '奖池类型',
|
|
`draw_times` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '抽奖次数',
|
|
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '奖励领取状态 1-已领取',
|
|
PRIMARY KEY (`role_id`,`pool_type`,`draw_times`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='龙神宝库-次数奖励表';
|