{"action":"created","issue":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/5360","repository_url":"https://api.github.com/repos/influxdata/influxdb","labels_url":"https://api.github.com/repos/influxdata/influxdb/issues/5360/labels{/name}","comments_url":"https://api.github.com/repos/influxdata/influxdb/issues/5360/comments","events_url":"https://api.github.com/repos/influxdata/influxdb/issues/5360/events","html_url":"https://github.com/influxdata/influxdb/pull/5360","id":126799708,"number":5360,"title":"Add `CREATE USER IF NOT EXISTS`","user":{"login":"mmalecki","id":692459,"avatar_url":"https://avatars.githubusercontent.com/u/692459?v=3","gravatar_id":"","url":"https://api.github.com/users/mmalecki","html_url":"https://github.com/mmalecki","followers_url":"https://api.github.com/users/mmalecki/followers","following_url":"https://api.github.com/users/mmalecki/following{/other_user}","gists_url":"https://api.github.com/users/mmalecki/gists{/gist_id}","starred_url":"https://api.github.com/users/mmalecki/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mmalecki/subscriptions","organizations_url":"https://api.github.com/users/mmalecki/orgs","repos_url":"https://api.github.com/users/mmalecki/repos","events_url":"https://api.github.com/users/mmalecki/events{/privacy}","received_events_url":"https://api.github.com/users/mmalecki/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2016-01-15T03:18:54Z","updated_at":"2016-02-17T23:34:12Z","closed_at":"2016-02-17T23:34:12Z","pull_request":{"url":"https://api.github.com/repos/influxdata/influxdb/pulls/5360","html_url":"https://github.com/influxdata/influxdb/pull/5360","diff_url":"https://github.com/influxdata/influxdb/pull/5360.diff","patch_url":"https://github.com/influxdata/influxdb/pull/5360.patch"},"body":"Refactor `IF NOT EXISTS` parsing to `Parser.parseIfNotExists`.\r\n\r\nI needed this to completely automate creation of users on InfluxDB hosts using Ansible.\r\n\r\nI signed the CLA as me@mmalecki.com."},"comment":{"url":"https://api.github.com/repos/influxdata/influxdb/issues/comments/185459635","html_url":"https://github.com/influxdata/influxdb/pull/5360#issuecomment-185459635","issue_url":"https://api.github.com/repos/influxdata/influxdb/issues/5360","id":185459635,"user":{"login":"jwilder","id":219935,"avatar_url":"https://avatars.githubusercontent.com/u/219935?v=3","gravatar_id":"","url":"https://api.github.com/users/jwilder","html_url":"https://github.com/jwilder","followers_url":"https://api.github.com/users/jwilder/followers","following_url":"https://api.github.com/users/jwilder/following{/other_user}","gists_url":"https://api.github.com/users/jwilder/gists{/gist_id}","starred_url":"https://api.github.com/users/jwilder/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jwilder/subscriptions","organizations_url":"https://api.github.com/users/jwilder/orgs","repos_url":"https://api.github.com/users/jwilder/repos","events_url":"https://api.github.com/users/jwilder/events{/privacy}","received_events_url":"https://api.github.com/users/jwilder/received_events","type":"User","site_admin":false},"created_at":"2016-02-17T23:34:12Z","updated_at":"2016-02-17T23:34:12Z","body":"@mmalecki It looks like the `if not exists` behavior is now the default for all create statements so this already works in current master.  The `if not exists` syntax is now deprecated on the other functions and will be ignored in `0.11`.  We plan to remove it from the query language in a subsequent release. See #5707 and #5563."}}