Future
Objective
Append-only audit logs with cryptographic integrity.
Problem
audit_logs is mutable
DeleteAuditLogsBefore() allows hard deletion
- No hash chain
Fix
previous_hash column
- SHA-256 hash per row
- DB trigger blocks DELETE
immutable=true config
Files
internal/storage/sqlite.go
internal/audit/
Acceptance Criteria
Future
Objective
Append-only audit logs with cryptographic integrity.
Problem
audit_logsis mutableDeleteAuditLogsBefore()allows hard deletionFix
previous_hashcolumnimmutable=trueconfigFiles
internal/storage/sqlite.gointernal/audit/Acceptance Criteria