migration.sql 710 B

12345678910111213141516171819202122
  1. -- CreateTable
  2. CREATE TABLE "ShareLink" (
  3. "id" TEXT NOT NULL,
  4. "workspaceId" TEXT NOT NULL,
  5. "token" TEXT NOT NULL,
  6. "expiresAt" TIMESTAMP(3),
  7. "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  8. CONSTRAINT "ShareLink_pkey" PRIMARY KEY ("id")
  9. );
  10. -- CreateIndex
  11. CREATE UNIQUE INDEX "ShareLink_workspaceId_key" ON "ShareLink"("workspaceId");
  12. -- CreateIndex
  13. CREATE UNIQUE INDEX "ShareLink_token_key" ON "ShareLink"("token");
  14. -- CreateIndex
  15. CREATE INDEX "ShareLink_token_idx" ON "ShareLink"("token");
  16. -- AddForeignKey
  17. ALTER TABLE "ShareLink" ADD CONSTRAINT "ShareLink_workspaceId_fkey" FOREIGN KEY ("workspaceId") REFERENCES "Workspace"("id") ON DELETE CASCADE ON UPDATE CASCADE;