{"action":"created","issue":{"url":"https://api.github.com/repos/cakephp/bake/issues/169","labels_url":"https://api.github.com/repos/cakephp/bake/issues/169/labels{/name}","comments_url":"https://api.github.com/repos/cakephp/bake/issues/169/comments","events_url":"https://api.github.com/repos/cakephp/bake/issues/169/events","html_url":"https://github.com/cakephp/bake/issues/169","id":113378079,"number":169,"title":"Baked _indexes with MySQL","user":{"login":"steefaan","id":5982785,"avatar_url":"https://avatars.githubusercontent.com/u/5982785?v=3","gravatar_id":"","url":"https://api.github.com/users/steefaan","html_url":"https://github.com/steefaan","followers_url":"https://api.github.com/users/steefaan/followers","following_url":"https://api.github.com/users/steefaan/following{/other_user}","gists_url":"https://api.github.com/users/steefaan/gists{/gist_id}","starred_url":"https://api.github.com/users/steefaan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/steefaan/subscriptions","organizations_url":"https://api.github.com/users/steefaan/orgs","repos_url":"https://api.github.com/users/steefaan/repos","events_url":"https://api.github.com/users/steefaan/events{/privacy}","received_events_url":"https://api.github.com/users/steefaan/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cakephp/bake/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"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},"milestone":{"url":"https://api.github.com/repos/cakephp/bake/milestones/13","html_url":"https://github.com/cakephp/bake/milestones/1.0.14","labels_url":"https://api.github.com/repos/cakephp/bake/milestones/13/labels","id":1266624,"number":13,"title":"1.0.14","description":"Bugfixes and minor features.","creator":{"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},"open_issues":3,"closed_issues":9,"state":"open","created_at":"2015-08-21T16:55:14Z","updated_at":"2015-10-26T16:05:44Z","due_on":null,"closed_at":null},"comments":1,"created_at":"2015-10-26T15:15:54Z","updated_at":"2015-10-26T16:06:53Z","closed_at":null,"body":"It seems that MySQL isn't able to create foreign keys without indexes, sqlite and postgres don't need these indexes... if I bake a fixture from a MySQL table it will create `_indexes` and `_constraints`... if I run test cases on MySQL everything works fine but if I run test cases with postgres or sqlite and I have two fixtures with same _indexes it will fail with `Warning Error: Fixture creation for \"threads\" failed \"SQLSTATE[HY000]: General error: 1 index user_id already exists\" in [/var/www/project/vendor/cakephp/cakephp/src/TestSuite/Fixture/TestFixture.php, line 240]`\r\n\r\nIf I bake the fixtures from Postgres everything works fine.\r\n\r\nThis issue is related to https://github.com/cakephp/cakephp/issues/7608. In my opinion it's an issue with bake.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/cakephp/bake/issues/comments/151188981","html_url":"https://github.com/cakephp/bake/issues/169#issuecomment-151188981","issue_url":"https://api.github.com/repos/cakephp/bake/issues/169","id":151188981,"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-10-26T16:06:53Z","updated_at":"2015-10-26T16:06:53Z","body":"I bet we shouldn't have the duplicate index attributes. Creating a constraint also creates an index in mysql."}}