Database Structure
 

I'm trying to plan a database structure for a custom mod. Its going to be a personal points, and this is how it will work.

Every saturday I will have a list of points that I will manually add myself. The week starts on saturday and ends on friday. I want to keep a record of points earned everyweek. For instance.

User1 has 150 points for week(1)
User1 has 125 points for week(2)
-------------------------------------------
Total Points: 275

What would be the best approach to handle the weeks orginaized?

You can make the week table auto increment.

Table Scheme: Name: points_record

userid
points_this_week
week_number

I would point total points in a separate table...perhaps the user table. Could be wrong though!

Well it really depends on how long history you want to keep. If not too much, then maybe just a serialized array in the user table would be best.

Don't serialize stuff into the database unless absolutely necessary. It defeats the purpose of using the database in the first place.

Thanks guys, I think I figured out the best way. I'll let you know how it goes. :)