GitFOSS
/*
  Warnings:

  - The values [CLOSE_COMPLETE,CLOSE_DENY] on the enum `PullRequestState` will be removed. If these variants are still used in the database, this will fail.

*/
-- AlterEnum
BEGIN;
CREATE TYPE "PullRequestState_new" AS ENUM ('OPEN', 'CLOSE_MERGED', 'CLOSE_DENIED');
ALTER TABLE "PullRequest" ALTER COLUMN "state" DROP DEFAULT;
ALTER TABLE "PullRequest" ALTER COLUMN "state" TYPE "PullRequestState_new" USING ("state"::text::"PullRequestState_new");
ALTER TYPE "PullRequestState" RENAME TO "PullRequestState_old";
ALTER TYPE "PullRequestState_new" RENAME TO "PullRequestState";
DROP TYPE "PullRequestState_old";
ALTER TABLE "PullRequest" ALTER COLUMN "state" SET DEFAULT 'OPEN';
COMMIT;

-- DropIndex
DROP INDEX "Repository_organizationId_slug_key";