Blitzを使用する際にデータベースのテーブル名やカラム名の命名規則を修正する

// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema

datasource db {
  provider = "sqlite"
  url      = env("DATABASE_URL")
}

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

// --------------------------------------

model User {
  id             Int      @id @default(autoincrement())
  createdAt      DateTime @default(now()) @map("created_at")
  updatedAt      DateTime @updatedAt @map("updated_at")
  name           String?
  email          String   @unique
  hashedPassword String?  @map("hashed_password")
  role           String   @default("USER")

  tokens   Token[]
  sessions Session[]

  @@map("users")
}

model Session {
  id                 Int       @id @default(autoincrement())
  createdAt          DateTime  @default(now()) @map("created_at")
  updatedAt          DateTime  @updatedAt @map("updated_at")
  expiresAt          DateTime? @map("expires_at")
  handle             String    @unique
  hashedSessionToken String?   @map("hashed_session_token")
  antiCSRFToken      String?   @map("anti_csrf_token")
  publicData         String?   @map("public_data")
  privateData        String?   @map("private_data")

  user   User? @relation(fields: [userId], references: [id])
  userId Int?  @map("user_id")

  @@map("sessions")
}

model Token {
  id          Int      @id @default(autoincrement())
  createdAt   DateTime @default(now()) @map("created_at")
  updatedAt   DateTime @updatedAt @map("updated_at")
  hashedToken String   @map("hashed_token")
  type        String
  // See note below about TokenType enum
  // type        TokenType
  expiresAt   DateTime @map("expires_at")
  sentTo      String   @map("sent_to")

  user   User @relation(fields: [userId], references: [id])
  userId Int  @map("user_id")

  @@unique([hashedToken, type])
  @@map("tokens")
}

// NOTE: It's highly recommended to use an enum for the token type
//       but enums only work in Postgres.
//       See: https://blitzjs.com/docs/database-overview#switch-to-postgresql
// enum TokenType {
//   RESET_PASSWORD
// }

$ blitz prisma generate
$ blitz prisma migrate dev
...
Do you want to continue? All data will be lost. … yes
✔ Enter a name for the new migration: … create_initial_table