ilkkao/mas

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "postgresql"
  url      = env("POSTGRES__DATABASE_URL")
}

model User {
  createdAt    DateTime  @default(now())
  updatedAt    DateTime? @updatedAt
  deletedAt    DateTime?
  lastLogoutAt DateTime?
  id           Int       @id @default(autoincrement())
  name         String    @db.VarChar(64)
  nick         String    @db.VarChar(32)
  email        String    @unique @db.VarChar(64)
  emailMD5     String    @db.VarChar(32)
  password     String?   @db.VarChar(128)
  extAuthId    String?
  status       Status
  canUseIRC    Boolean   @default(false)

  @@index([email])
  @@index([nick])
  @@index([extAuthId])
}

enum Status {
  REGISTERED
  CONFIRMED
  DELETED
}