Nelze vybrat více než 25 témat
Téma musí začínat písmenem nebo číslem, může obsahovat pomlčky („-“) a může být dlouhé až 35 znaků.
72 řádky
3.8 KiB
72 řádky
3.8 KiB
-- zmh 社团派单
|
|
DROP TABLE if exists `guild_order`;
|
|
CREATE TABLE `guild_order` (
|
|
`id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '订单id',
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
|
|
`cfgid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '配置',
|
|
`status` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
|
|
`content` varchar(500) NOT NULL DEFAULT '{}' COMMENT '任务内容',
|
|
`teams` varchar(500) NOT NULL DEFAULT '{}' COMMENT '拼单人',
|
|
`finish_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '完成时间',
|
|
PRIMARY KEY (`id`,`rid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='社团派单-合服合并';
|
|
|
|
|
|
-- zmh 通用封榜相关
|
|
CREATE TABLE `vie_rank` (
|
|
`act` int(11) unsigned DEFAULT '0' COMMENT '活动',
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
|
|
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家名字',
|
|
`server_id` int(11) unsigned DEFAULT '0' COMMENT '服务器ID',
|
|
`server_num` int(11) DEFAULT '0' COMMENT '服务器Num',
|
|
`vip` int(11) unsigned DEFAULT '0' COMMENT 'vip',
|
|
`svip` int(11) DEFAULT '0' COMMENT 'vip至尊',
|
|
`score` int(11) unsigned DEFAULT '0' COMMENT '积分',
|
|
`rtime` int(11) DEFAULT '0' COMMENT '数据更新时间',
|
|
`dtime` int(11) DEFAULT '0' COMMENT '数据有效时间',
|
|
PRIMARY KEY (`act`,`rid`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='封榜合服保留';
|
|
|
|
|
|
CREATE TABLE `log_local_vie_rank` (
|
|
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
`act` int(11) unsigned NOT NULL COMMENT '活动Id',
|
|
`zone` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区Id',
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '角色名字',
|
|
`server_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '服务器Id(后台唯一服号)',
|
|
`server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器编号(玩家可见的服编号)',
|
|
`score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
|
|
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排名',
|
|
`rtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '时间戳',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '日志时间戳',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='封榜活动本地日志';
|
|
|
|
|
|
CREATE TABLE `log_vie_rank` (
|
|
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
`act` int(11) unsigned NOT NULL COMMENT '活动Id',
|
|
`zone` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区Id',
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '角色名字',
|
|
`server_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '服务器Id(后台唯一服号)',
|
|
`server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器编号(玩家可见的服编号)',
|
|
`score` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '积分',
|
|
`rank` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '排名',
|
|
`rtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '时间戳',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '日志时间戳',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='封榜活动跨服日志';
|
|
|
|
|
|
CREATE TABLE `log_vie_score` (
|
|
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '编号',
|
|
`act` int(11) unsigned NOT NULL COMMENT '活动Id',
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '角色名字',
|
|
`score_add` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '获得积分',
|
|
`score_all` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '总积分',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '日志时间戳',
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='封榜积分获得日志';
|