search

prisma / prisma

Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
https://www.prisma.io
Apache License 2.0
39.14k stars 1.53k forks source link

db pull creates invalid schema with CockroachDB and Ory #17166

Open OliverGeneser opened 1 year ago

OliverGeneser commented 1 year ago

Bug description

Prisma db pull creates a invalid prisma schema from a CockroachDB with Ory Kratos tables.

Error validating model "identity_verification_tokens": The constraint name 'identity_verification_tokens_identity_verifiable_addresses_id_fk' specified in the `map` argument for the `@relation` constraint is too long for your chosen provider. The maximum allowed length is 63 bytes.

How to reproduce

Expected behavior

I would expect a valid schema

Prisma information

// Add your schema.prisma
generator client {
  provider = "prisma-client-js"
}

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

model continuity_containers {
  id          String      @id @db.Uuid
  identity_id String?     @db.Uuid
  name        String      @db.String(255)
  payload     Json?
  expires_at  DateTime    @db.Timestamp(6)
  created_at  DateTime    @db.Timestamp(6)
  updated_at  DateTime    @db.Timestamp(6)
  nid         String?     @db.Uuid
  identities  identities? @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "continuity_containers_identities_id_fk")
  networks    networks?   @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "continuity_containers_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
}

model courier_messages {
  id            String    @id @db.Uuid
  type          BigInt
  status        BigInt
  subject       String    @db.String(255)
  recipient     String    @db.String(255)
  created_at    DateTime  @db.Timestamp(6)
  updated_at    DateTime  @db.Timestamp(6)
  body          String
  template_type String    @default("") @db.String(255)
  template_data Bytes?
  nid           String?   @db.Uuid
  send_count    BigInt    @default(0)
  networks      networks? @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "courier_messages_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
  @@index([status])
}

model identities {
  id                            String                          @id @db.Uuid
  schema_id                     String                          @db.String(2048)
  traits                        Json
  created_at                    DateTime                        @db.Timestamp(6)
  updated_at                    DateTime                        @db.Timestamp(6)
  nid                           String?                         @db.Uuid
  state                         String                          @default("active") @db.String(255)
  state_changed_at              DateTime?                       @db.Timestamp(6)
  metadata_public               Json?
  metadata_admin                Json?
  continuity_containers         continuity_containers[]
  networks                      networks?                       @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identities_nid_fk_idx")
  identity_credentials          identity_credentials[]
  identity_recovery_addresses   identity_recovery_addresses[]
  identity_recovery_codes       identity_recovery_codes[]
  identity_recovery_tokens      identity_recovery_tokens[]
  identity_verifiable_addresses identity_verifiable_addresses[]
  selfservice_recovery_flows    selfservice_recovery_flows[]
  selfservice_settings_flows    selfservice_settings_flows[]
  sessions                      sessions[]

  @@index([id, nid])
  @@index([nid, id])
}

model identity_credential_identifiers {
  id                          String                    @id @db.Uuid
  identifier                  String                    @db.String(255)
  identity_credential_id      String                    @db.Uuid
  created_at                  DateTime                  @db.Timestamp(6)
  updated_at                  DateTime                  @db.Timestamp(6)
  nid                         String?                   @db.Uuid
  identity_credential_type_id String                    @db.Uuid
  identity_credentials        identity_credentials      @relation(fields: [identity_credential_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_credential_identifiers_identity_credentials_id_fk")
  networks                    networks?                 @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_credential_identifiers_nid_fk_idx")
  identity_credential_types   identity_credential_types @relation(fields: [identity_credential_type_id], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_credential_identifiers_type_id_fk_idx")

  @@unique([nid, identity_credential_type_id, identifier], map: "identity_credential_identifiers_identifier_nid_type_uq_idx")
  @@index([id, nid])
  @@index([nid, id])
  @@index([identity_credential_id, nid], map: "identity_credential_identifiers_nid_identity_credential_id_idx")
}

model identity_credential_types {
  id                              String                            @id @db.Uuid
  name                            String                            @unique(map: "identity_credential_types_name_idx") @db.String(32)
  identity_credential_identifiers identity_credential_identifiers[]
  identity_credentials            identity_credentials[]
}

model identity_credentials {
  id                              String                            @id @db.Uuid
  config                          Json
  identity_credential_type_id     String                            @db.Uuid
  identity_id                     String                            @db.Uuid
  created_at                      DateTime                          @db.Timestamp(6)
  updated_at                      DateTime                          @db.Timestamp(6)
  nid                             String?                           @db.Uuid
  version                         BigInt                            @default(0)
  identity_credential_identifiers identity_credential_identifiers[]
  identities                      identities                        @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_credentials_identities_id_fk")
  identity_credential_types       identity_credential_types         @relation(fields: [identity_credential_type_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_credentials_identity_credential_types_id_fk")
  networks                        networks?                         @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_credentials_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
  @@index([identity_id, nid], map: "identity_credentials_nid_identity_id_idx")
}

model identity_recovery_addresses {
  id                       String                     @id @db.Uuid
  via                      String                     @db.String(16)
  value                    String                     @db.String(400)
  identity_id              String                     @db.Uuid
  created_at               DateTime                   @db.Timestamp(6)
  updated_at               DateTime                   @db.Timestamp(6)
  nid                      String?                    @db.Uuid
  identities               identities                 @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_recovery_addresses_identities_id_fk")
  networks                 networks?                  @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_recovery_addresses_nid_fk_idx")
  identity_recovery_codes  identity_recovery_codes[]
  identity_recovery_tokens identity_recovery_tokens[]

  @@unique([nid, via, value], map: "identity_recovery_addresses_status_via_uq_idx")
  @@index([id, nid])
  @@index([nid, id])
  @@index([identity_id, nid], map: "identity_recovery_addresses_nid_identity_id_idx")
  @@index([nid, via, value], map: "identity_recovery_addresses_status_via_idx")
}

model identity_recovery_codes {
  id                           String                       @id @db.Uuid
  code                         String                       @db.String(64)
  used_at                      DateTime?                    @db.Timestamp(6)
  identity_recovery_address_id String?                      @db.Uuid
  code_type                    BigInt
  expires_at                   DateTime                     @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  issued_at                    DateTime                     @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  selfservice_recovery_flow_id String                       @db.Uuid
  created_at                   DateTime                     @db.Timestamp(6)
  updated_at                   DateTime                     @db.Timestamp(6)
  nid                          String                       @db.Uuid
  identity_id                  String                       @db.Uuid
  identities                   identities                   @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_recovery_codes_identity_id_fk")
  identity_recovery_addresses  identity_recovery_addresses? @relation(fields: [identity_recovery_address_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_recovery_codes_identity_recovery_addresses_id_fk")
  networks                     networks                     @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_recovery_codes_networks_id_fk")
  selfservice_recovery_flows   selfservice_recovery_flows   @relation(fields: [selfservice_recovery_flow_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_recovery_codes_selfservice_recovery_flows_id_fk")

  @@index([id, nid])
  @@index([nid, selfservice_recovery_flow_id], map: "identity_recovery_codes_nid_flow_id_idx")
}

model identity_recovery_tokens {
  id                           String                       @id @db.Uuid
  token                        String                       @unique(map: "identity_recovery_addresses_code_uq_idx") @db.String(64)
  used                         Boolean                      @default(false)
  used_at                      DateTime?                    @db.Timestamp(6)
  created_at                   DateTime                     @db.Timestamp(6)
  updated_at                   DateTime                     @db.Timestamp(6)
  expires_at                   DateTime                     @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  issued_at                    DateTime                     @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  selfservice_recovery_flow_id String?                      @db.Uuid
  nid                          String?                      @db.Uuid
  identity_recovery_address_id String?                      @db.Uuid
  identity_id                  String                       @db.Uuid
  token_type                   BigInt                       @default(0)
  identities                   identities                   @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_recovery_tokens_identity_id_fk_idx")
  identity_recovery_addresses  identity_recovery_addresses? @relation(fields: [identity_recovery_address_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_recovery_tokens_identity_recovery_addresses_id_fk")
  networks                     networks?                    @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_recovery_tokens_nid_fk_idx")
  selfservice_recovery_flows   selfservice_recovery_flows?  @relation(fields: [selfservice_recovery_flow_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_recovery_tokens_selfservice_recovery_requests_id_fk")

  @@index([id, nid])
  @@index([identity_recovery_address_id])
  @@index([nid, id])
  @@index([selfservice_recovery_flow_id])
  @@index([nid, token, used], map: "identity_recovery_tokens_token_nid_used_idx")
}

model identity_verifiable_addresses {
  id                           String                         @id @db.Uuid
  status                       String                         @db.String(16)
  via                          String                         @db.String(16)
  verified                     Boolean
  value                        String                         @db.String(400)
  verified_at                  DateTime?                      @db.Timestamp(6)
  identity_id                  String                         @db.Uuid
  created_at                   DateTime                       @db.Timestamp(6)
  updated_at                   DateTime                       @db.Timestamp(6)
  nid                          String?                        @db.Uuid
  identities                   identities                     @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_verifiable_addresses_identities_id_fk")
  networks                     networks?                      @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_verifiable_addresses_nid_fk_idx")
  identity_verification_codes  identity_verification_codes[]
  identity_verification_tokens identity_verification_tokens[]

  @@unique([nid, via, value], map: "identity_verifiable_addresses_status_via_uq_idx")
  @@index([id, nid])
  @@index([nid, id])
  @@index([identity_id, nid], map: "identity_verifiable_addresses_nid_identity_id_idx")
  @@index([nid, via, value], map: "identity_verifiable_addresses_status_via_idx")
}

model identity_verification_codes {
  id                               String                         @id @db.Uuid
  code_hmac                        String                         @db.String(64)
  used_at                          DateTime?                      @db.Timestamp(6)
  identity_verifiable_address_id   String?                        @db.Uuid
  expires_at                       DateTime                       @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  issued_at                        DateTime                       @default(dbgenerated("'2000-01-01 00:00:00'::TIMESTAMP")) @db.Timestamp(6)
  selfservice_verification_flow_id String                         @db.Uuid
  created_at                       DateTime                       @db.Timestamp(6)
  updated_at                       DateTime                       @db.Timestamp(6)
  nid                              String                         @db.Uuid
  identity_verifiable_addresses    identity_verifiable_addresses? @relation(fields: [identity_verifiable_address_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_verification_codes_identity_verifiable_addresses_id_fk")
  networks                         networks                       @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_verification_codes_networks_id_fk")
  selfservice_verification_flows   selfservice_verification_flows @relation(fields: [selfservice_verification_flow_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_verification_codes_selfservice_verification_flows_id_fk")

  @@index([id, nid])
  @@index([nid, selfservice_verification_flow_id], map: "identity_verification_codes_nid_flow_id_idx")
}

model identity_verification_tokens {
  id                               String                         @id @db.Uuid
  token                            String                         @unique(map: "identity_verification_tokens_token_uq_idx") @db.String(64)
  used                             Boolean                        @default(false)
  used_at                          DateTime?                      @db.Timestamp(6)
  expires_at                       DateTime                       @db.Timestamp(6)
  issued_at                        DateTime                       @db.Timestamp(6)
  identity_verifiable_address_id   String                         @db.Uuid
  selfservice_verification_flow_id String                         @db.Uuid
  created_at                       DateTime                       @db.Timestamp(6)
  updated_at                       DateTime                       @db.Timestamp(6)
  nid                              String?                        @db.Uuid
  identity_verifiable_addresses    identity_verifiable_addresses  @relation(fields: [identity_verifiable_address_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_verification_tokens_identity_verifiable_addresses_id_fk")
  networks                         networks?                      @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "identity_verification_tokens_nid_fk_idx")
  selfservice_verification_flows   selfservice_verification_flows @relation(fields: [selfservice_verification_flow_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "identity_verification_tokens_selfservice_verification_flows_id_fk")

  @@index([id, nid])
  @@index([nid, id])
  @@index([nid, token, used, selfservice_verification_flow_id], map: "identity_verification_tokens_token_nid_used_flow_id_idx")
  @@index([identity_verifiable_address_id], map: "identity_verification_tokens_verifiable_address_id_idx")
  @@index([selfservice_verification_flow_id], map: "identity_verification_tokens_verification_flow_id_idx")
}

model item {
  id        BigInt   @id @default(autoincrement())
  name      String   @unique
  createdAt DateTime @default(now())
}

model networks {
  id                              String                            @id @db.Uuid
  created_at                      DateTime                          @db.Timestamp(6)
  updated_at                      DateTime                          @db.Timestamp(6)
  continuity_containers           continuity_containers[]
  courier_messages                courier_messages[]
  identities                      identities[]
  identity_credential_identifiers identity_credential_identifiers[]
  identity_credentials            identity_credentials[]
  identity_recovery_addresses     identity_recovery_addresses[]
  identity_recovery_codes         identity_recovery_codes[]
  identity_recovery_tokens        identity_recovery_tokens[]
  identity_verifiable_addresses   identity_verifiable_addresses[]
  identity_verification_codes     identity_verification_codes[]
  identity_verification_tokens    identity_verification_tokens[]
  selfservice_errors              selfservice_errors[]
  selfservice_login_flows         selfservice_login_flows[]
  selfservice_recovery_flows      selfservice_recovery_flows[]
  selfservice_registration_flows  selfservice_registration_flows[]
  selfservice_settings_flows      selfservice_settings_flows[]
  selfservice_verification_flows  selfservice_verification_flows[]
  session_devices                 session_devices[]
  sessions                        sessions[]
}

model schema_migration {
  version      String @unique(map: "schema_migration_version_idx") @db.String(48)
  version_self BigInt @default(0)

  @@index([version_self])
}

model selfservice_errors {
  id         String    @id @db.Uuid
  errors     Json
  was_seen   Boolean
  created_at DateTime  @db.Timestamp(6)
  updated_at DateTime  @db.Timestamp(6)
  csrf_token String    @default("") @db.String(255)
  seen_at    DateTime? @db.Timestamp(6)
  nid        String?   @db.Uuid
  networks   networks? @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_errors_nid_fk_idx")

  @@index([id, nid], map: "selfservice_errors_nid_idx")
}

model selfservice_login_flows {
  id                     String    @id(map: "selfservice_login_requests_pkey") @db.Uuid
  request_url            String    @db.String(2048)
  issued_at              DateTime  @default(now()) @db.Timestamp(6)
  expires_at             DateTime  @db.Timestamp(6)
  active_method          String    @db.String(32)
  csrf_token             String    @db.String(255)
  created_at             DateTime  @db.Timestamp(6)
  updated_at             DateTime  @db.Timestamp(6)
  forced                 Boolean   @default(false)
  type                   String    @default("browser") @db.String(16)
  ui                     Json?
  nid                    String?   @db.Uuid
  requested_aal          String    @default("aal1") @db.String(4)
  internal_context       Json
  oauth2_login_challenge String?   @db.Uuid
  networks               networks? @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_login_flows_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
}

model selfservice_recovery_flows {
  id                       String                     @id(map: "selfservice_recovery_requests_pkey") @db.Uuid
  request_url              String                     @db.String(2048)
  issued_at                DateTime                   @default(now()) @db.Timestamp(6)
  expires_at               DateTime                   @db.Timestamp(6)
  active_method            String?                    @db.String(32)
  csrf_token               String                     @db.String(255)
  state                    String                     @db.String(32)
  recovered_identity_id    String?                    @db.Uuid
  created_at               DateTime                   @db.Timestamp(6)
  updated_at               DateTime                   @db.Timestamp(6)
  type                     String                     @default("browser") @db.String(16)
  ui                       Json?
  nid                      String?                    @db.Uuid
  submit_count             BigInt                     @default(0)
  skip_csrf_check          Boolean                    @default(false)
  identity_recovery_codes  identity_recovery_codes[]
  identity_recovery_tokens identity_recovery_tokens[]
  networks                 networks?                  @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_recovery_flows_nid_fk_idx")
  identities               identities?                @relation(fields: [recovered_identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "selfservice_recovery_requests_identities_id_fk")

  @@index([id, nid])
  @@index([nid, id])
}

model selfservice_registration_flows {
  id                     String    @id(map: "selfservice_registration_requests_pkey") @db.Uuid
  request_url            String    @db.String(2048)
  issued_at              DateTime  @default(now()) @db.Timestamp(6)
  expires_at             DateTime  @db.Timestamp(6)
  active_method          String    @db.String(32)
  csrf_token             String    @db.String(255)
  created_at             DateTime  @db.Timestamp(6)
  updated_at             DateTime  @db.Timestamp(6)
  type                   String    @default("browser") @db.String(16)
  ui                     Json?
  nid                    String?   @db.Uuid
  internal_context       Json
  oauth2_login_challenge String?   @db.Uuid
  networks               networks? @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_registration_flows_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
}

model selfservice_settings_flows {
  id               String     @id(map: "selfservice_profile_management_requests_pkey") @db.Uuid
  request_url      String     @db.String(2048)
  issued_at        DateTime   @default(now()) @db.Timestamp(6)
  expires_at       DateTime   @db.Timestamp(6)
  identity_id      String     @db.Uuid
  created_at       DateTime   @db.Timestamp(6)
  updated_at       DateTime   @db.Timestamp(6)
  active_method    String?    @db.String(32)
  state            String     @default("show_form") @db.String(255)
  type             String     @default("browser") @db.String(16)
  ui               Json?
  nid              String?    @db.Uuid
  internal_context Json
  identities       identities @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "selfservice_profile_management_requests_identities_id_fk")
  networks         networks?  @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_settings_flows_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
}

model selfservice_verification_flows {
  id                           String                         @id(map: "selfservice_verification_requests_pkey") @db.Uuid
  request_url                  String                         @db.String(2048)
  issued_at                    DateTime                       @default(now()) @db.Timestamp(6)
  expires_at                   DateTime                       @db.Timestamp(6)
  csrf_token                   String                         @db.String(255)
  created_at                   DateTime                       @db.Timestamp(6)
  updated_at                   DateTime                       @db.Timestamp(6)
  type                         String                         @default("browser") @db.String(16)
  state                        String                         @default("show_form") @db.String(255)
  active_method                String?                        @db.String(32)
  ui                           Json?
  nid                          String?                        @db.Uuid
  submit_count                 BigInt                         @default(0)
  identity_verification_codes  identity_verification_codes[]
  identity_verification_tokens identity_verification_tokens[]
  networks                     networks?                      @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "selfservice_verification_flows_nid_fk_idx")

  @@index([id, nid])
  @@index([nid, id])
}

model session_devices {
  id         String   @id @db.Uuid
  ip_address String?  @default("") @db.String(50)
  user_agent String?  @default("") @db.String(512)
  location   String?  @default("") @db.String(512)
  nid        String   @db.Uuid
  session_id String   @db.Uuid
  created_at DateTime @db.Timestamp(6)
  updated_at DateTime @db.Timestamp(6)
  networks   networks @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "session_metadata_nid_fk")
  sessions   sessions @relation(fields: [session_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "session_metadata_sessions_id_fk")

  @@unique([nid, session_id, ip_address, user_agent], map: "unique_session_device")
  @@index([id, nid])
  @@index([session_id, nid])
}

model sessions {
  id                     String            @id @db.Uuid
  issued_at              DateTime          @default(now()) @db.Timestamp(6)
  expires_at             DateTime          @db.Timestamp(6)
  authenticated_at       DateTime          @db.Timestamp(6)
  identity_id            String            @db.Uuid
  created_at             DateTime          @db.Timestamp(6)
  updated_at             DateTime          @db.Timestamp(6)
  token                  String?           @unique(map: "sessions_token_uq_idx") @db.String(32)
  active                 Boolean?          @default(false)
  nid                    String?           @db.Uuid
  logout_token           String?           @unique(map: "sessions_logout_token_uq_idx") @db.String(32)
  aal                    String            @default("aal1") @db.String(4)
  authentication_methods Json
  session_devices        session_devices[]
  identities             identities        @relation(fields: [identity_id], references: [id], onDelete: Cascade, onUpdate: NoAction, map: "sessions_identities_id_fk")
  networks               networks?         @relation(fields: [nid], references: [id], onDelete: Cascade, onUpdate: Restrict, map: "sessions_nid_fk_idx")

  @@index([id, nid])
  @@index([identity_id, nid])
  @@index([nid, identity_id, id], map: "sessions_nid_id_identity_id_idx")
  @@index([nid, token], map: "sessions_token_nid_idx")
}

Environment & setup

Prisma Version

4.8.1
janpio commented 1 year ago

Can you maybe point us to the SQL of Ory Kratos? That would be helpful for us to reproduce and understand what might be happening here (Probably a configuration difference between PostgreSQL and CockroachDB we overlooked)

OliverGeneser commented 1 year ago

@janpio I have their SQL migration files for CockroachDB :blush: SQL Migrations.zip