Your first table layout is horrible, the second one is only marginally
better. You should read up on database normalization.
I have no idea what id, id2 and type are but since they seem like they
are the same for every 'f' and every day, I am pretty sure they all
relate directly to the user s
Not only should you definitely have one record per day, instead of one record
per month, you should think about normalizing your structure further. Try
these articles for tips on how to design a database structure:
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html and
ht
