How can I edit the sql commands of symfony doctrine when updating a schema?

  mysql, php, sql, symfony, symfony4

I have the following error when I’m trying to update my database schema :

SQLSTATE[HY000]: General error: 1833 Cannot change column 'IdEcole': used in a foreign key constraint 'appartient_ibfk_2' of table 'tuteure.appartient' 

However, I don’t have anything that make the IdEcole AUTO_INCREMENT (in database or in my Entitites, only in the migrations.

When I execute the following line php bin/console doctrine:schema:update --dump-sql I have the following response :

ALTER TABLE Ecole CHANGE IdEcole IdEcole INT AUTO_INCREMENT NOT NULL;

So how can I edit this line to delete it ? Where is this line stored and where it comes from ?

Source: Symfony Questions

LEAVE A COMMENT