Relations mysql Name

I am trying to use relations in drizzle and I want to have the foreign keys setup in mysql.

I currently have a setup like this but when generating migratin files (drizzle-kit) it is causing foreign key names which are too long (mysql max 64). I cannot see anyway in the docs to name the specific foreign key and it would be painful if i had to manually change the foriegn key name in every generated migration each time.

  customerId: varchar("customer_id", { length: 36 })
    .notNull()
    .references(() => customers.id, {
      onDelete: "cascade",
    }),

  customerId: varchar("customer_id", { length: 36 })
    .notNull()
    .references(() => customers.id, {
      onDelete: "cascade",
    }),

  customerId: varchar("customer_id", { length: 36 })
    .notNull()
    .references(() => customers.id, {
      onDelete: "cascade",
    }),

  customerId: varchar("customer_id", { length: 36 })
    .notNull()
    .references(() => customers.id, {
      onDelete: "cascade",
    }),

No replies yetBe the first to reply to this messageJoin

Relations mysql Name

Similar Threads

Similar Threads

Similar Threads