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.
22 regels
948 B
22 regels
948 B
-- liushl
|
|
CREATE TABLE `client_event_data`(
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家ID',
|
|
`event_id` smallint(11) unsigned NOT NULL DEFAULT '0' COMMENT '事件id##由前端自定义，一般是从1递增',
|
|
`state` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '事件状态',
|
|
PRIMARY KEY(`role_id`, `event_id`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="前端终身事件列表(合服保留)";
|
|
|
|
-- jiangxun
|
|
-- 魂力升级时间升级改为物品升级
|
|
ALTER TABLE `role_uranium`
|
|
DROP COLUMN `init_time`,
|
|
DROP COLUMN `start_time`,
|
|
DROP COLUMN `quick_time`,
|
|
ADD COLUMN `have_energy` int(11) ZEROFILL NOT NULL COMMENT '玩家当前等级持有的能量' AFTER `lv`;
|
|
|
|
-- tyl
|
|
-- 七日目标调整
|
|
truncate table seven_day_task;
|
|
truncate table seven_days_goal;
|
|
alter table seven_day_task drop column `diff`;
|
|
alter table seven_day_task drop PRIMARY KEY, add PRIMARY KEY (`role_id`,`days`,`mod_id`,`sub_id`);
|