migrations/0005_audit_request_id.sql

-- 0005_audit_request_id.sql

ALTER TABLE risk_audit_logs ADD COLUMN request_id VARCHAR;
ALTER TABLE login_attempts ADD COLUMN request_id VARCHAR;

CREATE INDEX IF NOT EXISTS idx_risk_request_id ON risk_audit_logs(request_id);
CREATE INDEX IF NOT EXISTS idx_login_request_id ON login_attempts(request_id);