so we have a table
1, 5, 2, 'thisisatest'
we have a table
1, pending processing
2, payment accepted
for each of the order states of an order, i must save a date as of when the state was performed. The order can only be in one state at a time.
say we have an order that gets put into
payment accepted state. Now I have to save a date/time along with it.
what is the cleanest / best way of doing that?