Database design tip: instead of a boolean column, use a nullable timestamp. This way you get your boolean value, plus the time when you set it.