{"action":"created","issue":{"url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/561","labels_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/561/labels{/name}","comments_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/561/comments","events_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/561/events","html_url":"https://github.com/phalcon/phalcon-devtools/issues/561","id":115909389,"number":561,"title":"migration generate dumps mysql timestamp and enums to wrong types and size","user":{"login":"Dublerq","id":13312449,"avatar_url":"https://avatars.githubusercontent.com/u/13312449?v=3","gravatar_id":"","url":"https://api.github.com/users/Dublerq","html_url":"https://github.com/Dublerq","followers_url":"https://api.github.com/users/Dublerq/followers","following_url":"https://api.github.com/users/Dublerq/following{/other_user}","gists_url":"https://api.github.com/users/Dublerq/gists{/gist_id}","starred_url":"https://api.github.com/users/Dublerq/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Dublerq/subscriptions","organizations_url":"https://api.github.com/users/Dublerq/orgs","repos_url":"https://api.github.com/users/Dublerq/repos","events_url":"https://api.github.com/users/Dublerq/events{/privacy}","received_events_url":"https://api.github.com/users/Dublerq/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-11-09T16:12:24Z","updated_at":"2015-11-10T06:49:30Z","closed_at":null,"body":"On my PC Windows instance of Phalcon and Devtools mirgration generates `TIMESTAMP` as `VARCHAR(1)`:\r\n```php\r\nnew Column(\r\n    'time',\r\n    array(\r\n        'type' => Column::TYPE_VARCHAR,\r\n        'default' => 'CURRENT_TIMESTAMP',\r\n        'notNull' => true,\r\n        'size' => 1,\r\n        'after' => 'ip'\r\n    )\r\n);\r\n```\r\nand `enum(str1,str,2,str3,str4)` as `char(1)`:\r\n```php\r\nnew Column(\r\n    'type',\r\n    array(\r\n        'type' => Column::TYPE_CHAR,\r\n        'notNull' => true,\r\n        'size' => 1,\r\n        'after' => 'id'\r\n    )\r\n);\r\n```\r\n\r\nSame happened to friend of mine on his VPS with Debian. On the other hand on my private VPS with Debian 7 and in my office on Windows 7 works great. No idea what causes the problem. \r\n\r\nWe're using the newest versions of software on our devices."},"comment":{"url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/comments/155325407","html_url":"https://github.com/phalcon/phalcon-devtools/issues/561#issuecomment-155325407","issue_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/561","id":155325407,"user":{"login":"sergeyklay","id":1256298,"avatar_url":"https://avatars.githubusercontent.com/u/1256298?v=3","gravatar_id":"","url":"https://api.github.com/users/sergeyklay","html_url":"https://github.com/sergeyklay","followers_url":"https://api.github.com/users/sergeyklay/followers","following_url":"https://api.github.com/users/sergeyklay/following{/other_user}","gists_url":"https://api.github.com/users/sergeyklay/gists{/gist_id}","starred_url":"https://api.github.com/users/sergeyklay/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sergeyklay/subscriptions","organizations_url":"https://api.github.com/users/sergeyklay/orgs","repos_url":"https://api.github.com/users/sergeyklay/repos","events_url":"https://api.github.com/users/sergeyklay/events{/privacy}","received_events_url":"https://api.github.com/users/sergeyklay/received_events","type":"User","site_admin":false},"created_at":"2015-11-10T06:49:30Z","updated_at":"2015-11-10T06:49:30Z","body":"Double check with Phalcon `2.0.x` and Devtools `2.0.x`. I've fixed TIMESTAMP issue https://github.com/phalcon/phalcon-devtools/issues/429#issuecomment-135962317"}}