-----------
Thread table:
-----------
id (int - primary key)
forumid (int)
lastupdate (datetime)
postcount (int)
-----------
Post table:
-----------
id (int - primary key)
threadid (int)
username (varchar)
userip (int)
postdate (int)
postcontent (text)
--------------------------------------
Thread query for front page (SQL-ish):
--------------------------------------
SELECT * FROM threads WHERE (forumid = X) LIMIT TO 10 ORDER BY lastupdate DESC
------------------------
Thread query for thread:
------------------------
SELECT * FROM posts WHERE (threadid = X) ORDER BY postdate DESC