You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 regels
1.0 KiB
17 regels
1.0 KiB
-- tyl
|
|
-- 废土战场
|
|
CREATE TABLE `wasteland_war` (
|
|
`server_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器Id',
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`role_name` varchar(255) NOT NULL DEFAULT '' COMMENT '角色名称',
|
|
`round` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '轮数',
|
|
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排行',
|
|
`score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
|
|
`kill_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最大击杀数',
|
|
`max_combo` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '最大连杀数',
|
|
`sex` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
|
|
`vip_lv` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'vip等级',
|
|
`sup_vip` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '贵族',
|
|
`server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器号',
|
|
PRIMARY KEY (`server_id`,`role_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='废土战场-排行榜数据';
|