The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Any links?
Tutorials on basic database design will be ignored.
Any links?
Tutorials on basic database design will be ignored.
I'm pretty sure Grix was programming a forum, if you could get hold of him he could point you in the direction of some tuts.
[URL]http://www.spoono.com/[/URL] << I think thats the correct addy for a site with a tut.
Tutorials I can get. I specifically needed a structure.
Thanks anyway.
Each post is linked to a thread. I also cheated slightly to save effort by storing the last post date and last post author in the thread table - saves looking up in two tables.
Boards
{
BoardID
BoardName
BoardDescription
PostNo
*LastUserID
LastDateTime
}
Threads
{
ThreadID
*BoardID
ThreadName
Locked
Sticky
*StartUserID
StartDateTime
*LastUserID
LastDateTime
}
Posts
{
PostID
*ThreadID
*UserID
PostContents
PostDateTime
}
Users
{
UserID
UserName
Password
First Name
Surname
DOB
etc
}
Think I've got most of the important stuff.
The stuff in Italics is optional but would be used to speed stuff up a bit as it wouldn't be needed to be calculated on the fly.