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
• User is created/changed
• 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