Gossamer Forum
Home : General : Databases and SQL :

forum's db

Quote Reply
forum's db
Does anyone know where I could find some information regarding the theory of the table structure for an online forum? Thnx!
Quote Reply
Re: [xrelux] forum's db In reply to
Don't have any references off-hand, but like any other database-based application, you want to create a flexible structure to allow many to many relations between objects, like users, posts, and forums (meaning that users can post many posts to many forums), basically using 1->M (one to many relations) throughout these objects. It's really not necessary to use many to many (M<->M) relations, since you don't want to have many forums being related to many forum categories, the forums should be organized by many forums can be in one forum category, but not the other way.

If you want to create your own forum, that's fine, but there are many forum applications out of the box, like PHPBB2, that are very flexible and customizable.
========================================
Buh Bye!

Cheers,
Me
Quote Reply
Re: [xrelux] forum's db In reply to
You could also download the free evaluation version of GForum (which powers this forum) from

http://www.gossamer-threads.com/scripts/gforum/

in order to study the table structure.

Ivan
-----
Iyengar Yoga Resources / GT Plugins