Creating a user generated content website

[lordg]

I'm planning to create a community site (in PHP and MySQL) where people can post some sort of helpful information. I want to include features that would allow people to rate this information and post comments about it. I would also like to make this information searchable, so I want to include tags. To help you understand it better, the website is sort of like digg.com or engadget.com or any other website that have content and comments on it. Sort of like a blog site.

I already finished creating the login system. Now I need to work on the content posting system. I already thought about the SQL table to
store this content. Here's what I have so far:

ContentID, User, Title, ContentText, DatePosted, NumOfComments, Rating, Tags

For the comments, I would assume the SQL table would look like this:

ContentID, User, CommentNumber, CommentText

Now, am I on the right track here? This is my first time creating something like this. Are there free scripts out there that does the same thing?

Any help is appreciated.

[eelixduppy]

>>>Are there free scripts out there that does the same thing?

There are definitely free scripts out there. Check out the following:
[opensourcecms.com...]
SourceForge [sourceforge.net]

Best of luck!