What tables are affected when a thread is moved?
 

Hi,

I have to move a slew of threads based on a specific term. I do NOT want to leave a redirect. I prefer to do this via the database.

What tables / columns are affected when a thread is moved?

Thanks!
Kim

at least the thread table (forumid, prefixid, if appropriate), user table (posts, if appropriate), forum table (lastpost, lastposter, lastposterid, lastpostid, lastthread, lastthreadid, lastprefixid, threadcount, etc), datastore (forumcache? - serialized data!), forumprefixset (if appropriate)

could be others, but I would try to remove them using the software, not via the database.

@Lynne, is there a way to "manage" all "Moved" notices that were left with a permanent redirect, rather than clicking each one? Where is this info stored in the database? I have been manually clicking the "manage" link to set them to expire in an hour, but I have way way way too many that were merged to realistically do this manually. Thanks for your help Lynne!

No, there is not a way to mass Remove Redirects. That is an option only when in the thread.

Redirects are in the threadredirect table.