aboutsummaryrefslogtreecommitdiffstats
path: root/db/downgrade_0041---0040.sql
blob: 13bf083e89329fa4a7c300604bcadddd3ab68247 (plain)
1
2
3
4
5
6
7
8
9
begin;
ALTER TABLE user_body_permissions
ADD CONSTRAINT user_body_permissions_permission_type_check
CHECK (
    permission_type='moderate' or
    -- for future expansion --
    permission_type='admin'
);
commit;