BEGIN;

ALTER TABLE admin DROP CONSTRAINT IF EXISTS admin_pkey;

ALTER TABLE admin ADD PRIMARY KEY (job);

COMMIT;