BEGIN;

SET ROLE work_role;

ALTER TABLE work.agent_dispatch_queue
  ADD COLUMN IF NOT EXISTS retry_limit INTEGER NOT NULL DEFAULT 3;

ALTER TABLE work.agent_dispatch_queue
  DROP CONSTRAINT IF EXISTS agent_dispatch_queue_retry_limit_check;

ALTER TABLE work.agent_dispatch_queue
  ADD CONSTRAINT agent_dispatch_queue_retry_limit_check CHECK (retry_limit > 0);

RESET ROLE;
COMMIT;