Ticket #378 (new 需求) — at Version 3

Opened 10 years ago

Last modified 10 years ago

亲子宝典和快乐妈咪论坛数据合并

Reported by: huangping Owned by: qinhongyuan
Priority: 最高级(1) Milestone:
Component: 亲子网论坛 Version: 亲子论坛BBS7.4
Keywords: Cc:
Due Date: 19/04/2016

Description (last modified by huangping) (diff)

因亲子宝典和快乐妈咪同一个手机号对应两个passport,从而造成要合并用户数据

用户合并包含主题合并和回帖合并
1、主题合并

1.1 topic表的作者id(authorid)修改
1.2 user_topic表,关系表,因有分表,所以如果新用户和旧用户的id分表不在同一张表,则要迁移这条数据,同时修改用户id(uid)
1.3 user表,主题数(topicount)、精华数(pickcount)修改
1.4 主楼合并
1.4.1 post表,作者id(uid)修改
1.4.2 user_post表,关系表,同user_topic表,操作
1.4.3 user:发帖数(postcount)

2、回帖合并

2.1同主题合并的主楼合并操作一样

合并操作完成,检查上面表相关数据是否迁移正确,以前检查如个人中心我的回帖、主帖等等展示是否正常

Change History

comment:1 Changed 10 years ago by huangping

  • Description modified (diff)

comment:2 Changed 10 years ago by huangping

  • Description modified (diff)

comment:3 Changed 10 years ago by huangping

  • Description modified (diff)
Note: See TracTickets for help on using tickets.