7 lines
747 B
SQL
7 lines
747 B
SQL
-- Create index "idx_Division_Code" to table: "Division"
|
|
CREATE UNIQUE INDEX "idx_Division_Code" ON "public"."Division" ("Code");
|
|
-- Modify "Division" table
|
|
ALTER TABLE "public"."Division" DROP CONSTRAINT "uni_Division_Code", DROP CONSTRAINT "fk_Division_Childrens", DROP COLUMN "Parent_Id", ADD CONSTRAINT "fk_Division_Childrens" FOREIGN KEY ("Parent_Code") REFERENCES "public"."Division" ("Code") ON UPDATE NO ACTION ON DELETE NO ACTION;
|
|
-- Modify "DivisionPosition" table
|
|
ALTER TABLE "public"."DivisionPosition" DROP CONSTRAINT "fk_DivisionPosition_Division", DROP COLUMN "Division_Id", ADD CONSTRAINT "fk_DivisionPosition_Division" FOREIGN KEY ("Division_Code") REFERENCES "public"."Division" ("Code") ON UPDATE NO ACTION ON DELETE NO ACTION;
|