What tables are affected when a thread is moved?

[nchoose]

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

[Lynne]

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.

[nchoose]

@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!

[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.