7 lines
187 B
SQL
7 lines
187 B
SQL
ALTER TABLE users
|
|
DROP CONSTRAINT IF EXISTS users_user_role_check;
|
|
|
|
ALTER TABLE users
|
|
ADD CONSTRAINT users_user_role_check
|
|
CHECK (user_role IN ('owner', 'admin', 'vip', 'member'));
|