{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11484","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11484/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11484/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11484/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11484","id":106677008,"number":11484,"title":"Foreign keys not working with ANSI_QUOTES","user":{"login":"andrews05","id":4584038,"avatar_url":"https://avatars.githubusercontent.com/u/4584038?v=3","gravatar_id":"","url":"https://api.github.com/users/andrews05","html_url":"https://github.com/andrews05","followers_url":"https://api.github.com/users/andrews05/followers","following_url":"https://api.github.com/users/andrews05/following{/other_user}","gists_url":"https://api.github.com/users/andrews05/gists{/gist_id}","starred_url":"https://api.github.com/users/andrews05/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/andrews05/subscriptions","organizations_url":"https://api.github.com/users/andrews05/orgs","repos_url":"https://api.github.com/users/andrews05/repos","events_url":"https://api.github.com/users/andrews05/events{/privacy}","received_events_url":"https://api.github.com/users/andrews05/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-09-16T01:09:22Z","updated_at":"2015-09-16T01:20:31Z","closed_at":null,"body":"I have a mysql database server but my code needs to be as compatible as possible with SQL Server, so I have sql-mode = ANSI_QUOTES in the mysql config. This seems to cause foreign keys to not be displayed or enforced properly in phpMyAdmin."},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/140592703","html_url":"https://github.com/phpmyadmin/phpmyadmin/issues/11484#issuecomment-140592703","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/11484","id":140592703,"user":{"login":"lem9","id":195509,"avatar_url":"https://avatars.githubusercontent.com/u/195509?v=3","gravatar_id":"","url":"https://api.github.com/users/lem9","html_url":"https://github.com/lem9","followers_url":"https://api.github.com/users/lem9/followers","following_url":"https://api.github.com/users/lem9/following{/other_user}","gists_url":"https://api.github.com/users/lem9/gists{/gist_id}","starred_url":"https://api.github.com/users/lem9/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lem9/subscriptions","organizations_url":"https://api.github.com/users/lem9/orgs","repos_url":"https://api.github.com/users/lem9/repos","events_url":"https://api.github.com/users/lem9/events{/privacy}","received_events_url":"https://api.github.com/users/lem9/received_events","type":"User","site_admin":false},"created_at":"2015-09-16T01:20:31Z","updated_at":"2015-09-16T01:20:31Z","body":"Which MySQL and phpMyAdmin versions please?"}}