How to add a constraint (in this case unique constraint) to an existing table
ALTER TABLE mytable
ADD CONSTRAINT user_role_uq UNIQUE (name, role);
How to remove a constraint from an existing table
ALTER TABLE mytable
DROP CONSTRAINT user_role_uq;