[Enhancement] Referral system is mock-only — codes stored in a module-level Map, not persisted

[RUKAYAT-CODER]

Overview

src/lib/referral.ts stores referral codes in a mockReferralCodes Map in module memory. Every server restart wipes all referral codes, making referral links invalid. Referral counts are lost, and the feature provides no real value in production.

Specifications

Features:

• Referral codes are stored in the database and persist indefinitely
• Referral counts are accurate and survive restarts

Tasks:

• Create a referrals table: (code TEXT PRIMARY KEY, owner_email TEXT, owner_id UUID, referral_count INT DEFAULT 0, created_at TIMESTAMPTZ)
• Replace all mockReferralCodes Map operations with parameterized SQL queries
• On user signup, generate and store the code in the database
• Implement getReferralCount() with a SELECT COUNT(*) from a referred_users join table

Impacted Files:

• src/lib/referral.ts
• src/app/api/auth/signup/route.ts
• src/lib/db/ (new migration)

Acceptance Criteria

• Referral codes persist across server restarts
• referralCodeExists() queries the database
• Referral count increments correctly in the database on successful signup

[adamualihantsu]

@adamualihantsu has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hey maintainer kindly assgn me to work on your issues

ℹ️ Repo Maintainers: To accept this application, review their application or assign @adamualihantsu to this issue.

[drips-wave]

Congratulations, @adamualihantsu! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @adamualihantsu: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊