I've some db version say 1.0.7.
I need total refactoring: rename/drop/add tables and columns, change columns type (say, from bigint(20) to tinyint(2) or from varchar(45) to bigint(20) unsigned). This will be version 2.0.0 of course.
But i need to use old data. In this case i have four questions:
- Can devtools migrations do this automatically?
- If yes, where i must write convertation logic? If no, where i can find full documentation of how to use phalcon DBAL to write my own cli migration?
- Can i do all the stuff with phalcon DBAL or i need to use raw sql queries instead?
btw, official documentation ( http://docs.phalconphp.com/en/latest/reference/migrations.html ) is VERY old and kind of useless.