SQL reference: 004_identifier_collation

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

Source: Database/mysql-auth/004_identifier_collation.sql

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

Migration ID: auth_004_collation. SHA-256 (LF): ea5b5c57adbf54a2a69721aff022b972d7757048af2c1bfd9bfa1995ba9ba772.

Source overview

Make username uniqueness deterministic across both MySQL-compatible engines. ALTER is intentional and versioned; changing DATABASE_ENGINE is not migration.

Declared objects

• asi_audit_time
• asi_sessions_expiry
• asi_verification_expiry

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