SQL reference: 01_users
Production API: https://asi-database-node-api.arybit.co.ke
Source: Database/01_users.sql
Engine: MySQL legacy. Status: disabled; qualification pending.
Migration ID: 01_users. SHA-256 (LF): c843f3814eba53c7d13f6285cbc7bfbd57bd56022e9c9934a080ba86f51547ac.
Pending isolated MySQL/MariaDB compatibility, dependency and tenant-isolation validation.
Source overview
========================================================= Arybit Auth - Schema Module (MySQL Version) MODULE: 01_core_users VERSION: 2.1.0 • December 28, 2025 Production-Ready • MySQL / MariaDB Compatible
Adapted for environments without PostgreSQL extensions Strict mode recommended + application-level crypto
Declared objects
access_tokensapi_keyscheck_brute_forcecreate_access_tokens_indexescreate_index_if_not_exists_01_users_api_keyscreate_index_if_not_exists_01_users_login_attemptscreate_index_if_not_exists_01_users_permissionscreate_index_if_not_exists_01_users_role_permissionscreate_index_if_not_exists_01_users_rolescreate_index_if_not_exists_01_users_user_rolescreate_users_indexescreate_verification_codes_indexesencryption_keysensure_api_keys_columnsensure_username_columnensure_users_columnsgenerate_weak_tokenidx_access_tokens_jtiidx_access_tokens_token_hashidx_access_tokens_user_ididx_api_keys_keyidx_login_attempts_lookupidx_permissions_codeidx_role_permissions_role_ididx_roles_nameidx_user_roles_user_ididx_users_countryidx_users_created_atidx_users_emailidx_users_eng_scoreidx_users_usernameidx_verif_codes_codeidx_verif_codes_userlog_login_attemptlogin_attemptsmigrate_organizations_pk_typeorganization_employeesorganizationspermissionsre_add_foreign_keysrefresh_tokensrole_permissionsrolesuser_rolesusersverification_codes
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.