24 lines
975 B
SQL
24 lines
975 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "Item" DROP CONSTRAINT "Item_profileId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "ItemComment" DROP CONSTRAINT "ItemComment_itemId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "Profile" DROP CONSTRAINT "Profile_userId_fkey";
|
|
|
|
-- DropForeignKey
|
|
ALTER TABLE "Tag" DROP CONSTRAINT "Tag_profileId_fkey";
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Profile" ADD CONSTRAINT "Profile_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Item" ADD CONSTRAINT "Item_profileId_fkey" FOREIGN KEY ("profileId") REFERENCES "Profile"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "ItemComment" ADD CONSTRAINT "ItemComment_itemId_fkey" FOREIGN KEY ("itemId") REFERENCES "Item"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Tag" ADD CONSTRAINT "Tag_profileId_fkey" FOREIGN KEY ("profileId") REFERENCES "Profile"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|