eletrotupi / tcc/ api/prisma/migrations/0_init/migration.sql6e7ecd390ce119d438ab5b3ab16fa1d9edeb434a
388 B | 14 lines Raw
1
-- CreateTable
2
CREATE TABLE "users" (
3
    "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
4
    "first_name" TEXT NOT NULL,
5
    "last_name" TEXT,
6
    "email" TEXT NOT NULL,
7
    "encrypted_password" TEXT NOT NULL,
8
    "created_at" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
9
    "updated_at" DATETIME NOT NULL
10
);
11

12
-- CreateIndex
13
CREATE UNIQUE INDEX "users_email_key" ON "users"("email");
14