SQL reference: 02_referrals

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

Source: Database/02_referrals.sql

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

Migration ID: 02_referrals. SHA-256 (LF): 9a68b57381a9838637be50faf6f367fb58ec8faceadf2b6c5b8bdc8cad4f85ed.

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

Source overview

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

Referral system – tracking codes & referral relationships

Declared objects

• assign_referral_bonus
• create_index_if_not_exists
• ensure_metadata_col
• ensure_referral_code_col
• is_valid_referral_code
• record_referral
• referral_codes
• referrals
• trg_users_after_insert_referral

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