Why can't I migrate where the .. line is?

Question

symfony

Can you please tell me why I can't migrate where there is a line:
CHANGE id id INT UNSIGNED AUTO_INCREMENT NOT NULL
There is an error

General error: 1833 Cannot change column 'id': used in a foreign key constraint 'FK_92C4739C69F4B775' of table 'aggr.provider'

Answer 1

It's all written in error. The foreign key is used. If you want to manipulate this column, you need to remove the FK, and then add it again if you need it.