-- CreateTable
CREATE TABLE "SiteVisit" (
    "id" TEXT NOT NULL PRIMARY KEY,
    "path" TEXT NOT NULL,
    "referrerHost" TEXT,
    "language" TEXT,
    "timezone" TEXT,
    "deviceType" TEXT,
    "viewport" TEXT,
    "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);

-- CreateIndex
CREATE INDEX "SiteVisit_path_idx" ON "SiteVisit"("path");

-- CreateIndex
CREATE INDEX "SiteVisit_referrerHost_idx" ON "SiteVisit"("referrerHost");

-- CreateIndex
CREATE INDEX "SiteVisit_createdAt_idx" ON "SiteVisit"("createdAt");
