Table Structure and date question

[SilentDeath]

Hello,

 

I plan on running a contest of sorts and I would like to know how to best count the amount of points accumulated in a day. At the moment i just have a setup with id | name |  points. Would I have to create a new column for each day or something like that?

 

Any help would be much appreciated. Thanks.

[Hybride]

I would have two tables at that point, something like:

 

The points table:

P_ID | P_DATE | P_POINTS

 

The user table:

U_ID | U_USERNAME

 

where U_ID -> P_ID and every day a new row is inserted (would probably be a cron job) in the points table with the points accumulated for the day.