38 lines
976 B
SQL
38 lines
976 B
SQL
-- CreateTable
|
|
CREATE TABLE "users" (
|
|
"id" TEXT NOT NULL,
|
|
"resendId" TEXT NOT NULL,
|
|
"email" TEXT NOT NULL,
|
|
"code" TEXT NOT NULL,
|
|
"confirmed" BOOLEAN NOT NULL DEFAULT false,
|
|
"deleted" BOOLEAN NOT NULL DEFAULT false,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"lastMail" TIMESTAMP(3),
|
|
|
|
CONSTRAINT "users_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "news" (
|
|
"id" DOUBLE PRECISION NOT NULL,
|
|
"title" TEXT NOT NULL,
|
|
"text" TEXT,
|
|
"type" TEXT NOT NULL,
|
|
"by" TEXT NOT NULL,
|
|
"time" DOUBLE PRECISION NOT NULL,
|
|
"url" TEXT,
|
|
"score" DOUBLE PRECISION NOT NULL,
|
|
"created_at" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
CONSTRAINT "news_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "users_email_key" ON "users"("email");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "users_code_key" ON "users"("code");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "news_id_key" ON "news"("id");
|