storing account history table in mysql
I want to insert a table like this into a mysql table and it is sort of like the account history of a user. I want to have it stored so that it can be echoed back to the user when they take a look at their account history.
Would it be best to create a column for Ticket#, Date,Type ,and Result? I also want to have it ordered by the most recent date.