time field causes errors about migrations

[predominant]

Placed on hold. Waiting for more information.

[neterslandreau]

This is the error:
[005] 003_change_the_parties_times_from_varchar_to_time
> Changing field start_time from parties.

Query: ALTER TABLE `parties` 
        CHANGE `start_time` `start_time` time(255) DEFAULT NULL;

 

An error occurred when processing the migration:

Migration: 003_change_the_parties_times_from_varchar_to_time
Error: SQL Error: 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 '(255) DEFAULT NULL' at line 2

The migration script is:
public $migration = array(
'up' => array(
'alter_field' => array(
'parties' => array(
'start_time' => array('type' => 'time', 'null' => true, 'default' => NULL),
'end_time' => array('type' => 'time', 'null' => true, 'default' => NULL),
),
),
),
'down' => array(
'alter_field' => array(
'parties' => array(
'start_time' => array('type' => 'string', 'length' => 255),
'end_time' => array('type' => 'string', 'length' => 255),
),
),
),
);

[renan]

Actually the CakePHP schema does not support time columns, that's why its does not works.
In order to make it work, CakePHP schema first needs to implement time columns.

Thank you.