Author: deostroll | Posted on: 11/25/2008 4:57:31 PM | Views : 800

Hi I am trying to create a mock forum. I've 3 tables - ForumUsers, ForumThreads & ForumPosts. I've created them as follows:

create table ForumUsers(
userID int identity(1,1),
userName varchar(50),
password varchar(50),
displayName varchar(50));

create table ForumThreads(
threadID int identity(1,1),
title varchar(250),
startDateTime datetime default getdate(),
startedByID int);

create table ForumPosts(
postID int identity(1,1),
threadID int,
postTitle varchar(250),
postText varchar ...

Go to the complete details ...