migration.sql 454 B

123456789101112131415
  1. -- CreateTable
  2. CREATE TABLE "InfraToken" (
  3. "id" TEXT NOT NULL,
  4. "creatorUid" TEXT NOT NULL,
  5. "label" TEXT NOT NULL,
  6. "token" TEXT NOT NULL,
  7. "expiresOn" TIMESTAMP(3),
  8. "createdOn" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  9. "updatedOn" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  10. CONSTRAINT "InfraToken_pkey" PRIMARY KEY ("id")
  11. );
  12. -- CreateIndex
  13. CREATE UNIQUE INDEX "InfraToken_token_key" ON "InfraToken"("token");