-- Drop index "idx_order_src" from table: "McuOrderItem" DROP INDEX "public"."idx_order_src"; -- Modify "McuOrderItem" table ALTER TABLE "public"."McuOrderItem" ADD COLUMN "McuSrc_Code" text NULL; -- Create index "idx_order_src" to table: "McuOrderItem" CREATE UNIQUE INDEX "idx_order_src" ON "public"."McuOrderItem" ("McuOrder_Id", "McuSrc_Id", "McuSrc_Code"); -- Drop index "idx_order_sub_src" from table: "McuOrderSubItem" DROP INDEX "public"."idx_order_sub_src"; -- Modify "McuOrderSubItem" table ALTER TABLE "public"."McuOrderSubItem" ADD COLUMN "McuSubSrc_Code" text NULL; -- Create index "idx_order_sub_src" to table: "McuOrderSubItem" CREATE UNIQUE INDEX "idx_order_sub_src" ON "public"."McuOrderSubItem" ("McuSubSrc_Id", "McuSubSrc_Code", "McuOrderItem_Id");