-- AlterTable
ALTER TABLE "master"."categories" ADD COLUMN "parentId" TEXT;
ALTER TABLE "master"."categories" ADD COLUMN "level" INTEGER NOT NULL DEFAULT 0;

-- CreateIndex
CREATE INDEX "categories_parentId_idx" ON "master"."categories"("parentId");

-- AddForeignKey
ALTER TABLE "master"."categories" ADD CONSTRAINT "categories_parentId_fkey" FOREIGN KEY ("parentId") REFERENCES "master"."categories"("id") ON DELETE RESTRICT ON UPDATE CASCADE;