-- AlterTable
ALTER TABLE "tbl_reel" ADD COLUMN     "category_id" BIGINT,
ADD COLUMN     "sub_category_id" BIGINT,
ADD COLUMN     "sub_child_category_id" BIGINT;

-- CreateIndex
CREATE INDEX "tbl_reel_category_id_idx" ON "tbl_reel"("category_id");

-- CreateIndex
CREATE INDEX "tbl_reel_sub_category_id_idx" ON "tbl_reel"("sub_category_id");

-- CreateIndex
CREATE INDEX "tbl_reel_sub_child_category_id_idx" ON "tbl_reel"("sub_child_category_id");

-- AddForeignKey
ALTER TABLE "tbl_reel" ADD CONSTRAINT "tbl_reel_category_id_fkey" FOREIGN KEY ("category_id") REFERENCES "tbl_category"("id") ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "tbl_reel" ADD CONSTRAINT "tbl_reel_sub_category_id_fkey" FOREIGN KEY ("sub_category_id") REFERENCES "tbl_category"("id") ON DELETE SET NULL ON UPDATE CASCADE;

-- AddForeignKey
ALTER TABLE "tbl_reel" ADD CONSTRAINT "tbl_reel_sub_child_category_id_fkey" FOREIGN KEY ("sub_child_category_id") REFERENCES "tbl_category"("id") ON DELETE SET NULL ON UPDATE CASCADE;
