Files

6 lines
331 B
SQL
Raw Permalink Normal View History

-- Subscription tiers as roles: 'premium' and 'vip' unlock the models marked
-- for them in the backend's LLM_MODELS.
ALTER TABLE users DROP CONSTRAINT users_roles_valid;
ALTER TABLE users ADD CONSTRAINT users_roles_valid
CHECK (cardinality(roles) > 0 AND roles <@ ARRAY['admin', 'creator', 'premium', 'vip', 'user']::text[]);