用于在PHP中存储时间戳的数据库结构

Question

I have a website, in that i start time after user login, and when i stop the timer I save this time in database, And i have two tables

login 
----------------------
id | username | password 

table 
---------------------------------------------
user_id(referenced by id) | t_id | date | time

So, With this database structure i got multiple entry in database when i logout, So plz tell me about proper database structure for storing the time datewise and for one date only one entry allowed.

If there are any suggesion for re-design database structure then plz suggest me.

i want to merge the time in database, when i logout the multiple time in single day...

Answer 1

table 
---------------------------------------------
user_id(referenced by id) | login_date (datetime field) | logout_date (datetime field)