[BUG]: generating too long foreign key names

[ghostebony]

What version of drizzle-orm are you using?

0.24.2

What version of drizzle-kit are you using?

0.17.5

Describe the Bug

When generating foreign key names, exceeds the max 64 characters allowed. Here is the demo code, line 35 the generated name is 73 characters

I'm using mysql, when I run the migration I get this error:

Error: Identifier name 'long_table_name_child_parentId_parentId2_long_table_name_parent_id_id2_fk' is too long

somewhat related to #466

Expected behavior

No response

Environment & setup

No response