25개 이상의 토픽을 선택하실 수 없습니다.
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
40 lines
2.3 KiB
40 lines
2.3 KiB
-- liushl
|
|
ALTER TABLE log_custom_act_reward ADD COLUMN `bgold_before` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '领奖前红钻' AFTER gold_after;
|
|
ALTER TABLE log_custom_act_reward ADD COLUMN `bgold_after` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '领奖后红钻' AFTER bgold_before;
|
|
|
|
-- tyl 源樱之礼
|
|
CREATE TABLE `sakura_person_log` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
|
|
`sub_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '活动子类型',
|
|
`id` int(11) unsigned NOT NULL COMMENT 'id',
|
|
`reward` varchar(255) NOT NULL DEFAULT '[]' COMMENT '奖励',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '记录时间',
|
|
PRIMARY KEY (`role_id`,`sub_type`,`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='源樱之礼-个人记录';
|
|
|
|
CREATE TABLE `sakura_server_log` (
|
|
`sub_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '活动子类型',
|
|
`id` int(11) unsigned NOT NULL COMMENT 'id',
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
|
|
`reward` varchar(255) NOT NULL DEFAULT '[]' COMMENT '奖励',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '记录时间',
|
|
PRIMARY KEY (`sub_type`,`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='源樱之礼-全服记录';
|
|
|
|
CREATE TABLE `sakura_store` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
|
|
`sub_type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '活动子id',
|
|
`reward_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '奖励id',
|
|
`times` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '兑换次数',
|
|
PRIMARY KEY (`role_id`,`sub_type`,`reward_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='源樱之礼-积分商城';
|
|
|
|
-- liushl
|
|
CREATE TABLE `role_equipment_task` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
|
|
`task_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '任务Id',
|
|
`progress` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '任务进度',
|
|
`status` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '任务状态',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
|
|
PRIMARY KEY (`role_id`, `task_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家装备任务(合服保留)';
|