PlanetScale drizzle-kit push: Cannot drop index: needed in a foreign key constraint

DROP INDEX `unique_name` ON `table1`;
ALTER TABLE `table1` ADD CONSTRAINT `unique_name` UNIQUE(`table2_id`,`name`);

Cannot drop index 'unique_name': needed in a foreign key constraint (errno 1553)

import { foreignKey, mysqlTable, unique, varchar } from 'drizzle-orm/mysql-core'

export const table1 = mysqlTable(
  'table1',
  {
    id: varchar('id', { length: 256 }).primaryKey(),
    table2Id: varchar('table2_id', { length: 256 }).notNull(),
    name: varchar('name', { length: 256 }).notNull(),
  },
  (table) => ({
    table2Fk: foreignKey({
      columns: [table.table2Id],
      foreignColumns: [table2.id],
      name: 'table1_table2_fk',
    }).onDelete('cascade'),
    uniqueName: unique('unique_name').on(table.table2Id, table.name),
  })
)

export const table2 = mysqlTable('table2', {
  id: varchar('id', { length: 256 }).primaryKey(),
})