-- Gift-membership coupons: code can grant a tier at signup
-- (none = just discount/free-preview behavior; otherwise auto-set tier on the
-- new user without any checkout).
ALTER TABLE coupons
    ADD COLUMN grants_tier VARCHAR(16) DEFAULT NULL;