miem_workers/migrations/014_system_user_council_role.sql

BEGIN;
SET LOCAL lock_timeout = '5s';
ALTER TABLE public.system_users
    DROP CONSTRAINT ck_system_users_role,
    ADD CONSTRAINT ck_system_users_role CHECK (role IN ('admin', 'user', 'council'));
COMMIT;