DELETE FROM compliance_tuning_rules
WHERE signal IN ('sanctions_hit', 'pep_match', 'adverse_media', 'high_risk_country', 'velocity_block');

DROP TABLE IF EXISTS aml_false_positive_feedback;
DROP TRIGGER IF EXISTS compliance_tuning_rules_set_updated_at ON compliance_tuning_rules;
DROP TABLE IF EXISTS compliance_tuning_rules;
DROP TRIGGER IF EXISTS regulatory_reports_set_updated_at ON regulatory_reports;
DROP TABLE IF EXISTS regulatory_reports;
DROP TABLE IF EXISTS compliance_monitoring_runs;
DROP TRIGGER IF EXISTS enhanced_due_diligence_reviews_set_updated_at ON enhanced_due_diligence_reviews;
DROP TABLE IF EXISTS enhanced_due_diligence_reviews;
DROP TRIGGER IF EXISTS customer_risk_profiles_set_updated_at ON customer_risk_profiles;
DROP TABLE IF EXISTS customer_risk_profiles;
DROP TABLE IF EXISTS aml_case_status_history;
DROP TABLE IF EXISTS aml_case_attachments;
DROP TABLE IF EXISTS aml_case_notes;

DROP INDEX IF EXISTS aml_cases_sla_due_idx;
DROP INDEX IF EXISTS aml_cases_assigned_status_idx;

ALTER TABLE aml_cases
    DROP COLUMN IF EXISTS false_positive,
    DROP COLUMN IF EXISTS regulatory_report_required,
    DROP COLUMN IF EXISTS closed_at,
    DROP COLUMN IF EXISTS escalated_at,
    DROP COLUMN IF EXISTS sla_due_at,
    DROP COLUMN IF EXISTS assigned_to_admin_user_id;

DROP TABLE IF EXISTS kyc_evidence;
DROP TABLE IF EXISTS kyc_provider_decisions;