21 lines
608 B
SQL
21 lines
608 B
SQL
-- CreateTable
|
|
CREATE TABLE "LlmPrompt" (
|
|
"id" SERIAL NOT NULL,
|
|
"title" TEXT NOT NULL,
|
|
"category" TEXT NOT NULL DEFAULT 'custom',
|
|
"description" TEXT,
|
|
"tags" TEXT[] DEFAULT ARRAY[]::TEXT[],
|
|
"content" TEXT NOT NULL,
|
|
"isSystem" BOOLEAN NOT NULL DEFAULT false,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "LlmPrompt_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "LlmPrompt_category_idx" ON "LlmPrompt"("category");
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "LlmPrompt_isSystem_idx" ON "LlmPrompt"("isSystem");
|