Much apologies. I was thinking of using that method, after rethinking it a bit i am considering using the structure.

uid varchar(255)  #uid from ldap
date date         #date
time time         #time
stat enum()       #transaction type
[download]

This way when i want to do reporting i can pull the dates seperately from the times, and do the math of the times.