eletrotupi / tcc/ api/prisma/migrations/20260604225204_rename_triggers_enums/migration.sql390ce2952161e18712e999aba9eb762245263865
558 B | 14 lines Raw
1
/*
2
  Warnings:
3

4
  - The values [ENVIRONMENTAL,EMOTIONAL] on the enum `TriggerType` will be removed. If these variants are still used in the database, this will fail.
5

6
*/
7
-- AlterEnum
8
BEGIN;
9
CREATE TYPE "TriggerType_new" AS ENUM ('SOCIAL', 'WORK', 'HEALTH', 'PHYSICAL', 'FAMILY', 'OTHER');
10
ALTER TABLE "triggers" ALTER COLUMN "category" TYPE "TriggerType_new" USING ("category"::text::"TriggerType_new");
11
ALTER TYPE "TriggerType" RENAME TO "TriggerType_old";
12
ALTER TYPE "TriggerType_new" RENAME TO "TriggerType";
13
DROP TYPE "public"."TriggerType_old";
14
COMMIT;