project-knedita/prisma/migrations/20230727151408_create_like_field_comments/migration.sql

6 lines
231 B
MySQL
Raw Permalink Normal View History

-- AlterTable
ALTER TABLE "Like" ADD COLUMN "commentId" TEXT;
-- AddForeignKey
ALTER TABLE "Like" ADD CONSTRAINT "Like_commentId_fkey" FOREIGN KEY ("commentId") REFERENCES "Comments"("id") ON DELETE CASCADE ON UPDATE CASCADE;