ALTER TABLE users ADD COLUMN referrer_id TEXT REFERENCES users(id);
ALTER TABLE settings ADD COLUMN referral_percent INTEGER NOT NULL DEFAULT 0 CHECK(referral_percent BETWEEN 0 AND 100);
CREATE INDEX idx_users_referrer ON users(referrer_id);