Changing history of Yii2 migrations?

Question

Yii

It's already night, I decided to read the documentation, but apparently I'm very stupid. Please tell me in what cases it may be necessary to change the migration history?

And another question. Let's say I created the news table, already filled it with data, and after a week I decide to change the type of the content field from text to longtext. How can I do this without losing data? Is it possible somehow to make such changes in my favorite phpmyadmin, and then make it so that it is taken into account in the history of migrations.? Or is it not possible to do without creating a new migration?

Answer 1

You can also perform this type change without rolling back the migration.
1. Change the field type in the database (text -> longtext) using PMA - it will work without problems (if you're afraid - make a backup).
2. Manually correct the field type in the migration file
- if it was then replace it with (or 'MEDIUMTEXT', if you need less). Everything will work! If you need a reinforced concrete version, then 1. Create a new migration file, 2. Specify in it the command to change the field type in the database. Cons: - extra migration file.