DB structure for a forum?

[Wollington]

Hi,

I'm thinking of writing a forum in asp soon.
I was just wondering what sort of structure the db/dbs should have.

I'd thought of maybe a seperate db for each forum, then a new table for each new post then the the replies are the rows in the tables.

Is this a hell of a waste of space/resources?

How would you do it?

Thanks

------------------
Microsoft has acknowledged that its engineers substituted certain file names with the phrase, "Netscape engineers are weenies," in some of its internet software.

Oh well now we all know why Nutscrape is so crap!

[Grizzly]

Yeah that approach would be a pretty wasteful on both space and system resources.

I've designed a few messageboards of my own, and they almost always boil down to 3 simple tables.

I made a quick little PDF document to illustrate what I mean.

Note:
Primary Key's are in RED.
And I drew some relational arrows so you can more easily see how the tables should be joined on Queries.

http://grizz.dhs.org/ForumsDB.pdf

[Wollington]

Thanks!
http://www.sharkyforums.com/ubb/smile.gif


------------------
Microsoft has acknowledged that its engineers substituted certain file names with the phrase, "Netscape engineers are weenies," in some of its internet software.

Oh well now we all know why Nutscrape is so crap!