{"action":"created","issue":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1698","labels_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1698/labels{/name}","comments_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1698/comments","events_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1698/events","html_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1698","id":81506171,"number":1698,"title":"Disable foreign key checks in SQL query box","user":{"login":"nisargjhaveri","id":6381721,"avatar_url":"https://avatars.githubusercontent.com/u/6381721?v=3","gravatar_id":"","url":"https://api.github.com/users/nisargjhaveri","html_url":"https://github.com/nisargjhaveri","followers_url":"https://api.github.com/users/nisargjhaveri/followers","following_url":"https://api.github.com/users/nisargjhaveri/following{/other_user}","gists_url":"https://api.github.com/users/nisargjhaveri/gists{/gist_id}","starred_url":"https://api.github.com/users/nisargjhaveri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nisargjhaveri/subscriptions","organizations_url":"https://api.github.com/users/nisargjhaveri/orgs","repos_url":"https://api.github.com/users/nisargjhaveri/repos","events_url":"https://api.github.com/users/nisargjhaveri/events{/privacy}","received_events_url":"https://api.github.com/users/nisargjhaveri/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"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},"milestone":null,"comments":9,"created_at":"2015-05-27T15:50:46Z","updated_at":"2015-05-30T04:53:06Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/pulls/1698","html_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1698","diff_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1698.diff","patch_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1698.patch"},"body":"The problem with this is, you cannot enable foreign key checks if global `foreign_key_checks` is `OFF`. Which is also the current behavior of \"Disable foreign key checks\" in import. \r\n\r\nI think, even when global `foreign_key_checks` is `OFF`, one should be able to turn it on by unchecking the checkbox. If it looks good, I'll implement that. Another option is to completely hide these checkbox when global is disabled."},"comment":{"url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/comments/106989486","html_url":"https://github.com/phpmyadmin/phpmyadmin/pull/1698#issuecomment-106989486","issue_url":"https://api.github.com/repos/phpmyadmin/phpmyadmin/issues/1698","id":106989486,"user":{"login":"nisargjhaveri","id":6381721,"avatar_url":"https://avatars.githubusercontent.com/u/6381721?v=3","gravatar_id":"","url":"https://api.github.com/users/nisargjhaveri","html_url":"https://github.com/nisargjhaveri","followers_url":"https://api.github.com/users/nisargjhaveri/followers","following_url":"https://api.github.com/users/nisargjhaveri/following{/other_user}","gists_url":"https://api.github.com/users/nisargjhaveri/gists{/gist_id}","starred_url":"https://api.github.com/users/nisargjhaveri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nisargjhaveri/subscriptions","organizations_url":"https://api.github.com/users/nisargjhaveri/orgs","repos_url":"https://api.github.com/users/nisargjhaveri/repos","events_url":"https://api.github.com/users/nisargjhaveri/events{/privacy}","received_events_url":"https://api.github.com/users/nisargjhaveri/received_events","type":"User","site_admin":false},"created_at":"2015-05-30T04:53:06Z","updated_at":"2015-05-30T04:53:06Z","body":"Please look now, tests are not fixed though. "}}