-- CreateEnum CREATE TYPE "BookRole" AS ENUM ('ADMIN', 'EDITOR', 'VIEWER'); -- AlterTable ALTER TABLE "Entity" ADD COLUMN "updatedById" TEXT; -- AlterTable ALTER TABLE "Relation" ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD COLUMN "updatedById" TEXT; -- AlterTable ALTER TABLE "StoryEvent" ADD COLUMN "updatedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, ADD COLUMN "updatedById" TEXT; -- CreateTable CREATE TABLE "BookMember" ( "id" TEXT NOT NULL, "bookId" TEXT NOT NULL, "userId" TEXT NOT NULL, "role" "BookRole" NOT NULL DEFAULT 'EDITOR', "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "BookMember_pkey" PRIMARY KEY ("id") ); -- CreateIndex CREATE INDEX "BookMember_userId_idx" ON "BookMember"("userId"); -- CreateIndex CREATE UNIQUE INDEX "BookMember_bookId_userId_key" ON "BookMember"("bookId", "userId"); -- AddForeignKey ALTER TABLE "BookMember" ADD CONSTRAINT "BookMember_bookId_fkey" FOREIGN KEY ("bookId") REFERENCES "Book"("id") ON DELETE CASCADE ON UPDATE CASCADE; -- AddForeignKey ALTER TABLE "BookMember" ADD CONSTRAINT "BookMember_userId_fkey" FOREIGN KEY ("userId") REFERENCES "User"("id") ON DELETE CASCADE ON UPDATE CASCADE;