user/prisma/migrations/20221214110358_init/migration.sql

15 lines
380 B
MySQL
Raw Permalink Normal View History

2022-12-13 14:27:28 +00:00
-- CreateTable
CREATE TABLE "user" (
"uuid" UUID NOT NULL,
"firstName" TEXT NOT NULL,
"lastName" TEXT NOT NULL,
2022-12-14 11:10:27 +00:00
"email" TEXT NOT NULL,
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
"updatedAt" TIMESTAMP(3) NOT NULL,
2022-12-13 14:27:28 +00:00
2022-12-14 11:10:27 +00:00
CONSTRAINT "user_pkey" PRIMARY KEY ("uuid")
);
2022-12-14 10:37:13 +00:00
-- CreateIndex
CREATE UNIQUE INDEX "user_email_key" ON "user"("email");