Need help with a migration

This was my old enum:

export const securityEnum = pgEnum("security", ["none", "minimal", "regular", "advanced"])

export const securityEnum = pgEnum("security", ["none", "minimal", "regular", "advanced"])

And this is my new one:

export const securityEnum = pgEnum("security", ["none", "hwid", "hwid_ip"])

export const securityEnum = pgEnum("security", ["none", "hwid", "hwid_ip"])

I ran generate --custom to make a blank migration file, and wrote this custom script:

ALTER TYPE "security" ADD VALUE 'hwid';

--> statement-breakpoint
ALTER TYPE "security" ADD VALUE 'hwid_ip';

--> statement-breakpoint
COMMIT;

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid'
WHERE
  security = 'minimal';

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid_ip'
WHERE
  security IN ('regular', 'advanced');

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'minimal';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'regular';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'advanced';

--> statement-breakpoint
ALTER TABLE "apps"
ALTER COLUMN "security"
SET DEFAULT 'hwid_ip';

ALTER TYPE "security" ADD VALUE 'hwid';

--> statement-breakpoint
ALTER TYPE "security" ADD VALUE 'hwid_ip';

--> statement-breakpoint
COMMIT;

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid'
WHERE
  security = 'minimal';

--> statement-breakpoint
UPDATE apps
SET
  security = 'hwid_ip'
WHERE
  security IN ('regular', 'advanced');

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'minimal';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'regular';

--> statement-breakpoint
ALTER TYPE "security"
DROP VALUE 'advanced';

--> statement-breakpoint
ALTER TABLE "apps"
ALTER COLUMN "security"
SET DEFAULT 'hwid_ip';

Sadly, this did not work and I get this output in my terminal:

1 Reply

x03OP•8mo ago

The first two objects output by the terminal always get printed when I run my server because I run my migration script on server startup. I'm not sure what they mean but I always assumed it just meant that a migration already exists, therefore it will not migrate again.

Gaming

Programming

Need help with a migration