DT
Drizzle Team•4d ago
MrGreyKnight

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",
    }),
0 Replies
No replies yetBe the first to reply to this messageJoin

Did you find this page helpful?