{"action":"created","comment":{"url":"https://api.github.com/repos/FEMR/femr/pulls/comments/47433474","id":47433474,"diff_hunk":"@@ -1,6 +1,12 @@\n # --- !Ups\n ALTER TABLE `users`\n-ADD COLUMN `passwordCreatedDate` DATETIME NOT NULL AFTER `password`;\n+\n+ADD COLUMN `passwordCreatedDate` DATETIME NOT NULL AFTER `password`,\n+ADD COLUMN `date_created` DATETIME NOT NULL AFTER `last_login`,\n+ADD COLUMN `created_by` INT NOT NULL AFTER `creation_date`;\n+\n+UPDATE `users`\n+SET date_created = '9999-01-01'\n \n UPDATE `users`\n SET passwordCreatedDate = '0000-01-01';","path":"conf/evolutions/default/85.sql","position":13,"original_position":13,"commit_id":"520004f53b3dbb63f5ddf60f7b5ed23542787eb3","original_commit_id":"520004f53b3dbb63f5ddf60f7b5ed23542787eb3","user":{"login":"kdunlap","id":8164121,"avatar_url":"https://avatars.githubusercontent.com/u/8164121?v=3","gravatar_id":"","url":"https://api.github.com/users/kdunlap","html_url":"https://github.com/kdunlap","followers_url":"https://api.github.com/users/kdunlap/followers","following_url":"https://api.github.com/users/kdunlap/following{/other_user}","gists_url":"https://api.github.com/users/kdunlap/gists{/gist_id}","starred_url":"https://api.github.com/users/kdunlap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kdunlap/subscriptions","organizations_url":"https://api.github.com/users/kdunlap/orgs","repos_url":"https://api.github.com/users/kdunlap/repos","events_url":"https://api.github.com/users/kdunlap/events{/privacy}","received_events_url":"https://api.github.com/users/kdunlap/received_events","type":"User","site_admin":false},"body":"I had issues with this evolution running correctly. There is a semi-colon missing at line 9, also I figured the default dates should probably be consistent.\r\n\r\nUPDATE `users`\r\nSET date_created = '0000-01-01 00:00:00';\r\n\r\nUPDATE `users`\r\nSET passwordCreatedDate = '0000-01-01 00:00:00';","created_at":"2015-12-12T16:26:02Z","updated_at":"2015-12-12T16:26:02Z","html_url":"https://github.com/FEMR/femr/pull/461#discussion_r47433474","pull_request_url":"https://api.github.com/repos/FEMR/femr/pulls/461","_links":{"self":{"href":"https://api.github.com/repos/FEMR/femr/pulls/comments/47433474"},"html":{"href":"https://github.com/FEMR/femr/pull/461#discussion_r47433474"},"pull_request":{"href":"https://api.github.com/repos/FEMR/femr/pulls/461"}}},"pull_request":{"url":"https://api.github.com/repos/FEMR/femr/pulls/461","id":52067602,"html_url":"https://github.com/FEMR/femr/pull/461","diff_url":"https://github.com/FEMR/femr/pull/461.diff","patch_url":"https://github.com/FEMR/femr/pull/461.patch","issue_url":"https://api.github.com/repos/FEMR/femr/issues/461","number":461,"state":"open","locked":false,"title":"Trackable columns","user":{"login":"zanni022","id":14955983,"avatar_url":"https://avatars.githubusercontent.com/u/14955983?v=3","gravatar_id":"","url":"https://api.github.com/users/zanni022","html_url":"https://github.com/zanni022","followers_url":"https://api.github.com/users/zanni022/followers","following_url":"https://api.github.com/users/zanni022/following{/other_user}","gists_url":"https://api.github.com/users/zanni022/gists{/gist_id}","starred_url":"https://api.github.com/users/zanni022/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zanni022/subscriptions","organizations_url":"https://api.github.com/users/zanni022/orgs","repos_url":"https://api.github.com/users/zanni022/repos","events_url":"https://api.github.com/users/zanni022/events{/privacy}","received_events_url":"https://api.github.com/users/zanni022/received_events","type":"User","site_admin":false},"body":"Changed the evolution 85 to the recommended changes by Ken. Also retested!","created_at":"2015-11-29T18:29:29Z","updated_at":"2015-12-12T16:26:02Z","closed_at":null,"merged_at":null,"merge_commit_sha":"1c3bf06f5ce603de9dfa4d30c835ec3b66a25dea","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/FEMR/femr/pulls/461/commits","review_comments_url":"https://api.github.com/repos/FEMR/femr/pulls/461/comments","review_comment_url":"https://api.github.com/repos/FEMR/femr/pulls/comments{/number}","comments_url":"https://api.github.com/repos/FEMR/femr/issues/461/comments","statuses_url":"https://api.github.com/repos/FEMR/femr/statuses/520004f53b3dbb63f5ddf60f7b5ed23542787eb3","head":{"label":"zanni022:TrackableColumns","ref":"TrackableColumns","sha":"520004f53b3dbb63f5ddf60f7b5ed23542787eb3","user":{"login":"zanni022","id":14955983,"avatar_url":"https://avatars.githubusercontent.com/u/14955983?v=3","gravatar_id":"","url":"https://api.github.com/users/zanni022","html_url":"https://github.com/zanni022","followers_url":"https://api.github.com/users/zanni022/followers","following_url":"https://api.github.com/users/zanni022/following{/other_user}","gists_url":"https://api.github.com/users/zanni022/gists{/gist_id}","starred_url":"https://api.github.com/users/zanni022/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zanni022/subscriptions","organizations_url":"https://api.github.com/users/zanni022/orgs","repos_url":"https://api.github.com/users/zanni022/repos","events_url":"https://api.github.com/users/zanni022/events{/privacy}","received_events_url":"https://api.github.com/users/zanni022/received_events","type":"User","site_admin":false},"repo":{"id":45714285,"name":"femr","full_name":"zanni022/femr","owner":{"login":"zanni022","id":14955983,"avatar_url":"https://avatars.githubusercontent.com/u/14955983?v=3","gravatar_id":"","url":"https://api.github.com/users/zanni022","html_url":"https://github.com/zanni022","followers_url":"https://api.github.com/users/zanni022/followers","following_url":"https://api.github.com/users/zanni022/following{/other_user}","gists_url":"https://api.github.com/users/zanni022/gists{/gist_id}","starred_url":"https://api.github.com/users/zanni022/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zanni022/subscriptions","organizations_url":"https://api.github.com/users/zanni022/orgs","repos_url":"https://api.github.com/users/zanni022/repos","events_url":"https://api.github.com/users/zanni022/events{/privacy}","received_events_url":"https://api.github.com/users/zanni022/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/zanni022/femr","description":"A simple and fast EMR system used in low resource settings.","fork":true,"url":"https://api.github.com/repos/zanni022/femr","forks_url":"https://api.github.com/repos/zanni022/femr/forks","keys_url":"https://api.github.com/repos/zanni022/femr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/zanni022/femr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/zanni022/femr/teams","hooks_url":"https://api.github.com/repos/zanni022/femr/hooks","issue_events_url":"https://api.github.com/repos/zanni022/femr/issues/events{/number}","events_url":"https://api.github.com/repos/zanni022/femr/events","assignees_url":"https://api.github.com/repos/zanni022/femr/assignees{/user}","branches_url":"https://api.github.com/repos/zanni022/femr/branches{/branch}","tags_url":"https://api.github.com/repos/zanni022/femr/tags","blobs_url":"https://api.github.com/repos/zanni022/femr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/zanni022/femr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/zanni022/femr/git/refs{/sha}","trees_url":"https://api.github.com/repos/zanni022/femr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/zanni022/femr/statuses/{sha}","languages_url":"https://api.github.com/repos/zanni022/femr/languages","stargazers_url":"https://api.github.com/repos/zanni022/femr/stargazers","contributors_url":"https://api.github.com/repos/zanni022/femr/contributors","subscribers_url":"https://api.github.com/repos/zanni022/femr/subscribers","subscription_url":"https://api.github.com/repos/zanni022/femr/subscription","commits_url":"https://api.github.com/repos/zanni022/femr/commits{/sha}","git_commits_url":"https://api.github.com/repos/zanni022/femr/git/commits{/sha}","comments_url":"https://api.github.com/repos/zanni022/femr/comments{/number}","issue_comment_url":"https://api.github.com/repos/zanni022/femr/issues/comments{/number}","contents_url":"https://api.github.com/repos/zanni022/femr/contents/{+path}","compare_url":"https://api.github.com/repos/zanni022/femr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/zanni022/femr/merges","archive_url":"https://api.github.com/repos/zanni022/femr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/zanni022/femr/downloads","issues_url":"https://api.github.com/repos/zanni022/femr/issues{/number}","pulls_url":"https://api.github.com/repos/zanni022/femr/pulls{/number}","milestones_url":"https://api.github.com/repos/zanni022/femr/milestones{/number}","notifications_url":"https://api.github.com/repos/zanni022/femr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/zanni022/femr/labels{/name}","releases_url":"https://api.github.com/repos/zanni022/femr/releases{/id}","created_at":"2015-11-06T23:43:38Z","updated_at":"2015-11-06T23:43:40Z","pushed_at":"2015-12-09T00:23:46Z","git_url":"git://github.com/zanni022/femr.git","ssh_url":"git@github.com:zanni022/femr.git","clone_url":"https://github.com/zanni022/femr.git","svn_url":"https://github.com/zanni022/femr","homepage":"http://www.teamfemr.org","size":10448,"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":"FEMR:development","ref":"development","sha":"309b106d6177416f5204fdd95e23150aa4b03647","user":{"login":"FEMR","id":6461581,"avatar_url":"https://avatars.githubusercontent.com/u/6461581?v=3","gravatar_id":"","url":"https://api.github.com/users/FEMR","html_url":"https://github.com/FEMR","followers_url":"https://api.github.com/users/FEMR/followers","following_url":"https://api.github.com/users/FEMR/following{/other_user}","gists_url":"https://api.github.com/users/FEMR/gists{/gist_id}","starred_url":"https://api.github.com/users/FEMR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FEMR/subscriptions","organizations_url":"https://api.github.com/users/FEMR/orgs","repos_url":"https://api.github.com/users/FEMR/repos","events_url":"https://api.github.com/users/FEMR/events{/privacy}","received_events_url":"https://api.github.com/users/FEMR/received_events","type":"Organization","site_admin":false},"repo":{"id":12690182,"name":"femr","full_name":"FEMR/femr","owner":{"login":"FEMR","id":6461581,"avatar_url":"https://avatars.githubusercontent.com/u/6461581?v=3","gravatar_id":"","url":"https://api.github.com/users/FEMR","html_url":"https://github.com/FEMR","followers_url":"https://api.github.com/users/FEMR/followers","following_url":"https://api.github.com/users/FEMR/following{/other_user}","gists_url":"https://api.github.com/users/FEMR/gists{/gist_id}","starred_url":"https://api.github.com/users/FEMR/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FEMR/subscriptions","organizations_url":"https://api.github.com/users/FEMR/orgs","repos_url":"https://api.github.com/users/FEMR/repos","events_url":"https://api.github.com/users/FEMR/events{/privacy}","received_events_url":"https://api.github.com/users/FEMR/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/FEMR/femr","description":"A simple and fast EMR system used in low resource settings.","fork":false,"url":"https://api.github.com/repos/FEMR/femr","forks_url":"https://api.github.com/repos/FEMR/femr/forks","keys_url":"https://api.github.com/repos/FEMR/femr/keys{/key_id}","collaborators_url":"https://api.github.com/repos/FEMR/femr/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/FEMR/femr/teams","hooks_url":"https://api.github.com/repos/FEMR/femr/hooks","issue_events_url":"https://api.github.com/repos/FEMR/femr/issues/events{/number}","events_url":"https://api.github.com/repos/FEMR/femr/events","assignees_url":"https://api.github.com/repos/FEMR/femr/assignees{/user}","branches_url":"https://api.github.com/repos/FEMR/femr/branches{/branch}","tags_url":"https://api.github.com/repos/FEMR/femr/tags","blobs_url":"https://api.github.com/repos/FEMR/femr/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/FEMR/femr/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/FEMR/femr/git/refs{/sha}","trees_url":"https://api.github.com/repos/FEMR/femr/git/trees{/sha}","statuses_url":"https://api.github.com/repos/FEMR/femr/statuses/{sha}","languages_url":"https://api.github.com/repos/FEMR/femr/languages","stargazers_url":"https://api.github.com/repos/FEMR/femr/stargazers","contributors_url":"https://api.github.com/repos/FEMR/femr/contributors","subscribers_url":"https://api.github.com/repos/FEMR/femr/subscribers","subscription_url":"https://api.github.com/repos/FEMR/femr/subscription","commits_url":"https://api.github.com/repos/FEMR/femr/commits{/sha}","git_commits_url":"https://api.github.com/repos/FEMR/femr/git/commits{/sha}","comments_url":"https://api.github.com/repos/FEMR/femr/comments{/number}","issue_comment_url":"https://api.github.com/repos/FEMR/femr/issues/comments{/number}","contents_url":"https://api.github.com/repos/FEMR/femr/contents/{+path}","compare_url":"https://api.github.com/repos/FEMR/femr/compare/{base}...{head}","merges_url":"https://api.github.com/repos/FEMR/femr/merges","archive_url":"https://api.github.com/repos/FEMR/femr/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/FEMR/femr/downloads","issues_url":"https://api.github.com/repos/FEMR/femr/issues{/number}","pulls_url":"https://api.github.com/repos/FEMR/femr/pulls{/number}","milestones_url":"https://api.github.com/repos/FEMR/femr/milestones{/number}","notifications_url":"https://api.github.com/repos/FEMR/femr/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/FEMR/femr/labels{/name}","releases_url":"https://api.github.com/repos/FEMR/femr/releases{/id}","created_at":"2013-09-09T00:47:06Z","updated_at":"2015-08-25T22:44:35Z","pushed_at":"2015-12-12T00:44:44Z","git_url":"git://github.com/FEMR/femr.git","ssh_url":"git@github.com:FEMR/femr.git","clone_url":"https://github.com/FEMR/femr.git","svn_url":"https://github.com/FEMR/femr","homepage":"http://www.teamfemr.org","size":12630,"stargazers_count":14,"watchers_count":14,"language":"Java","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":23,"mirror_url":null,"open_issues_count":4,"forks":23,"open_issues":4,"watchers":14,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/FEMR/femr/pulls/461"},"html":{"href":"https://github.com/FEMR/femr/pull/461"},"issue":{"href":"https://api.github.com/repos/FEMR/femr/issues/461"},"comments":{"href":"https://api.github.com/repos/FEMR/femr/issues/461/comments"},"review_comments":{"href":"https://api.github.com/repos/FEMR/femr/pulls/461/comments"},"review_comment":{"href":"https://api.github.com/repos/FEMR/femr/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/FEMR/femr/pulls/461/commits"},"statuses":{"href":"https://api.github.com/repos/FEMR/femr/statuses/520004f53b3dbb63f5ddf60f7b5ed23542787eb3"}}}}