eletrotupi / tcc/ api/prisma/migrations/0_init/migration.sql5d3a948a62b58c6efa324ee655ba869f04eb466b
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