mirror of
https://github.com/arthur-pbty/reducelink.git
synced 2026-06-03 23:36:24 +02:00
Puechberty Arthur
23 lines
605 B
SQL
23 lines
605 B
SQL
-- CreateTable
|
|
CREATE TABLE "Link" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"originalUrl" TEXT NOT NULL,
|
|
"shortCode" TEXT NOT NULL,
|
|
"clickCount" INTEGER NOT NULL DEFAULT 0,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"title" TEXT,
|
|
"favicon" TEXT
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Link_shortCode_key" ON "Link"("shortCode");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Link_shortCode_idx" ON "Link"("shortCode");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Link_createdAt_idx" ON "Link"("createdAt");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "Link_clickCount_idx" ON "Link"("clickCount");
|