1 DELETE FROM "user_groups" WHERE "permission" = 'arbitrator'::"userGroup";
3 ALTER TYPE "userGroup" RENAME TO "oldUserGroup";
4 CREATE TYPE "userGroup" AS enum('supporter','blocked-agent','blocked-applicant','blocked-login','ttp-agent','ttp-applicant', 'codesigning', 'org-agent', 'blocked-cert', 'nucleus-agent', 'locate-agent', 'verify-notification');
5 ALTER TABLE "user_groups" ALTER COLUMN "permission" SET DATA TYPE "userGroup" USING
6 CASE "permission" WHEN 'blockedassurer' THEN 'blocked-agent'::"userGroup"
7 WHEN 'blockedassuree' THEN 'blocked-applicant'::"userGroup"
8 WHEN 'ttp-assurer' THEN 'ttp-agent'::"userGroup"
9 WHEN 'orgassurer' THEN 'org-agent'::"userGroup"
10 WHEN 'nucleus-assurer' THEN 'nucleus-agent'::"userGroup"
11 WHEN 'blockedcert' THEN 'blocked-cert'::"userGroup"
12 WHEN 'blockedlogin' THEN 'blocked-login'::"userGroup"
13 ELSE "permission"::text::"userGroup"
15 DROP TYPE "oldUserGroup";