blob: 858d2ecf36451f75f55c7f746b12038f4d576a6a [file] [log] [blame]
CREATE SEQUENCE "table1_id_seq";
ALTER TABLE "table1" ALTER "id" TYPE INTEGER;
ALTER TABLE "table1" ALTER COLUMN "id" SET DEFAULT nextval('table1_id_seq');
ALTER TABLE "table1" ALTER COLUMN "id" SET NOT NULL;
ALTER TABLE "table2" ADD CONSTRAINT "table2_pkey" PRIMARY KEY ( "id" );