Make migration prompts clear

[stephaniesyed]

I am trying to rename some models in our repo (User to Employee, ShipperLocation to PartnerSite). In the migration prompts, it doesn't make it clear that it prompts both for upgrade and downgrade strategies (rather than just doing the reverse of the upgrade for the downgrade).

Console output:

stephanie.syed@LXYWG0WJ6C partner-manager % make migration MESSAGE="rename shipperLocation and user"
[ -n "rename shipperLocation and user" ] || { echo "MESSAGE=\"descriptive_title\" required"; exit 1; }
Running in docker: yarn run payload migrate:create 'rename shipperLocation and user'
yarn run v1.22.19
$ cross-env PAYLOAD_CONFIG_PATH=src/payload.config.ts payload migrate:create 'rename shipperLocation and user'
[19:34:08] INFO (payload): Starting Payload...
~ users_roles › employees_roles table will be renamed
~ users › employees table will be renamed
~ users_rels › employees_rels table will be renamed
~ shipper_locations › partner_sites table will be renamed
~ shipper_locations_rels › partner_sites_rels table will be renamed
--- all table conflicts resolved ---


~ shipper_locations_id › partner_sites_id column will be renamed
--- all columns conflicts in portals_rels table resolved ---


~ users_id › employees_id column will be renamed
--- all columns conflicts in payload_preferences_rels table resolved ---

// Added info: the following are for the downgrade function, but nothing is indicated in the console which is confusing to me as a user
~ employees_roles › users_roles table will be renamed
~ employees › users table will be renamed
~ employees_rels › users_rels table will be renamed
~ partner_sites › shipper_locations table will be renamed
~ partner_sites_rels › shipper_locations_rels table will be renamed
--- all table conflicts resolved ---


~ partner_sites_id › shipper_locations_id column will be renamed
--- all columns conflicts in portals_rels table resolved ---


~ employees_id › users_id column will be renamed
--- all columns conflicts in payload_preferences_rels table resolved ---

The above generates the following migration file:

import { MigrateUpArgs, MigrateDownArgs } from '@payloadcms/db-postgres'
import { sql } from 'drizzle-orm'

export async function up({ payload }: MigrateUpArgs): Promise<void> {
await payload.db.drizzle.execute(sql`

DO $$ BEGIN
 CREATE TYPE "enum_employees_roles" AS ENUM('super-admin', 'admin');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

ALTER TABLE "portals_rels" DROP CONSTRAINT "portals_rels_shipper_locations_id_shipper_locations_id_fk";

ALTER TABLE "payload_preferences_rels" DROP CONSTRAINT "payload_preferences_rels_users_id_users_id_fk";

ALTER TABLE "employees_roles" DROP CONSTRAINT "users_roles_parent_id_users_id_fk";

ALTER TABLE "employees_rels" DROP CONSTRAINT "users_rels_parent_id_users_id_fk";

ALTER TABLE "employees_rels" DROP CONSTRAINT "users_rels_partners_id_partners_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_parent_id_shipper_locations_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_partners_id_partners_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk";

ALTER TABLE "users_roles" RENAME TO "employees_roles";
ALTER TABLE "users" RENAME TO "employees";
ALTER TABLE "users_rels" RENAME TO "employees_rels";
ALTER TABLE "shipper_locations" RENAME TO "partner_sites";
ALTER TABLE "shipper_locations_rels" RENAME TO "partner_sites_rels";
ALTER TABLE "portals_rels" RENAME COLUMN "shipper_locations_id" TO "partner_sites_id";
ALTER TABLE "payload_preferences_rels" RENAME COLUMN "users_id" TO "employees_id";
ALTER TABLE "employees_roles" ALTER COLUMN "value" SET DATA TYPE enum_employees_roles;
DO $$ BEGIN
 ALTER TABLE "portals_rels" ADD CONSTRAINT "portals_rels_partner_sites_id_partner_sites_id_fk" FOREIGN KEY ("partner_sites_id") REFERENCES "partner_sites"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "payload_preferences_rels" ADD CONSTRAINT "payload_preferences_rels_employees_id_employees_id_fk" FOREIGN KEY ("employees_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_roles" ADD CONSTRAINT "employees_roles_parent_id_employees_id_fk" FOREIGN KEY ("parent_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_rels" ADD CONSTRAINT "employees_rels_parent_id_employees_id_fk" FOREIGN KEY ("parent_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_rels" ADD CONSTRAINT "employees_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_parent_id_partner_sites_id_fk" FOREIGN KEY ("parent_id") REFERENCES "partner_sites"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk" FOREIGN KEY ("deliverable_postal_codes_id") REFERENCES "deliverable_postal_codes"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
`);

};

export async function down({ payload }: MigrateDownArgs): Promise<void> {
await payload.db.drizzle.execute(sql`

DO $$ BEGIN
 CREATE TYPE "enum_users_roles" AS ENUM('super-admin', 'admin');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

ALTER TABLE "portals_rels" DROP CONSTRAINT "portals_rels_partner_sites_id_partner_sites_id_fk";

ALTER TABLE "payload_preferences_rels" DROP CONSTRAINT "payload_preferences_rels_employees_id_employees_id_fk";

ALTER TABLE "users_roles" DROP CONSTRAINT "employees_roles_parent_id_employees_id_fk";

ALTER TABLE "users_rels" DROP CONSTRAINT "employees_rels_parent_id_employees_id_fk";

ALTER TABLE "users_rels" DROP CONSTRAINT "employees_rels_partners_id_partners_id_fk";

ALTER TABLE "shipper_locations_rels" DROP CONSTRAINT "partner_sites_rels_parent_id_partner_sites_id_fk";

ALTER TABLE "shipper_locations_rels" DROP CONSTRAINT "partner_sites_rels_partners_id_partners_id_fk";

ALTER TABLE "shipper_locations_rels" DROP CONSTRAINT "partner_sites_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk";

ALTER TABLE "employees_roles" RENAME TO "users_roles";
ALTER TABLE "employees" RENAME TO "users";
ALTER TABLE "employees_rels" RENAME TO "users_rels";
ALTER TABLE "partner_sites" RENAME TO "shipper_locations";
ALTER TABLE "partner_sites_rels" RENAME TO "shipper_locations_rels";
ALTER TABLE "portals_rels" RENAME COLUMN "partner_sites_id" TO "shipper_locations_id";
ALTER TABLE "payload_preferences_rels" RENAME COLUMN "employees_id" TO "users_id";
ALTER TABLE "users_roles" ALTER COLUMN "value" SET DATA TYPE enum_users_roles;
DO $$ BEGIN
 ALTER TABLE "portals_rels" ADD CONSTRAINT "portals_rels_shipper_locations_id_shipper_locations_id_fk" FOREIGN KEY ("shipper_locations_id") REFERENCES "shipper_locations"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "payload_preferences_rels" ADD CONSTRAINT "payload_preferences_rels_users_id_users_id_fk" FOREIGN KEY ("users_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "users_roles" ADD CONSTRAINT "users_roles_parent_id_users_id_fk" FOREIGN KEY ("parent_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "users_rels" ADD CONSTRAINT "users_rels_parent_id_users_id_fk" FOREIGN KEY ("parent_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "users_rels" ADD CONSTRAINT "users_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_parent_id_shipper_locations_id_fk" FOREIGN KEY ("parent_id") REFERENCES "shipper_locations"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk" FOREIGN KEY ("deliverable_postal_codes_id") REFERENCES "deliverable_postal_codes"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
`);

};

If the intention is to give users control to define an asymmetric downgrade (create a new table instead of just undoing the rename), it would be good to give a prompt/some kind of output to indicate the second half of the prompts are for downgrade. If it's not important to give that granular control, it would same time to just do the opposite of what was selected for upgrade for down grade.

[stephaniesyed]

I found out that the second half of that prompt was affecting the down grade, because if I instead choose to create instead of rename:

stephanie.syed@LXYWG0WJ6C partner-manager % make migration MESSAGE="rename shipperLocation and user"
[ -n "rename shipperLocation and user" ] || { echo "MESSAGE=\"descriptive_title\" required"; exit 1; }
Running in docker: yarn run payload migrate:create 'rename shipperLocation and user'
yarn run v1.22.19
$ cross-env PAYLOAD_CONFIG_PATH=src/payload.config.ts payload migrate:create 'rename shipperLocation and user'
[19:10:52] INFO (payload): Starting Payload...
~ users_roles › employees_roles table will be renamed
~ users › employees table will be renamed
~ users_rels › employees_rels table will be renamed
~ shipper_locations › partner_sites table will be renamed
~ shipper_locations_rels › partner_sites_rels table will be renamed
--- all table conflicts resolved ---


~ shipper_locations_id › partner_sites_id column will be renamed
--- all columns conflicts in portals_rels table resolved ---


+ employees_id column will be created
--- all columns conflicts in payload_preferences_rels table resolved ---

+ users_roles table will be created
+ users table will be created
+ users_rels table will be created
+ shipper_locations table will be created
+ shipper_locations_rels table will be created
--- all table conflicts resolved ---


+ shipper_locations_id column will be created
--- all columns conflicts in portals_rels table resolved ---


+ users_id column will be created
--- all columns conflicts in payload_preferences_rels table resolved ---

[19:11:43] INFO (payload): Migration created at /home/node/app/src/migrations/20240103_191052_rename_shipperLocation_and_user.ts
[19:11:43] INFO (payload): Done.
Done in 52.06s.

the following file is generated:

import { MigrateUpArgs, MigrateDownArgs } from '@payloadcms/db-postgres'
import { sql } from 'drizzle-orm'

export async function up({ payload }: MigrateUpArgs): Promise<void> {
await payload.db.drizzle.execute(sql`

DO $$ BEGIN
 CREATE TYPE "enum_employees_roles" AS ENUM('super-admin', 'admin');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

ALTER TABLE "portals_rels" DROP CONSTRAINT "portals_rels_shipper_locations_id_shipper_locations_id_fk";

ALTER TABLE "payload_preferences_rels" DROP CONSTRAINT "payload_preferences_rels_users_id_users_id_fk";

ALTER TABLE "employees_roles" DROP CONSTRAINT "users_roles_parent_id_users_id_fk";

ALTER TABLE "employees_rels" DROP CONSTRAINT "users_rels_parent_id_users_id_fk";

ALTER TABLE "employees_rels" DROP CONSTRAINT "users_rels_partners_id_partners_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_parent_id_shipper_locations_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_partners_id_partners_id_fk";

ALTER TABLE "partner_sites_rels" DROP CONSTRAINT "shipper_locations_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk";

ALTER TABLE "users_roles" RENAME TO "employees_roles";
ALTER TABLE "users" RENAME TO "employees";
ALTER TABLE "users_rels" RENAME TO "employees_rels";
ALTER TABLE "shipper_locations" RENAME TO "partner_sites";
ALTER TABLE "shipper_locations_rels" RENAME TO "partner_sites_rels";
ALTER TABLE "portals_rels" RENAME COLUMN "shipper_locations_id" TO "partner_sites_id";
ALTER TABLE "employees_roles" ALTER COLUMN "value" SET DATA TYPE enum_employees_roles;
ALTER TABLE "payload_preferences_rels" ADD COLUMN "employees_id" integer;
DO $$ BEGIN
 ALTER TABLE "portals_rels" ADD CONSTRAINT "portals_rels_partner_sites_id_partner_sites_id_fk" FOREIGN KEY ("partner_sites_id") REFERENCES "partner_sites"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "payload_preferences_rels" ADD CONSTRAINT "payload_preferences_rels_employees_id_employees_id_fk" FOREIGN KEY ("employees_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_roles" ADD CONSTRAINT "employees_roles_parent_id_employees_id_fk" FOREIGN KEY ("parent_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_rels" ADD CONSTRAINT "employees_rels_parent_id_employees_id_fk" FOREIGN KEY ("parent_id") REFERENCES "employees"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "employees_rels" ADD CONSTRAINT "employees_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_parent_id_partner_sites_id_fk" FOREIGN KEY ("parent_id") REFERENCES "partner_sites"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "partner_sites_rels" ADD CONSTRAINT "partner_sites_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk" FOREIGN KEY ("deliverable_postal_codes_id") REFERENCES "deliverable_postal_codes"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

ALTER TABLE "payload_preferences_rels" DROP COLUMN IF EXISTS "users_id";`);

};

export async function down({ payload }: MigrateDownArgs): Promise<void> {
await payload.db.drizzle.execute(sql`

DO $$ BEGIN
 CREATE TYPE "enum_users_roles" AS ENUM('super-admin', 'admin');
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

CREATE TABLE IF NOT EXISTS "users_roles" (
	"order" integer NOT NULL,
	"parent_id" integer NOT NULL,
	"value" "enum_users_roles",
	"id" serial PRIMARY KEY NOT NULL
);

CREATE TABLE IF NOT EXISTS "users" (
	"id" serial PRIMARY KEY NOT NULL,
	"full_name" varchar,
	"updated_at" timestamp(3) with time zone DEFAULT now() NOT NULL,
	"created_at" timestamp(3) with time zone DEFAULT now() NOT NULL,
	"enable_a_p_i_key" boolean,
	"api_key" varchar,
	"api_key_index" varchar,
	"email" varchar NOT NULL,
	"reset_password_token" varchar,
	"reset_password_expiration" timestamp(3) with time zone,
	"salt" varchar,
	"hash" varchar,
	"login_attempts" numeric,
	"lock_until" timestamp(3) with time zone
);

CREATE TABLE IF NOT EXISTS "users_rels" (
	"id" serial PRIMARY KEY NOT NULL,
	"order" integer,
	"parent_id" integer NOT NULL,
	"path" varchar NOT NULL,
	"partners_id" integer
);

CREATE TABLE IF NOT EXISTS "shipper_locations" (
	"id" serial PRIMARY KEY NOT NULL,
	"store_name" varchar NOT NULL,
	"address_address_line1" varchar NOT NULL,
	"address_address_line2" varchar,
	"address_city" varchar NOT NULL,
	"address_zone_code" varchar NOT NULL,
	"address_postal_code" varchar NOT NULL,
	"address_country_code" varchar NOT NULL,
	"latitude" numeric NOT NULL,
	"longitude" numeric NOT NULL,
	"altitude" numeric NOT NULL,
	"accepting_orders" boolean,
	"updated_at" timestamp(3) with time zone DEFAULT now() NOT NULL,
	"created_at" timestamp(3) with time zone DEFAULT now() NOT NULL
);

CREATE TABLE IF NOT EXISTS "shipper_locations_rels" (
	"id" serial PRIMARY KEY NOT NULL,
	"order" integer,
	"parent_id" integer NOT NULL,
	"path" varchar NOT NULL,
	"partners_id" integer,
	"deliverable_postal_codes_id" integer
);

ALTER TABLE "portals_rels" DROP CONSTRAINT "portals_rels_partner_sites_id_partner_sites_id_fk";

ALTER TABLE "payload_preferences_rels" DROP CONSTRAINT "payload_preferences_rels_employees_id_employees_id_fk";

DROP TABLE "employees_roles";
DROP TABLE "employees";
DROP TABLE "employees_rels";
DROP TABLE "partner_sites";
DROP TABLE "partner_sites_rels";
ALTER TABLE "portals_rels" ADD COLUMN "shipper_locations_id" integer;
ALTER TABLE "payload_preferences_rels" ADD COLUMN "users_id" integer;
CREATE INDEX IF NOT EXISTS "order_idx" ON "users_roles" ("order");
CREATE INDEX IF NOT EXISTS "parent_idx" ON "users_roles" ("parent_id");
CREATE INDEX IF NOT EXISTS "created_at_idx" ON "users" ("created_at");
CREATE UNIQUE INDEX IF NOT EXISTS "email_idx" ON "users" ("email");
CREATE INDEX IF NOT EXISTS "order_idx" ON "users_rels" ("order");
CREATE INDEX IF NOT EXISTS "parent_idx" ON "users_rels" ("parent_id");
CREATE INDEX IF NOT EXISTS "path_idx" ON "users_rels" ("path");
CREATE INDEX IF NOT EXISTS "created_at_idx" ON "shipper_locations" ("created_at");
CREATE INDEX IF NOT EXISTS "order_idx" ON "shipper_locations_rels" ("order");
CREATE INDEX IF NOT EXISTS "parent_idx" ON "shipper_locations_rels" ("parent_id");
CREATE INDEX IF NOT EXISTS "path_idx" ON "shipper_locations_rels" ("path");
DO $$ BEGIN
 ALTER TABLE "portals_rels" ADD CONSTRAINT "portals_rels_shipper_locations_id_shipper_locations_id_fk" FOREIGN KEY ("shipper_locations_id") REFERENCES "shipper_locations"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "payload_preferences_rels" ADD CONSTRAINT "payload_preferences_rels_users_id_users_id_fk" FOREIGN KEY ("users_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

ALTER TABLE "portals_rels" DROP COLUMN IF EXISTS "partner_sites_id";
ALTER TABLE "payload_preferences_rels" DROP COLUMN IF EXISTS "employees_id";
DO $$ BEGIN
 ALTER TABLE "users_roles" ADD CONSTRAINT "users_roles_parent_id_users_id_fk" FOREIGN KEY ("parent_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "users_rels" ADD CONSTRAINT "users_rels_parent_id_users_id_fk" FOREIGN KEY ("parent_id") REFERENCES "users"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "users_rels" ADD CONSTRAINT "users_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_parent_id_shipper_locations_id_fk" FOREIGN KEY ("parent_id") REFERENCES "shipper_locations"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_partners_id_partners_id_fk" FOREIGN KEY ("partners_id") REFERENCES "partners"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;

DO $$ BEGIN
 ALTER TABLE "shipper_locations_rels" ADD CONSTRAINT "shipper_locations_rels_deliverable_postal_codes_id_deliverable_postal_codes_id_fk" FOREIGN KEY ("deliverable_postal_codes_id") REFERENCES "deliverable_postal_codes"("id") ON DELETE cascade ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;
`);

};

[DanRibbens]

You're correct that the initial prompts are for up and the second time is for down.

The prompts come from drizzle. That is feedback we could share to thier team. I also think we could improve our docs on this. Getting prompted twice for seemingly the same info is confusing for sure!