SQL reference: 002_direct

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

Source: Database/mysql-auth/002_direct.sql

Engine: MySQL/MariaDB auth contract. Status: enabled; isolated tests required before production acceptance.

Migration ID: auth_002_direct. SHA-256 (LF): 78b86c51dcb6dced1a358de75dd135572e31332080795ae8f6c98164e67c3f76.

Source overview

Shared direct/HTTPS user operations. No legacy schema conversion. Definer must be a retained, non-root schema owner with only required table rights. Standalone credential reads commit audit before returning sensitive material.

Declared objects

• asi_direct_accounts
• asi_direct_credentials
• asi_direct_user_lookup
• asi_direct_user_rename
• asi_user_lookup
• asi_user_profile_audit
• asi_user_rename

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