I just wanted to relocate (sorry if I dont hit teh exact term, because I user german language) some postings from one forum to another forum (functionality provided by role of forum moderator?) with sql update query.

Now I have a very basic question:
Is it really necessary to hold the forum_id in table bb_topics and bb_posts? This makes updates with sql very akward, because for relocating a posting, I have to update 2 keys. To update forum_id in bb_topics should be enough (if I need to know how many posts I have in a certain forum, I can query from bb_posts with a join over bb-topics to bb_forum)?

Is it possible to "read" the function for "relocation of posts" in "post-options"? Maybe I can get my update sql by reading this function?

Some more questions:
Where can I post database related questions:
- sql syntax for updates, subselects
- Database schene of XOOPS
- Tools for reading database scheme from flatfile
- admin toole better than phpadmin (more like Oracle PL/SQL Developer if there are any)
- Projects for running XOOPS on other online databases like postgresql, maxdb and ...?

Curious to get some database related infos

Best regards asche