17 lines
407 B
SQL
17 lines
407 B
SQL
-- CreateTable
|
|
CREATE TABLE "Author" (
|
|
"id" TEXT NOT NULL,
|
|
"displayName" TEXT NOT NULL,
|
|
"bio" TEXT,
|
|
"avatarUrl" TEXT,
|
|
"order" INTEGER NOT NULL DEFAULT 0,
|
|
"okUrl" TEXT,
|
|
"vkUrl" TEXT,
|
|
"websiteUrl" TEXT,
|
|
"email" TEXT,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
|
|
CONSTRAINT "Author_pkey" PRIMARY KEY ("id")
|
|
);
|