Accountability

[rugulous]

We need to log when certain actions are taken, and who has done them

• [ ] User's admin status is changed
• [ ] User is made active/inactive
• [ ] User is added/removed as band contact
• [x] User is created/changed
• [x] Organisation is created/changed
• [ ] Membership is created/changed
• [ ] Event is created/changed

This is essentially giving each entity a CreatedBy/LastModifiedBy attribute (plus date/time), as well as logging a few extra key actions

[rugulous]

This may seem like a good use case for Sequelize's hooks, but unfortunately I don't think it will be that simple.

We need to track the user performing the action, which won't be in the DB so won't be doable by a raw trigger

[rugulous]

I suppose we should really know who created/most recently changed any entity, so it may make sense to add these fields to all of our tables

[rugulous]

Found a better way to do this - starting a new branch!

[rugulous]

This went too OTT so let's have a rethinkl