prisma集成sqlite

连接数据库

bash

datasource db {
    // 指定sqlite数据库
    provider = "sqlite"
    // 连接数据库 "file:./dev.db"
    url      = env("DATABASE_URL")
}

创建表

bash

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique
  name      String?
  createdAt DateTime @default(now())
  updatedAt DateTime @updatedAt
}