XenForo developer

There are tens of tables and many columns that need to be updated. You can look into the merge user code to get an idea of the process, but it's really not something that is automatically fool proof or potentially even 100% (particularly with add-ons). Attempting to manually change a user ID definitely isn't something we'd recommend.