{"action":"created","comment":{"url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/comments/64420118","id":64420118,"diff_hunk":"@@ -1,16 +1,16 @@\n ﻿CREATE TABLE [dbo].[Strategy] (\n     [DifficultyLevelID] INT            NOT NULL,\n     [Overview]          NVARCHAR (MAX) NOT NULL,\n-    [Tank]              NVARCHAR (MAX) NULL,\n-    [Healer]            NVARCHAR (MAX) NULL,\n-    [DPS]               NVARCHAR (MAX) NULL,\n+    [Detailed]          NVARCHAR (MAX) NOT NULL,\n     [BossID]            INT            NOT NULL,\n     [StrategyID]        INT            IDENTITY (1, 1) NOT NULL,\n-    [Title]             NVARCHAR (50)  NOT NULL,\n-    [UserID]            INT NOT NULL,\n+    [UserID]            INT            NOT NULL,\n+    [SpecializationID]  INT            NOT NULL,\n+    [DateCreated]       DATETIME       NOT NULL,","path":"projects/BossCheatSheets.Database/dbo/Tables/Strategy.sql","position":14,"original_position":14,"commit_id":"650a0bdf6c247a79ae2cab08e2a923301f6bee7f","original_commit_id":"650a0bdf6c247a79ae2cab08e2a923301f6bee7f","user":{"login":"happygaijin","id":7808846,"avatar_url":"https://avatars.githubusercontent.com/u/7808846?v=3","gravatar_id":"","url":"https://api.github.com/users/happygaijin","html_url":"https://github.com/happygaijin","followers_url":"https://api.github.com/users/happygaijin/followers","following_url":"https://api.github.com/users/happygaijin/following{/other_user}","gists_url":"https://api.github.com/users/happygaijin/gists{/gist_id}","starred_url":"https://api.github.com/users/happygaijin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/happygaijin/subscriptions","organizations_url":"https://api.github.com/users/happygaijin/orgs","repos_url":"https://api.github.com/users/happygaijin/repos","events_url":"https://api.github.com/users/happygaijin/events{/privacy}","received_events_url":"https://api.github.com/users/happygaijin/received_events","type":"User","site_admin":false},"body":"Good idea to add this column. \r\n\r\nAll dates saved in SQL should be UTC by discipline. As such the name of the column should have 'UTC' in it so anyone reading the database is clear that it is a UTC date. So DateCreatedUTC would be good.","created_at":"2016-05-24T15:55:42Z","updated_at":"2016-05-24T15:55:42Z","html_url":"https://github.com/GuavaJelly/BossCheatSheets/pull/25#discussion_r64420118","pull_request_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25","_links":{"self":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/comments/64420118"},"html":{"href":"https://github.com/GuavaJelly/BossCheatSheets/pull/25#discussion_r64420118"},"pull_request":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25"}}},"pull_request":{"url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25","id":71159681,"html_url":"https://github.com/GuavaJelly/BossCheatSheets/pull/25","diff_url":"https://github.com/GuavaJelly/BossCheatSheets/pull/25.diff","patch_url":"https://github.com/GuavaJelly/BossCheatSheets/pull/25.patch","issue_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/25","number":25,"state":"open","locked":false,"title":"Feature/strategy create","user":{"login":"guavajellyaaron","id":8316984,"avatar_url":"https://avatars.githubusercontent.com/u/8316984?v=3","gravatar_id":"","url":"https://api.github.com/users/guavajellyaaron","html_url":"https://github.com/guavajellyaaron","followers_url":"https://api.github.com/users/guavajellyaaron/followers","following_url":"https://api.github.com/users/guavajellyaaron/following{/other_user}","gists_url":"https://api.github.com/users/guavajellyaaron/gists{/gist_id}","starred_url":"https://api.github.com/users/guavajellyaaron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guavajellyaaron/subscriptions","organizations_url":"https://api.github.com/users/guavajellyaaron/orgs","repos_url":"https://api.github.com/users/guavajellyaaron/repos","events_url":"https://api.github.com/users/guavajellyaaron/events{/privacy}","received_events_url":"https://api.github.com/users/guavajellyaaron/received_events","type":"User","site_admin":false},"body":"Added Specialization model and updated the MyStrategies/Update/Create pages","created_at":"2016-05-24T05:28:11Z","updated_at":"2016-05-24T15:55:42Z","closed_at":null,"merged_at":null,"merge_commit_sha":"44b4384129fba72a76035ae687d9e265968e9639","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25/commits","review_comments_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25/comments","review_comment_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/comments{/number}","comments_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/25/comments","statuses_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/statuses/650a0bdf6c247a79ae2cab08e2a923301f6bee7f","head":{"label":"guavajellyaaron:feature/strategy_create","ref":"feature/strategy_create","sha":"650a0bdf6c247a79ae2cab08e2a923301f6bee7f","user":{"login":"guavajellyaaron","id":8316984,"avatar_url":"https://avatars.githubusercontent.com/u/8316984?v=3","gravatar_id":"","url":"https://api.github.com/users/guavajellyaaron","html_url":"https://github.com/guavajellyaaron","followers_url":"https://api.github.com/users/guavajellyaaron/followers","following_url":"https://api.github.com/users/guavajellyaaron/following{/other_user}","gists_url":"https://api.github.com/users/guavajellyaaron/gists{/gist_id}","starred_url":"https://api.github.com/users/guavajellyaaron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guavajellyaaron/subscriptions","organizations_url":"https://api.github.com/users/guavajellyaaron/orgs","repos_url":"https://api.github.com/users/guavajellyaaron/repos","events_url":"https://api.github.com/users/guavajellyaaron/events{/privacy}","received_events_url":"https://api.github.com/users/guavajellyaaron/received_events","type":"User","site_admin":false},"repo":{"id":22457785,"name":"BossCheatSheets","full_name":"guavajellyaaron/BossCheatSheets","owner":{"login":"guavajellyaaron","id":8316984,"avatar_url":"https://avatars.githubusercontent.com/u/8316984?v=3","gravatar_id":"","url":"https://api.github.com/users/guavajellyaaron","html_url":"https://github.com/guavajellyaaron","followers_url":"https://api.github.com/users/guavajellyaaron/followers","following_url":"https://api.github.com/users/guavajellyaaron/following{/other_user}","gists_url":"https://api.github.com/users/guavajellyaaron/gists{/gist_id}","starred_url":"https://api.github.com/users/guavajellyaaron/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/guavajellyaaron/subscriptions","organizations_url":"https://api.github.com/users/guavajellyaaron/orgs","repos_url":"https://api.github.com/users/guavajellyaaron/repos","events_url":"https://api.github.com/users/guavajellyaaron/events{/privacy}","received_events_url":"https://api.github.com/users/guavajellyaaron/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/guavajellyaaron/BossCheatSheets","description":"Website for user generated boss fight tactics. Exports to popular game add-ons","fork":true,"url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets","forks_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/forks","keys_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/keys{/key_id}","collaborators_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/teams","hooks_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/hooks","issue_events_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/issues/events{/number}","events_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/events","assignees_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/assignees{/user}","branches_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/branches{/branch}","tags_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/tags","blobs_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/git/refs{/sha}","trees_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/git/trees{/sha}","statuses_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/statuses/{sha}","languages_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/languages","stargazers_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/stargazers","contributors_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/contributors","subscribers_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/subscribers","subscription_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/subscription","commits_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/commits{/sha}","git_commits_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/git/commits{/sha}","comments_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/comments{/number}","issue_comment_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/issues/comments{/number}","contents_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/contents/{+path}","compare_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/compare/{base}...{head}","merges_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/merges","archive_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/downloads","issues_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/issues{/number}","pulls_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/pulls{/number}","milestones_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/milestones{/number}","notifications_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/labels{/name}","releases_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/releases{/id}","deployments_url":"https://api.github.com/repos/guavajellyaaron/BossCheatSheets/deployments","created_at":"2014-07-31T05:32:35Z","updated_at":"2014-07-31T05:23:57Z","pushed_at":"2016-05-24T06:23:55Z","git_url":"git://github.com/guavajellyaaron/BossCheatSheets.git","ssh_url":"git@github.com:guavajellyaaron/BossCheatSheets.git","clone_url":"https://github.com/guavajellyaaron/BossCheatSheets.git","svn_url":"https://github.com/guavajellyaaron/BossCheatSheets","homepage":"bosscheatsheets.com","size":1658,"stargazers_count":0,"watchers_count":0,"language":null,"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":"GuavaJelly:integration","ref":"integration","sha":"4cc7d75285dd73efbf086d120cf415f59632eaa3","user":{"login":"GuavaJelly","id":7808958,"avatar_url":"https://avatars.githubusercontent.com/u/7808958?v=3","gravatar_id":"","url":"https://api.github.com/users/GuavaJelly","html_url":"https://github.com/GuavaJelly","followers_url":"https://api.github.com/users/GuavaJelly/followers","following_url":"https://api.github.com/users/GuavaJelly/following{/other_user}","gists_url":"https://api.github.com/users/GuavaJelly/gists{/gist_id}","starred_url":"https://api.github.com/users/GuavaJelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GuavaJelly/subscriptions","organizations_url":"https://api.github.com/users/GuavaJelly/orgs","repos_url":"https://api.github.com/users/GuavaJelly/repos","events_url":"https://api.github.com/users/GuavaJelly/events{/privacy}","received_events_url":"https://api.github.com/users/GuavaJelly/received_events","type":"Organization","site_admin":false},"repo":{"id":20540073,"name":"BossCheatSheets","full_name":"GuavaJelly/BossCheatSheets","owner":{"login":"GuavaJelly","id":7808958,"avatar_url":"https://avatars.githubusercontent.com/u/7808958?v=3","gravatar_id":"","url":"https://api.github.com/users/GuavaJelly","html_url":"https://github.com/GuavaJelly","followers_url":"https://api.github.com/users/GuavaJelly/followers","following_url":"https://api.github.com/users/GuavaJelly/following{/other_user}","gists_url":"https://api.github.com/users/GuavaJelly/gists{/gist_id}","starred_url":"https://api.github.com/users/GuavaJelly/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/GuavaJelly/subscriptions","organizations_url":"https://api.github.com/users/GuavaJelly/orgs","repos_url":"https://api.github.com/users/GuavaJelly/repos","events_url":"https://api.github.com/users/GuavaJelly/events{/privacy}","received_events_url":"https://api.github.com/users/GuavaJelly/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/GuavaJelly/BossCheatSheets","description":"Website for user generated boss fight tactics. Exports to popular game add-ons","fork":false,"url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets","forks_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/forks","keys_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/keys{/key_id}","collaborators_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/teams","hooks_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/hooks","issue_events_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/events{/number}","events_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/events","assignees_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/assignees{/user}","branches_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/branches{/branch}","tags_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/tags","blobs_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/git/refs{/sha}","trees_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/git/trees{/sha}","statuses_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/statuses/{sha}","languages_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/languages","stargazers_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/stargazers","contributors_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/contributors","subscribers_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/subscribers","subscription_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/subscription","commits_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/commits{/sha}","git_commits_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/git/commits{/sha}","comments_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/comments{/number}","issue_comment_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/comments{/number}","contents_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/contents/{+path}","compare_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/compare/{base}...{head}","merges_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/merges","archive_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/downloads","issues_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues{/number}","pulls_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls{/number}","milestones_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/milestones{/number}","notifications_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/labels{/name}","releases_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/releases{/id}","deployments_url":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/deployments","created_at":"2014-06-05T20:18:38Z","updated_at":"2016-04-11T18:37:31Z","pushed_at":"2016-05-24T06:23:56Z","git_url":"git://github.com/GuavaJelly/BossCheatSheets.git","ssh_url":"git@github.com:GuavaJelly/BossCheatSheets.git","clone_url":"https://github.com/GuavaJelly/BossCheatSheets.git","svn_url":"https://github.com/GuavaJelly/BossCheatSheets","homepage":"bosscheatsheets.com","size":1646,"stargazers_count":0,"watchers_count":0,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":2,"mirror_url":null,"open_issues_count":1,"forks":2,"open_issues":1,"watchers":0,"default_branch":"integration"}},"_links":{"self":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25"},"html":{"href":"https://github.com/GuavaJelly/BossCheatSheets/pull/25"},"issue":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/25"},"comments":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/issues/25/comments"},"review_comments":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25/comments"},"review_comment":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/pulls/25/commits"},"statuses":{"href":"https://api.github.com/repos/GuavaJelly/BossCheatSheets/statuses/650a0bdf6c247a79ae2cab08e2a923301f6bee7f"}}}}
{"actor":{"display_login":"happygaijin"}}