Hi, i am with a problems to run migrations with a 3.1.2 version of the phalcon and devtools, the current version of devtools doesn't recognize type Enum of the Mysql Server. the others problems is the migration are executing alter table in columns that don't have difference and this are creating throw exceptions inside of devtools. The other problem is the create table created by devtools with invalid sintax. The team of Phalcon have a prevision of the next version of devtools? Or Anybody know another tools to make migrations that be trusted?
My Zephir (0.97)
CREATE TABLE `bmq`.`crmMeta` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `nome` VARCHAR(45), `descricao` TEXT, `valor` DOUBLE(10) NOT NULL, `tipo` INT(11) NOT NULL, `data_inicio` DATETIME, `data_fim` DATETIME, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ciERROR: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NOT NULL, `tipo` INT(11) NOT NULL, `data_inicio` DATETIME, `data_fim` DATET' at line 5
In this case the devtools are applying alter table in the column that don't have modifications, dont have difference.
1495054638.3138: ALTER TABLE `temp_importacao_di` MODIFY `datadi` DATE NOT NULL AFTER `numerodi`ERROR: SQLSTATE: Null value not allowed: 1138 Invalid use of NULL value