SQL reference: 15_remediation

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

Source: Database/15_remediation.sql

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

Migration ID: 15_remediation. SHA-256 (LF): fee07aec81e0528b0ecf74eb6cc6567563f7bc3e3ba42507389e2736d5f06b7d.

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

Source overview

========================================================= Arybit Auth - Schema Module (MySQL Version) MODULE: 15_remediation VERSION: 2.1.3 • January 2026

Remediation of risks identified in Jan 2026 Audit:

1. Enforce withdrawal approval workflow
2. Refresh token rotation & reuse detection logic

Declared objects

• finalize_2fa_migration_safe
• mpesa_idempotency
• rotate_refresh_token_family
• trg_enforce_approved_by
• trg_enforce_full_stage_flow
• trg_enforce_withdrawal_approval

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