mirror of
https://github.com/hanzo-apps/dataroom.git
synced 2026-11-02 04:35:56 +00:00
17 lines
512 B
SQL
17 lines
512 B
SQL
-- CreateTable
|
|
CREATE TABLE "Reaction" (
|
|
"id" TEXT NOT NULL,
|
|
"viewId" TEXT NOT NULL,
|
|
"pageNumber" INTEGER NOT NULL,
|
|
"type" TEXT NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "Reaction_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Reaction_viewId_idx" ON "Reaction"("viewId");
|
|
|
|
-- AddForeignKey
|
|
ALTER TABLE "Reaction" ADD CONSTRAINT "Reaction_viewId_fkey" FOREIGN KEY ("viewId") REFERENCES "View"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|