Update date when cancelling a transaction

[lebobar]

Just to have it at the top of the history, and leave the original date in the comment.

Name: Manou
Email: manou@gmail.com

[matthieu-gendreau]

Why is there three timestamp columns in transactions ?
last_update created_at updated_at

[matthieu-gendreau]

I suggest that we use updated_at to sort and display on the account page
Then eventually in the comment use created_at or do a popover to display this information
I would advise against hardcoding information in the comment (if possible)

[tdeo]

There's only date: https://github.com/bobar/tdfb/blob/master/db/schema.rb#L67

[matthieu-gendreau]

I was looking at the wrong database...
What about having a created_at and a updated_at?

[tdeo]

We still have an issue of retro-compatibility.

[matthieu-gendreau]

What about we decide that the current date is the updated_at and we create a new column created_at ?

On the old TDB we cannot cancel transactions so no problem
And I guess if we log something the created_at column should be filled by mysql?

On the new we can put an alias date -> updated_at
When a transaction is cancelled you update updated_at and do not change created_at

Would it work ?