Revise audit events for 24.2.2

Summary

• feat: add integrity_violation audit log event

• refactor: have separate params for raft_id and raft_gen in audit::init

• feat: add create_local_db, drop_local_db, connect_local_db and recover_local_db events

also removes new_database_created event

---

• Close #566 (closed)
• Target branch: 24.2
• Changes should be cherry-picked to master: yes
• Docs follow-up: already done