Files

12 lines
366 B
SQL

-- CreateTable
CREATE TABLE "SkippedVacancy" (
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
"telegramId" BIGINT NOT NULL,
"href" TEXT NOT NULL,
"title" TEXT NOT NULL,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);
-- CreateIndex
CREATE UNIQUE INDEX "SkippedVacancy_telegramId_href_key" ON "SkippedVacancy"("telegramId", "href");