-- CreateTable
CREATE TABLE "knowledge_entries" (
    "id" TEXT NOT NULL,
    "topic" TEXT NOT NULL,
    "keywords" JSONB NOT NULL DEFAULT '[]',
    "answer" TEXT NOT NULL,
    "priority" INTEGER NOT NULL DEFAULT 0,
    "published" BOOLEAN NOT NULL DEFAULT true,
    "seededId" TEXT,
    "createdById" TEXT,
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "updatedAt" TIMESTAMP(3) NOT NULL,

    CONSTRAINT "knowledge_entries_pkey" PRIMARY KEY ("id")
);

-- CreateTable
CREATE TABLE "unanswered_questions" (
    "id" TEXT NOT NULL,
    "question" TEXT NOT NULL,
    "fingerprint" TEXT NOT NULL,
    "hits" INTEGER NOT NULL DEFAULT 1,
    "resolvedAt" TIMESTAMP(3),
    "lastAskedAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
    "createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,

    CONSTRAINT "unanswered_questions_pkey" PRIMARY KEY ("id")
);

-- CreateIndex
CREATE UNIQUE INDEX "knowledge_entries_seededId_key" ON "knowledge_entries"("seededId");

-- CreateIndex
CREATE INDEX "knowledge_entries_published_idx" ON "knowledge_entries"("published");

-- CreateIndex
CREATE UNIQUE INDEX "unanswered_questions_fingerprint_key" ON "unanswered_questions"("fingerprint");

-- CreateIndex
CREATE INDEX "unanswered_questions_resolvedAt_hits_idx" ON "unanswered_questions"("resolvedAt", "hits");

-- AddForeignKey
ALTER TABLE "knowledge_entries" ADD CONSTRAINT "knowledge_entries_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES "users"("id") ON DELETE SET NULL ON UPDATE CASCADE;
