clinwiki-org / clinwiki

Crowd-source tool to annotate, rank and generally enhance the clarity and accuracy of clinical trial information.
https://www.clinwiki.org
MIT License
16 stars 16 forks source link

Ckvi audits #1125

Closed bespinosa01 closed 3 years ago

bespinosa01 commented 3 years ago

Adds entry into our crowkd_key_value_id_audit table where each row includes a copy of the entry that was just added/removed and the user who created that record.

Achieved this leveraging our trigger that was already firing to index when insert/delete/update happens in our crowd_key_value_ids table. Instead of immediately triggering reindex, a copy of the entry will be added to our db. Then continues to index as it did.