Add `profileChangedAt` column on accounts table
Closed this issue · 0 comments
vbudhram commented
Connects to https://github.com/mozilla/fxa-auth-server/issues/2490
From https://github.com/mozilla/fxa-auth-server/issues/2490#issuecomment-418524700 we need to add a profileChangedAt column on the accounts table. This column should be updated whenever we have an update to account data (non profile server stored).
Concretely, we should also update stored procedures that change account profile data to update the profileChangedAt. Ex.
- change email
- add/remove 2FA
- password change
- add secondary email
Additionally, we should also update stored procedures that return account data to return profileChangedAt.