SQL reference: 04_moderation

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/04_moderation.sql

Engine: MySQL legacy. Status: disabled; qualification pending.

Migration ID: 04_moderation. SHA-256 (LF): 4757b638433639cb096ae4b0c8ef9c695b795367ed446fdb598f962782efecc7.

Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.

Source overview

========================================================= Arybit Auth - Schema Module (MySQL Version) MODULE: 04_moderation VERSION: 2.1.0 • December 28, 2025 Production-Ready • MySQL / MariaDB Compatible

Moderation: prohibited words, reports, queue, audit logging

Declared objects

• audit_logs
• audit_logs_archive
• create_idx_audit_action
• create_idx_audit_actor
• create_idx_mq_priority
• create_idx_mq_status
• create_idx_reports_reporter
• create_idx_reports_status
• ensure_audit_logs_columns
• fix_transactions_schema_04
• idx_audit_action
• idx_audit_actor
• idx_mq_priority
• idx_mq_status
• idx_reports_reporter
• idx_reports_status
• log_suspicious_withdrawal
• moderation_queue
• prohibited_words
• reports
• trg_audit_mpesa_transaction
• trg_log_mq_changes
• trg_log_mq_update
• trg_log_suspicious_withdrawal
• trg_mq_validate_target
• trg_reports_validate_target
• validate_moderation_target

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog