Use timestamps instead of booleans

[DrumsnChocolate]

https://www.youtube.com/watch?v=G5_DLef7_9E worth a watch. Not sure if useful for us so let's discuss that here. I think we already do this in many places, my main question is: are there more places where this can be applied?

[wilco375]

You can take a look at https://github.com/csvalpha/amber-api/blob/staging/db/schema.rb to see where we're using booleans in the database. I have not watched the video, but we also track changes using the paper_trail gem we're using. All model mutations are stored in the versions table.

[lodewiges]

Good suggestion, I have looked through schema.rb we could consider: groups/administrative, mail_aliases/smtp_enabled & articles/pinned
to be converted to a timestamp. I don't think it is useful to change any of the other booleans