to make a blank migration file, and wrote this custom script:
ALTER TYPE "security" ADD VALUE 'hwid';--> statement-breakpointALTER TYPE "security" ADD VALUE 'hwid_ip';--> statement-breakpointCOMMIT;--> statement-breakpointUPDATE appsSET security = 'hwid'WHERE security = 'minimal';--> statement-breakpointUPDATE appsSET security = 'hwid_ip'WHERE security IN ('regular', 'advanced');--> statement-breakpointALTER TYPE "security"DROP VALUE 'minimal';--> statement-breakpointALTER TYPE "security"DROP VALUE 'regular';--> statement-breakpointALTER TYPE "security"DROP VALUE 'advanced';--> statement-breakpointALTER TABLE "apps"ALTER COLUMN "security"SET DEFAULT 'hwid_ip';
ALTER TYPE "security" ADD VALUE 'hwid';--> statement-breakpointALTER TYPE "security" ADD VALUE 'hwid_ip';--> statement-breakpointCOMMIT;--> statement-breakpointUPDATE appsSET security = 'hwid'WHERE security = 'minimal';--> statement-breakpointUPDATE appsSET security = 'hwid_ip'WHERE security IN ('regular', 'advanced');--> statement-breakpointALTER TYPE "security"DROP VALUE 'minimal';--> statement-breakpointALTER TYPE "security"DROP VALUE 'regular';--> statement-breakpointALTER TYPE "security"DROP VALUE 'advanced';--> statement-breakpointALTER TABLE "apps"ALTER COLUMN "security"SET DEFAULT 'hwid_ip';
Sadly, this did not work and I get this output in my terminal: