In domergeuser2.php , the merge user script only update these tables :
ubbt_USER_PROFILE
ubbt_TOPICS
ubbt_POSTS
ubbt_FILES
ubbt_POLL_DATA
ubbt_PRIVATE_MESSAGE_TOPICS
ubbt_PRIVATE_MESSAGE_POSTS
ubbt_PRIVATE_MESSAGE_USERS
ubbt_SHOUT_BOX
delete :
ubbt_USERS
ubbt_USER_PROFILE
ubbt_USER_DATA
ubbt_USER_GROUPS
ubbt_FORUM_LAST_VISIT
But there are other tables that contains USER_ID that is not cleaned / modified , such as :
ubbt_BANNED_USERS (delete ?)
ubbt_CALENDAR_EVENTS (delete ?)
ubbt_MODERATORS (delete ?)
ubbt_RATINGS where RATING_TYPE = 'u' (delete ?)
ubbt_WATCH_LISTS where WATCH_TYPE = 'u' (delete ?)
... (maybe there're still others missed here)
Is it ok to leave these 'zombie' data ?
When migrating to 8.0 , will there be a 'clean-up' script that scans the whole integrity of the db ?
