Connecting a PlanetScale DB with Prisma

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20generator client {
  provider = "prisma-client-js"
  // previewFeatures = ["referentialIntegrity"] //PlanetScale doesn't support foreign keys the way MySQL does, so this line should be added, but the current version seems to support it automatically
}

datasource db {
  provider     = "mysql"
  url          = env("DATABASE_URL")
  relationMode = "prisma" // Relations are checked through Prisma.
}

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

1npx prisma db push