{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/migrations/issues/64","labels_url":"https://api.github.com/repos/cakephp/migrations/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/migrations/issues/64/comments","events_url":"https://api.github.com/repos/cakephp/migrations/issues/64/events","html_url":"https://github.com/cakephp/migrations/issues/64","id":65065179,"number":64,"title":"Table not generated with Sqlite and an id:uuid","user":{"login":"kevinliteon","id":3115254,"avatar_url":"https://avatars.githubusercontent.com/u/3115254?v=3","gravatar_id":"","url":"https://api.github.com/users/kevinliteon","html_url":"https://github.com/kevinliteon","followers_url":"https://api.github.com/users/kevinliteon/followers","following_url":"https://api.github.com/users/kevinliteon/following{/other_user}","gists_url":"https://api.github.com/users/kevinliteon/gists{/gist_id}","starred_url":"https://api.github.com/users/kevinliteon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevinliteon/subscriptions","organizations_url":"https://api.github.com/users/kevinliteon/orgs","repos_url":"https://api.github.com/users/kevinliteon/repos","events_url":"https://api.github.com/users/kevinliteon/events{/privacy}","received_events_url":"https://api.github.com/users/kevinliteon/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cakephp/migrations/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":7,"created_at":"2015-03-29T14:16:15Z","updated_at":"2015-03-30T01:53:47Z","closed_at":null,"body":"It seems that the table is not created with an id uuid and Sqlite.\r\nfor example:\r\n\r\n``` php\r\n// after a composer create-project\r\n// app.php\r\n// [...]\r\n 'default' => [\r\n            'className' => 'Cake\\Database\\Connection',\r\n            'driver' => 'Cake\\Database\\Driver\\Sqlite',\r\n            'persistent' => false,\r\n            'database' => 'my_app.sqlite',\r\n            'encoding' => 'utf8',\r\n            'timezone' => 'UTC',\r\n            'cacheMetadata' => true,\r\n            'quoteIdentifiers' => false,\r\n        ],\r\n```\r\n```\r\n\r\nbin\\cake bake migration CreateUsers id:uuid email:string username:string password:string created modified\r\nbin\\cake migrations migrate\r\n```"},"comment":{"url":"https://api.github.com/repos/cakephp/migrations/issues/comments/87511105","html_url":"https://github.com/cakephp/migrations/issues/64#issuecomment-87511105","issue_url":"https://api.github.com/repos/cakephp/migrations/issues/64","id":87511105,"user":{"login":"markstory","id":24086,"avatar_url":"https://avatars.githubusercontent.com/u/24086?v=3","gravatar_id":"","url":"https://api.github.com/users/markstory","html_url":"https://github.com/markstory","followers_url":"https://api.github.com/users/markstory/followers","following_url":"https://api.github.com/users/markstory/following{/other_user}","gists_url":"https://api.github.com/users/markstory/gists{/gist_id}","starred_url":"https://api.github.com/users/markstory/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/markstory/subscriptions","organizations_url":"https://api.github.com/users/markstory/orgs","repos_url":"https://api.github.com/users/markstory/repos","events_url":"https://api.github.com/users/markstory/events{/privacy}","received_events_url":"https://api.github.com/users/markstory/received_events","type":"User","site_admin":false},"created_at":"2015-03-30T01:53:47Z","updated_at":"2015-03-30T01:53:47Z","body":"SQLite doesn't support UUID either. It ends up using a CHAR column instead."}}