/* Warnings: - The values [CLOSED] on the enum `T_SupportStatus` will be removed. If these variants are still used in the database, this will fail. */ -- AlterEnum BEGIN; CREATE TYPE "T_SupportStatus_new" AS ENUM ('OPEN', 'IN_PROGRESS', 'RESOLVED', 'REJECTED'); ALTER TABLE "public"."Support" ALTER COLUMN "status" DROP DEFAULT; ALTER TABLE "Support" ALTER COLUMN "status" TYPE "T_SupportStatus_new" USING ("status"::text::"T_SupportStatus_new"); ALTER TYPE "T_SupportStatus" RENAME TO "T_SupportStatus_old"; ALTER TYPE "T_SupportStatus_new" RENAME TO "T_SupportStatus"; DROP TYPE "public"."T_SupportStatus_old"; ALTER TABLE "Support" ALTER COLUMN "status" SET DEFAULT 'OPEN'; COMMIT;