13 lines
768 B
SQL
13 lines
768 B
SQL
-- 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");
|