{"action":"created","comment":{"url":"https://api.github.com/repos/openhab/openhab/pulls/comments/33114627","id":33114627,"diff_hunk":"@@ -117,7 +119,7 @@ public void activate() {\n \t\tsqlTypes.put(\"CONTACTITEM\", \"VARCHAR(6)\");\n \t\tsqlTypes.put(\"DATETIMEITEM\", \"DATETIME\");\n \t\tsqlTypes.put(\"DIMMERITEM\", \"TINYINT\");\n-\t\tsqlTypes.put(\"GROUPITEM\", \"DOUBLE\");\n+\t\tsqlTypes.put(\"GROUPITEM\", \"VARCHAR(200)\");","path":"bundles/persistence/org.openhab.persistence.mysql/java/org/openhab/persistence/mysql/internal/MysqlPersistenceService.java","position":21,"original_position":21,"commit_id":"cc1fd23e0365ad2693506264fbfedaab009786ed","original_commit_id":"cc1fd23e0365ad2693506264fbfedaab009786ed","user":{"login":"watou","id":3008217,"avatar_url":"https://avatars.githubusercontent.com/u/3008217?v=3","gravatar_id":"","url":"https://api.github.com/users/watou","html_url":"https://github.com/watou","followers_url":"https://api.github.com/users/watou/followers","following_url":"https://api.github.com/users/watou/following{/other_user}","gists_url":"https://api.github.com/users/watou/gists{/gist_id}","starred_url":"https://api.github.com/users/watou/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/watou/subscriptions","organizations_url":"https://api.github.com/users/watou/orgs","repos_url":"https://api.github.com/users/watou/repos","events_url":"https://api.github.com/users/watou/events{/privacy}","received_events_url":"https://api.github.com/users/watou/received_events","type":"User","site_admin":false},"body":"Is this change supposed to be part of this pull request?","created_at":"2015-06-24T03:21:56Z","updated_at":"2015-06-24T03:21:56Z","html_url":"https://github.com/openhab/openhab/pull/2779#discussion_r33114627","pull_request_url":"https://api.github.com/repos/openhab/openhab/pulls/2779","_links":{"self":{"href":"https://api.github.com/repos/openhab/openhab/pulls/comments/33114627"},"html":{"href":"https://github.com/openhab/openhab/pull/2779#discussion_r33114627"},"pull_request":{"href":"https://api.github.com/repos/openhab/openhab/pulls/2779"}}},"pull_request":{"url":"https://api.github.com/repos/openhab/openhab/pulls/2779","id":38217252,"html_url":"https://github.com/openhab/openhab/pull/2779","diff_url":"https://github.com/openhab/openhab/pull/2779.diff","patch_url":"https://github.com/openhab/openhab/pull/2779.patch","issue_url":"https://api.github.com/repos/openhab/openhab/issues/2779","number":2779,"state":"open","locked":false,"title":"Mysql fix prepared statement #2705","user":{"login":"lewie","id":5707426,"avatar_url":"https://avatars.githubusercontent.com/u/5707426?v=3","gravatar_id":"","url":"https://api.github.com/users/lewie","html_url":"https://github.com/lewie","followers_url":"https://api.github.com/users/lewie/followers","following_url":"https://api.github.com/users/lewie/following{/other_user}","gists_url":"https://api.github.com/users/lewie/gists{/gist_id}","starred_url":"https://api.github.com/users/lewie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lewie/subscriptions","organizations_url":"https://api.github.com/users/lewie/orgs","repos_url":"https://api.github.com/users/lewie/repos","events_url":"https://api.github.com/users/lewie/events{/privacy}","received_events_url":"https://api.github.com/users/lewie/received_events","type":"User","site_admin":false},"body":"@watou: You're welcome...","created_at":"2015-06-22T10:18:48Z","updated_at":"2015-06-24T03:21:56Z","closed_at":null,"merged_at":null,"merge_commit_sha":"a77cf5fe9736ede3ad8911e1b0dd4efa2c4c4f7b","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/openhab/openhab/pulls/2779/commits","review_comments_url":"https://api.github.com/repos/openhab/openhab/pulls/2779/comments","review_comment_url":"https://api.github.com/repos/openhab/openhab/pulls/comments{/number}","comments_url":"https://api.github.com/repos/openhab/openhab/issues/2779/comments","statuses_url":"https://api.github.com/repos/openhab/openhab/statuses/cc1fd23e0365ad2693506264fbfedaab009786ed","head":{"label":"lewie:mysql-fix-PreparedStatement-#2705","ref":"mysql-fix-PreparedStatement-#2705","sha":"cc1fd23e0365ad2693506264fbfedaab009786ed","user":{"login":"lewie","id":5707426,"avatar_url":"https://avatars.githubusercontent.com/u/5707426?v=3","gravatar_id":"","url":"https://api.github.com/users/lewie","html_url":"https://github.com/lewie","followers_url":"https://api.github.com/users/lewie/followers","following_url":"https://api.github.com/users/lewie/following{/other_user}","gists_url":"https://api.github.com/users/lewie/gists{/gist_id}","starred_url":"https://api.github.com/users/lewie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lewie/subscriptions","organizations_url":"https://api.github.com/users/lewie/orgs","repos_url":"https://api.github.com/users/lewie/repos","events_url":"https://api.github.com/users/lewie/events{/privacy}","received_events_url":"https://api.github.com/users/lewie/received_events","type":"User","site_admin":false},"repo":{"id":31721912,"name":"openhab","full_name":"lewie/openhab","owner":{"login":"lewie","id":5707426,"avatar_url":"https://avatars.githubusercontent.com/u/5707426?v=3","gravatar_id":"","url":"https://api.github.com/users/lewie","html_url":"https://github.com/lewie","followers_url":"https://api.github.com/users/lewie/followers","following_url":"https://api.github.com/users/lewie/following{/other_user}","gists_url":"https://api.github.com/users/lewie/gists{/gist_id}","starred_url":"https://api.github.com/users/lewie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lewie/subscriptions","organizations_url":"https://api.github.com/users/lewie/orgs","repos_url":"https://api.github.com/users/lewie/repos","events_url":"https://api.github.com/users/lewie/events{/privacy}","received_events_url":"https://api.github.com/users/lewie/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lewie/openhab","description":"Source code of the open Home Automation Bus (openHAB)","fork":true,"url":"https://api.github.com/repos/lewie/openhab","forks_url":"https://api.github.com/repos/lewie/openhab/forks","keys_url":"https://api.github.com/repos/lewie/openhab/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lewie/openhab/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lewie/openhab/teams","hooks_url":"https://api.github.com/repos/lewie/openhab/hooks","issue_events_url":"https://api.github.com/repos/lewie/openhab/issues/events{/number}","events_url":"https://api.github.com/repos/lewie/openhab/events","assignees_url":"https://api.github.com/repos/lewie/openhab/assignees{/user}","branches_url":"https://api.github.com/repos/lewie/openhab/branches{/branch}","tags_url":"https://api.github.com/repos/lewie/openhab/tags","blobs_url":"https://api.github.com/repos/lewie/openhab/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lewie/openhab/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lewie/openhab/git/refs{/sha}","trees_url":"https://api.github.com/repos/lewie/openhab/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lewie/openhab/statuses/{sha}","languages_url":"https://api.github.com/repos/lewie/openhab/languages","stargazers_url":"https://api.github.com/repos/lewie/openhab/stargazers","contributors_url":"https://api.github.com/repos/lewie/openhab/contributors","subscribers_url":"https://api.github.com/repos/lewie/openhab/subscribers","subscription_url":"https://api.github.com/repos/lewie/openhab/subscription","commits_url":"https://api.github.com/repos/lewie/openhab/commits{/sha}","git_commits_url":"https://api.github.com/repos/lewie/openhab/git/commits{/sha}","comments_url":"https://api.github.com/repos/lewie/openhab/comments{/number}","issue_comment_url":"https://api.github.com/repos/lewie/openhab/issues/comments{/number}","contents_url":"https://api.github.com/repos/lewie/openhab/contents/{+path}","compare_url":"https://api.github.com/repos/lewie/openhab/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lewie/openhab/merges","archive_url":"https://api.github.com/repos/lewie/openhab/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lewie/openhab/downloads","issues_url":"https://api.github.com/repos/lewie/openhab/issues{/number}","pulls_url":"https://api.github.com/repos/lewie/openhab/pulls{/number}","milestones_url":"https://api.github.com/repos/lewie/openhab/milestones{/number}","notifications_url":"https://api.github.com/repos/lewie/openhab/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lewie/openhab/labels{/name}","releases_url":"https://api.github.com/repos/lewie/openhab/releases{/id}","created_at":"2015-03-05T15:54:11Z","updated_at":"2015-04-30T09:54:53Z","pushed_at":"2015-06-22T17:32:57Z","git_url":"git://github.com/lewie/openhab.git","ssh_url":"git@github.com:lewie/openhab.git","clone_url":"https://github.com/lewie/openhab.git","svn_url":"https://github.com/lewie/openhab","homepage":null,"size":159663,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"openhab:master","ref":"master","sha":"8124e1d28ce858c77350bc4000e7805581583457","user":{"login":"openhab","id":1007353,"avatar_url":"https://avatars.githubusercontent.com/u/1007353?v=3","gravatar_id":"","url":"https://api.github.com/users/openhab","html_url":"https://github.com/openhab","followers_url":"https://api.github.com/users/openhab/followers","following_url":"https://api.github.com/users/openhab/following{/other_user}","gists_url":"https://api.github.com/users/openhab/gists{/gist_id}","starred_url":"https://api.github.com/users/openhab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openhab/subscriptions","organizations_url":"https://api.github.com/users/openhab/orgs","repos_url":"https://api.github.com/users/openhab/repos","events_url":"https://api.github.com/users/openhab/events{/privacy}","received_events_url":"https://api.github.com/users/openhab/received_events","type":"Organization","site_admin":false},"repo":{"id":12983151,"name":"openhab","full_name":"openhab/openhab","owner":{"login":"openhab","id":1007353,"avatar_url":"https://avatars.githubusercontent.com/u/1007353?v=3","gravatar_id":"","url":"https://api.github.com/users/openhab","html_url":"https://github.com/openhab","followers_url":"https://api.github.com/users/openhab/followers","following_url":"https://api.github.com/users/openhab/following{/other_user}","gists_url":"https://api.github.com/users/openhab/gists{/gist_id}","starred_url":"https://api.github.com/users/openhab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openhab/subscriptions","organizations_url":"https://api.github.com/users/openhab/orgs","repos_url":"https://api.github.com/users/openhab/repos","events_url":"https://api.github.com/users/openhab/events{/privacy}","received_events_url":"https://api.github.com/users/openhab/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/openhab/openhab","description":"Source code of the open Home Automation Bus (openHAB)","fork":false,"url":"https://api.github.com/repos/openhab/openhab","forks_url":"https://api.github.com/repos/openhab/openhab/forks","keys_url":"https://api.github.com/repos/openhab/openhab/keys{/key_id}","collaborators_url":"https://api.github.com/repos/openhab/openhab/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/openhab/openhab/teams","hooks_url":"https://api.github.com/repos/openhab/openhab/hooks","issue_events_url":"https://api.github.com/repos/openhab/openhab/issues/events{/number}","events_url":"https://api.github.com/repos/openhab/openhab/events","assignees_url":"https://api.github.com/repos/openhab/openhab/assignees{/user}","branches_url":"https://api.github.com/repos/openhab/openhab/branches{/branch}","tags_url":"https://api.github.com/repos/openhab/openhab/tags","blobs_url":"https://api.github.com/repos/openhab/openhab/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/openhab/openhab/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/openhab/openhab/git/refs{/sha}","trees_url":"https://api.github.com/repos/openhab/openhab/git/trees{/sha}","statuses_url":"https://api.github.com/repos/openhab/openhab/statuses/{sha}","languages_url":"https://api.github.com/repos/openhab/openhab/languages","stargazers_url":"https://api.github.com/repos/openhab/openhab/stargazers","contributors_url":"https://api.github.com/repos/openhab/openhab/contributors","subscribers_url":"https://api.github.com/repos/openhab/openhab/subscribers","subscription_url":"https://api.github.com/repos/openhab/openhab/subscription","commits_url":"https://api.github.com/repos/openhab/openhab/commits{/sha}","git_commits_url":"https://api.github.com/repos/openhab/openhab/git/commits{/sha}","comments_url":"https://api.github.com/repos/openhab/openhab/comments{/number}","issue_comment_url":"https://api.github.com/repos/openhab/openhab/issues/comments{/number}","contents_url":"https://api.github.com/repos/openhab/openhab/contents/{+path}","compare_url":"https://api.github.com/repos/openhab/openhab/compare/{base}...{head}","merges_url":"https://api.github.com/repos/openhab/openhab/merges","archive_url":"https://api.github.com/repos/openhab/openhab/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/openhab/openhab/downloads","issues_url":"https://api.github.com/repos/openhab/openhab/issues{/number}","pulls_url":"https://api.github.com/repos/openhab/openhab/pulls{/number}","milestones_url":"https://api.github.com/repos/openhab/openhab/milestones{/number}","notifications_url":"https://api.github.com/repos/openhab/openhab/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/openhab/openhab/labels{/name}","releases_url":"https://api.github.com/repos/openhab/openhab/releases{/id}","created_at":"2013-09-20T20:28:43Z","updated_at":"2015-06-23T17:24:51Z","pushed_at":"2015-06-24T00:21:05Z","git_url":"git://github.com/openhab/openhab.git","ssh_url":"git@github.com:openhab/openhab.git","clone_url":"https://github.com/openhab/openhab.git","svn_url":"https://github.com/openhab/openhab","homepage":null,"size":245633,"stargazers_count":1453,"watchers_count":1453,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":858,"mirror_url":null,"open_issues_count":484,"forks":858,"open_issues":484,"watchers":1453,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/openhab/openhab/pulls/2779"},"html":{"href":"https://github.com/openhab/openhab/pull/2779"},"issue":{"href":"https://api.github.com/repos/openhab/openhab/issues/2779"},"comments":{"href":"https://api.github.com/repos/openhab/openhab/issues/2779/comments"},"review_comments":{"href":"https://api.github.com/repos/openhab/openhab/pulls/2779/comments"},"review_comment":{"href":"https://api.github.com/repos/openhab/openhab/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/openhab/openhab/pulls/2779/commits"},"statuses":{"href":"https://api.github.com/repos/openhab/openhab/statuses/cc1fd23e0365ad2693506264fbfedaab009786ed"}}}}