migration.sql 411 B

1234567891011121314
  1. -- CreateTable
  2. CREATE TABLE "ShortLink" (
  3. "id" TEXT NOT NULL PRIMARY KEY,
  4. "shortCode" TEXT NOT NULL,
  5. "fullUrl" TEXT NOT NULL,
  6. "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  7. "updatedAt" DATETIME NOT NULL
  8. );
  9. -- CreateIndex
  10. CREATE UNIQUE INDEX "ShortLink_shortCode_key" ON "ShortLink"("shortCode");
  11. -- CreateIndex
  12. CREATE INDEX "ShortLink_shortCode_idx" ON "ShortLink"("shortCode");