{"action":"created","issue":{"url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/8","labels_url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/8/labels{/name}","comments_url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/8/comments","events_url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/8/events","html_url":"https://github.com/hpcloud-mon/ansible-monasca-schema/pull/8","id":55948103,"number":8,"title":"Fix idempotence issues creating tables and users","user":{"login":"davidschroeder","id":5023818,"avatar_url":"https://avatars.githubusercontent.com/u/5023818?v=3","gravatar_id":"","url":"https://api.github.com/users/davidschroeder","html_url":"https://github.com/davidschroeder","followers_url":"https://api.github.com/users/davidschroeder/followers","following_url":"https://api.github.com/users/davidschroeder/following{/other_user}","gists_url":"https://api.github.com/users/davidschroeder/gists{/gist_id}","starred_url":"https://api.github.com/users/davidschroeder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidschroeder/subscriptions","organizations_url":"https://api.github.com/users/davidschroeder/orgs","repos_url":"https://api.github.com/users/davidschroeder/repos","events_url":"https://api.github.com/users/davidschroeder/events{/privacy}","received_events_url":"https://api.github.com/users/davidschroeder/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-01-29T19:55:29Z","updated_at":"2015-01-29T20:04:33Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/pulls/8","html_url":"https://github.com/hpcloud-mon/ansible-monasca-schema/pull/8","diff_url":"https://github.com/hpcloud-mon/ansible-monasca-schema/pull/8.diff","patch_url":"https://github.com/hpcloud-mon/ansible-monasca-schema/pull/8.patch"},"body":"The mon.sql file was causing ansible-playbook to fail if run\r\non subsequent occasions, as it would error out trying to re-create\r\nexisting tables and users.  This change tweaks mon.sql to work\r\nwith new and existing Monasca MySQL databases."},"comment":{"url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/comments/72094230","html_url":"https://github.com/hpcloud-mon/ansible-monasca-schema/pull/8#issuecomment-72094230","issue_url":"https://api.github.com/repos/hpcloud-mon/ansible-monasca-schema/issues/8","id":72094230,"user":{"login":"davidschroeder","id":5023818,"avatar_url":"https://avatars.githubusercontent.com/u/5023818?v=3","gravatar_id":"","url":"https://api.github.com/users/davidschroeder","html_url":"https://github.com/davidschroeder","followers_url":"https://api.github.com/users/davidschroeder/followers","following_url":"https://api.github.com/users/davidschroeder/following{/other_user}","gists_url":"https://api.github.com/users/davidschroeder/gists{/gist_id}","starred_url":"https://api.github.com/users/davidschroeder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/davidschroeder/subscriptions","organizations_url":"https://api.github.com/users/davidschroeder/orgs","repos_url":"https://api.github.com/users/davidschroeder/repos","events_url":"https://api.github.com/users/davidschroeder/events{/privacy}","received_events_url":"https://api.github.com/users/davidschroeder/received_events","type":"User","site_admin":false},"created_at":"2015-01-29T20:04:33Z","updated_at":"2015-01-29T20:04:33Z","body":"The GRANT ... IDENTIFIED BY ... statement will create users if they do not already exist (which is the default behavior).\r\nI tested this change out both ways, on new installations and on existing ones."}}