17 lines
691 B
PL/PgSQL
17 lines
691 B
PL/PgSQL
|
/*
|
||
|
|
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;
|