PrismaP
Prisma16mo ago
LOKIZE

Drift detected but no changes in schema

Drift detected: Your database schema is not in sync with your migration history.

The following is a summary of the differences between the expected database schema given your migrations files, and the actual schema of the database.

It should be understood as the set of changes to get from the expected schema to the actual schema.

[*] Changed the 
pedido_permissao
 table
  [*] Renamed the foreign key "pedido_permissao_relation_1" to "pedido_permissao_pedido"
  [*] Renamed the foreign key "pedido_permissao_relation_2" to "pedido_permissao_usuario"


My schema:

model pedido_permissao {
  id                                        String   @id @default(dbgenerated("nanoid()")) @db.VarChar(21)
  pedido                                    String
  usuario                                   String
  criadoem                                  DateTime @default(now()) @db.Timestamptz(3)
  atualizadoem                              DateTime @updatedAt
  pedido_pedido_permissao_pedidoTopedido    pedido   @relation("pedido_permissao_pedidoTopedido", fields: [pedido], references: [id], onDelete: NoAction, onUpdate: NoAction, map: "pedido_permissao_relation_1")
  usuario_pedido_permissao_usuarioTousuario usuario  @relation("pedido_permissao_usuarioTousuario", fields: [usuario], references: [id], onDelete: NoAction, onUpdate: NoAction, map: "pedido_permissao_relation_2")
}


In the database, there is pedido_permissao_relation_1 and pedido_permissao_relation_2, and I no longer know how to solve this problem.
Was this page helpful?