corrupshun Posted February 4, 2010 Share Posted February 4, 2010 If not, please tell me ways to improve Thanks! ---Forum--- >>Users ....UserID ....Username ....Date ....IP ....Email ....Password ....Level ....Posts ....Avatar >>Forums ....ForumID ....Forum ....ForumInfo ....ForumSubject ....ForumTopics ....ForumPosts >>Topics ....Username ....TopicID ....Topic ....TopicViews ....TopicReplies ....InForum >>Posts ....Username ....PostID ....Post ....PostDate ....InForum ....InTopic Quote Link to comment Share on other sites More sharing options...
roopurt18 Posted February 4, 2010 Share Posted February 4, 2010 I don't understand the meaning of Date or IP in the users table. You don't need separate forums and topics tables. Just one table, called Topics, would suffice. This would be a hierarchical table where topics can contain any number of sub-topics. Any topic without a parent is effectively a board. There is a good article on the MySQL website about hierarchical data organization; a google search should turn it up. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.