Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hari4u6
Starting Member
12 Posts |
 Posted - 2009-12-16 : 04:50:12
|
| Hello, I'm developing an robust forum application similar to sqlteam. I've started with the database. I feel there should be ForumTopicTable,ForumPostTable,UserTableForumTopicTable----- TopicId,TopicName,Description,CreatedDate,CreatedBy,IsActiveForumPostTable--- PostId,TopicId,UserId,Description,PostedDate..I'm stuck with the ForumPostTableas what should be the fields and where the replies must be stored. Hari. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-12-16 : 04:53:13
|
| Here you can store your replies on ForumPostTableTopicId,UserId,DescriptionSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
hari4u6
Starting Member
12 Posts |
Posted - 2009-12-16 : 06:30:03
|
| Hello senthil, Thanks for the reply, Should I need to maintain a table for replies as well. Hari. |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-12-16 : 06:33:51
|
| Welcome :)Ya ofcourse!Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
hari4u6
Starting Member
12 Posts |
Posted - 2009-12-16 : 06:40:20
|
| Thank you. So these three tables will handle all the features of the Forum application..ForumTopic table, ForumThreadForum ReplyHari. |
|
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-12-16 : 06:42:38
|
| Ya enough. Expecting Your forum soon on online!!! :)Senthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
|
|
|
|
|
|
|
|
Database for forum application