migrations/0011_forensic_chain.sql

-- 0011_smart_chain.sql

ALTER TABLE risk_audit_logs ADD COLUMN entry_hash VARCHAR(64);
ALTER TABLE risk_audit_logs ADD COLUMN previous_hash VARCHAR(64);

ALTER TABLE login_attempts ADD COLUMN entry_hash VARCHAR(64);
ALTER TABLE login_attempts ADD COLUMN previous_hash VARCHAR(64);

CREATE INDEX IF NOT EXISTS idx_risk_audit_hash ON risk_audit_logs(entry_hash);
CREATE INDEX IF NOT EXISTS idx_login_attempts_hash ON login_attempts(entry_hash);