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