18 lines
661 B
SQL
18 lines
661 B
SQL
-- DropForeignKey
|
|
ALTER TABLE "Article" DROP CONSTRAINT "Article_authorId_fkey";
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "ArticleAuthor" (
|
|
"articleId" TEXT NOT NULL,
|
|
"authorId" TEXT NOT NULL,
|
|
"role" "AuthorRole" NOT NULL,
|
|
|
|
CONSTRAINT "ArticleAuthor_pkey" PRIMARY KEY ("articleId","authorId")
|
|
);
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "ArticleAuthor" ADD CONSTRAINT "ArticleAuthor_articleId_fkey" FOREIGN KEY ("articleId") REFERENCES "Article"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "ArticleAuthor" ADD CONSTRAINT "ArticleAuthor_authorId_fkey" FOREIGN KEY ("authorId") REFERENCES "Author"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|