-- Alter the portfolio table
ALTER TABLE "portfolio" ALTER COLUMN "id" TYPE bigint;
ALTER SEQUENCE "portfolio_id_seq" AS bigint;

-- Alter the portfolioUsers table
ALTER TABLE "portfolioUsers" ALTER COLUMN "id" TYPE bigint;
ALTER SEQUENCE "portfolioUsers_id_seq" AS bigint;

-- Alter the user table
ALTER TABLE "user" ALTER COLUMN "id" TYPE bigint;
ALTER SEQUENCE "user_id_seq" AS bigint;

ALTER TABLE "portfolioUsers" ALTER COLUMN "user_id" SET DATA TYPE bigint;--> statement-breakpoint
ALTER TABLE "portfolioUsers" ALTER COLUMN "portfolio_id" SET DATA TYPE bigint;--> statement-breakpoint