/* Warnings: - You are about to drop the column `commentId` on the `Like` table. All the data in the column will be lost. - You are about to drop the column `postId` on the `Like` table. All the data in the column will be lost. - A unique constraint covering the columns `[userId,targetType,targetId]` on the table `Like` will be added. If there are existing duplicate values, this will fail. - Added the required column `targetId` to the `Like` table without a default value. This is not possible if the table is not empty. - Added the required column `targetType` to the `Like` table without a default value. This is not possible if the table is not empty. */ -- DropForeignKey ALTER TABLE "Like" DROP CONSTRAINT "Like_commentId_fkey"; -- DropForeignKey ALTER TABLE "Like" DROP CONSTRAINT "Like_postId_fkey"; -- DropForeignKey ALTER TABLE "Like" DROP CONSTRAINT "Like_userId_fkey"; -- AlterTable ALTER TABLE "Like" DROP COLUMN "commentId", DROP COLUMN "postId", ADD COLUMN "targetId" TEXT NOT NULL, ADD COLUMN "targetType" TEXT NOT NULL; -- CreateIndex CREATE UNIQUE INDEX "Like_userId_targetType_targetId_key" ON "Like"("userId", "targetType", "targetId"); -- AddForeignKey ALTER TABLE "Like" ADD CONSTRAINT "Like_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "Like" ADD CONSTRAINT "PostLikes" FOREIGN KEY ("targetId") REFERENCES "Post"("id") ON DELETE RESTRICT ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "Like" ADD CONSTRAINT "CommentLikes" FOREIGN KEY ("targetId") REFERENCES "Comments"("id") ON DELETE RESTRICT ON UPDATE CASCADE;