Files
2025-11-06 12:17:49 +07:00

7 lines
423 B
SQL

-- Modify "McuOrder" table
ALTER TABLE "public"."McuOrder" ADD COLUMN "Scope_Code" character varying(10) NULL;
-- Create index "idx_McuOrder_Scope_Code" to table: "McuOrder"
CREATE INDEX "idx_McuOrder_Scope_Code" ON "public"."McuOrder" ("Scope_Code");
-- Create index "idx_McuSrcCategory_Scope_Code" to table: "McuSrcCategory"
CREATE INDEX "idx_McuSrcCategory_Scope_Code" ON "public"."McuSrcCategory" ("Scope_Code");