-- AlterTable
ALTER TABLE "coupons" ADD COLUMN     "is_self_store" BOOLEAN NOT NULL DEFAULT false;

-- AlterTable
ALTER TABLE "courses" ADD COLUMN     "coupon_group_id" TEXT;

-- CreateIndex
CREATE INDEX "courses_coupon_group_id_idx" ON "courses"("coupon_group_id");

-- AddForeignKey
ALTER TABLE "courses" ADD CONSTRAINT "courses_coupon_group_id_fkey" FOREIGN KEY ("coupon_group_id") REFERENCES "coupon_groups"("id") ON DELETE SET NULL ON UPDATE CASCADE;