on cascade delete issue with multiple foreign keys and migrations

export const table1 = mysqlTable('table1', {
    id: int('id').primaryKey().autoincrement()
});

export const table2 = mysqlTable('table2', {
    id: int('id').primaryKey().autoincrement(),
    fk1: int('fk1')
        .references((): AnyMySqlColumn => table1.id)
        .notNull(),
    fk2: int('fk2')
        .references((): AnyMySqlColumn => table1.id)
        .notNull()
});

// 0001_neat_thena.sql
ALTER TABLE `table2` DROP FOREIGN KEY `table2_fk1_table1_id_fk`;
--> statement-breakpoint
ALTER TABLE `table2` ADD CONSTRAINT `table2_fk1_table1_id_fk` FOREIGN KEY (`fk1`) REFERENCES `table1`(`id`) ON DELETE cascade ON UPDATE no action;