{"action":"created","comment":{"url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/comments/47777264","id":47777264,"diff_hunk":"@@ -0,0 +1,43 @@\n+using System;\n+using System.Collections.Generic;\n+using Umbraco.Core.Persistence;\n+using Umbraco.Core.Persistence.DatabaseAnnotations;\n+using Umbraco.Core.Persistence.DatabaseModelDefinitions;\n+\n+namespace Umbraco.Core.Models.Rdbms\n+{\n+    [TableName(\"umbracoDeployChecksum\")]\n+    [PrimaryKey(\"id\")]\n+    [ExplicitColumns]\n+    internal class UmbracoDeployChecksumDto\n+    {\n+        [Column(\"id\")]\n+        [PrimaryKeyColumn(Name = \"PK_umbracoDeployChecksum\")]\n+        public int Id { get; set; }\n+\n+        [Column(\"entityType\")]\n+        [Length(32)]\n+        [NullSetting(NullSetting = NullSettings.NotNull)]\n+        [Index(IndexTypes.UniqueNonClustered, Name = \"IX_umbracoDeployChecksum\", ForColumns = \"entityType,entityGuid,entityPath\")]\n+        public string EntityType { get; set; }\n+\n+        [Column(\"entityGuid\")]\n+        [NullSetting(NullSetting = NullSettings.Null)]\n+        public Guid EntityGuid { get; set; }\n+\n+        [Column(\"entityPath\")]\n+        [Length(256)]\n+        [NullSetting(NullSetting = NullSettings.Null)]\n+        public string EntityPath { get; set; }\n+\n+        [Column(\"localChecksum\")]\n+        [NullSetting(NullSetting = NullSettings.NotNull)]\n+        [Length(32)]\n+        public string LocalChecksum { get; set; }","path":"src/Umbraco.Core/Models/Rdbms/UmbracoDeployChecksumDto.cs","position":36,"original_position":36,"commit_id":"8260c12d645803477a5d60d438f9f09136465261","original_commit_id":"8260c12d645803477a5d60d438f9f09136465261","user":{"login":"zpqrtbnk","id":2846429,"avatar_url":"https://avatars.githubusercontent.com/u/2846429?v=3","gravatar_id":"","url":"https://api.github.com/users/zpqrtbnk","html_url":"https://github.com/zpqrtbnk","followers_url":"https://api.github.com/users/zpqrtbnk/followers","following_url":"https://api.github.com/users/zpqrtbnk/following{/other_user}","gists_url":"https://api.github.com/users/zpqrtbnk/gists{/gist_id}","starred_url":"https://api.github.com/users/zpqrtbnk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zpqrtbnk/subscriptions","organizations_url":"https://api.github.com/users/zpqrtbnk/orgs","repos_url":"https://api.github.com/users/zpqrtbnk/repos","events_url":"https://api.github.com/users/zpqrtbnk/events{/privacy}","received_events_url":"https://api.github.com/users/zpqrtbnk/received_events","type":"User","site_admin":false},"body":"I think the path should be 512 - and the checksum could be 128.","created_at":"2015-12-16T13:53:01Z","updated_at":"2015-12-16T13:53:01Z","html_url":"https://github.com/umbraco/Umbraco-CMS/pull/960#discussion_r47777264","pull_request_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960","_links":{"self":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/comments/47777264"},"html":{"href":"https://github.com/umbraco/Umbraco-CMS/pull/960#discussion_r47777264"},"pull_request":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960"}}},"pull_request":{"url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960","id":53838740,"html_url":"https://github.com/umbraco/Umbraco-CMS/pull/960","diff_url":"https://github.com/umbraco/Umbraco-CMS/pull/960.diff","patch_url":"https://github.com/umbraco/Umbraco-CMS/pull/960.patch","issue_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/960","number":960,"state":"open","locked":false,"title":"deploy-31 Implement DB changes for Umbraco Deploy","user":{"login":"Shazwazza","id":1742685,"avatar_url":"https://avatars.githubusercontent.com/u/1742685?v=3","gravatar_id":"","url":"https://api.github.com/users/Shazwazza","html_url":"https://github.com/Shazwazza","followers_url":"https://api.github.com/users/Shazwazza/followers","following_url":"https://api.github.com/users/Shazwazza/following{/other_user}","gists_url":"https://api.github.com/users/Shazwazza/gists{/gist_id}","starred_url":"https://api.github.com/users/Shazwazza/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Shazwazza/subscriptions","organizations_url":"https://api.github.com/users/Shazwazza/orgs","repos_url":"https://api.github.com/users/Shazwazza/repos","events_url":"https://api.github.com/users/Shazwazza/events{/privacy}","received_events_url":"https://api.github.com/users/Shazwazza/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-12-16T13:07:55Z","updated_at":"2015-12-16T13:53:01Z","closed_at":null,"merged_at":null,"merge_commit_sha":"be61120cd10ba2ebfdc32f47e478e88a197c68e0","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960/commits","review_comments_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960/comments","review_comment_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/comments{/number}","comments_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/960/comments","statuses_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/statuses/8260c12d645803477a5d60d438f9f09136465261","head":{"label":"umbraco:temp-deploy-31","ref":"temp-deploy-31","sha":"8260c12d645803477a5d60d438f9f09136465261","user":{"login":"umbraco","id":1419552,"avatar_url":"https://avatars.githubusercontent.com/u/1419552?v=3","gravatar_id":"","url":"https://api.github.com/users/umbraco","html_url":"https://github.com/umbraco","followers_url":"https://api.github.com/users/umbraco/followers","following_url":"https://api.github.com/users/umbraco/following{/other_user}","gists_url":"https://api.github.com/users/umbraco/gists{/gist_id}","starred_url":"https://api.github.com/users/umbraco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/umbraco/subscriptions","organizations_url":"https://api.github.com/users/umbraco/orgs","repos_url":"https://api.github.com/users/umbraco/repos","events_url":"https://api.github.com/users/umbraco/events{/privacy}","received_events_url":"https://api.github.com/users/umbraco/received_events","type":"Organization","site_admin":false},"repo":{"id":10601208,"name":"Umbraco-CMS","full_name":"umbraco/Umbraco-CMS","owner":{"login":"umbraco","id":1419552,"avatar_url":"https://avatars.githubusercontent.com/u/1419552?v=3","gravatar_id":"","url":"https://api.github.com/users/umbraco","html_url":"https://github.com/umbraco","followers_url":"https://api.github.com/users/umbraco/followers","following_url":"https://api.github.com/users/umbraco/following{/other_user}","gists_url":"https://api.github.com/users/umbraco/gists{/gist_id}","starred_url":"https://api.github.com/users/umbraco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/umbraco/subscriptions","organizations_url":"https://api.github.com/users/umbraco/orgs","repos_url":"https://api.github.com/users/umbraco/repos","events_url":"https://api.github.com/users/umbraco/events{/privacy}","received_events_url":"https://api.github.com/users/umbraco/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/umbraco/Umbraco-CMS","description":"The simple, flexible and friendly ASP.NET CMS used by more than 225.000 websites","fork":false,"url":"https://api.github.com/repos/umbraco/Umbraco-CMS","forks_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/forks","keys_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/keys{/key_id}","collaborators_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/teams","hooks_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/hooks","issue_events_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/events{/number}","events_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/events","assignees_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/assignees{/user}","branches_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/branches{/branch}","tags_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/tags","blobs_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/refs{/sha}","trees_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/trees{/sha}","statuses_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/statuses/{sha}","languages_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/languages","stargazers_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/stargazers","contributors_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/contributors","subscribers_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/subscribers","subscription_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/subscription","commits_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/commits{/sha}","git_commits_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/commits{/sha}","comments_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/comments{/number}","issue_comment_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/comments{/number}","contents_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/contents/{+path}","compare_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/compare/{base}...{head}","merges_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/merges","archive_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/downloads","issues_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues{/number}","pulls_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls{/number}","milestones_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/milestones{/number}","notifications_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/labels{/name}","releases_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/releases{/id}","created_at":"2013-06-10T13:50:46Z","updated_at":"2015-12-16T13:40:50Z","pushed_at":"2015-12-16T13:07:56Z","git_url":"git://github.com/umbraco/Umbraco-CMS.git","ssh_url":"git@github.com:umbraco/Umbraco-CMS.git","clone_url":"https://github.com/umbraco/Umbraco-CMS.git","svn_url":"https://github.com/umbraco/Umbraco-CMS","homepage":"http://umbraco.com","size":135203,"stargazers_count":1047,"watchers_count":1047,"language":"C#","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":867,"mirror_url":null,"open_issues_count":98,"forks":867,"open_issues":98,"watchers":1047,"default_branch":"dev-v7"}},"base":{"label":"umbraco:7.4.0","ref":"7.4.0","sha":"2729069b00dd018dae768156cf23d740b00fd408","user":{"login":"umbraco","id":1419552,"avatar_url":"https://avatars.githubusercontent.com/u/1419552?v=3","gravatar_id":"","url":"https://api.github.com/users/umbraco","html_url":"https://github.com/umbraco","followers_url":"https://api.github.com/users/umbraco/followers","following_url":"https://api.github.com/users/umbraco/following{/other_user}","gists_url":"https://api.github.com/users/umbraco/gists{/gist_id}","starred_url":"https://api.github.com/users/umbraco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/umbraco/subscriptions","organizations_url":"https://api.github.com/users/umbraco/orgs","repos_url":"https://api.github.com/users/umbraco/repos","events_url":"https://api.github.com/users/umbraco/events{/privacy}","received_events_url":"https://api.github.com/users/umbraco/received_events","type":"Organization","site_admin":false},"repo":{"id":10601208,"name":"Umbraco-CMS","full_name":"umbraco/Umbraco-CMS","owner":{"login":"umbraco","id":1419552,"avatar_url":"https://avatars.githubusercontent.com/u/1419552?v=3","gravatar_id":"","url":"https://api.github.com/users/umbraco","html_url":"https://github.com/umbraco","followers_url":"https://api.github.com/users/umbraco/followers","following_url":"https://api.github.com/users/umbraco/following{/other_user}","gists_url":"https://api.github.com/users/umbraco/gists{/gist_id}","starred_url":"https://api.github.com/users/umbraco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/umbraco/subscriptions","organizations_url":"https://api.github.com/users/umbraco/orgs","repos_url":"https://api.github.com/users/umbraco/repos","events_url":"https://api.github.com/users/umbraco/events{/privacy}","received_events_url":"https://api.github.com/users/umbraco/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/umbraco/Umbraco-CMS","description":"The simple, flexible and friendly ASP.NET CMS used by more than 225.000 websites","fork":false,"url":"https://api.github.com/repos/umbraco/Umbraco-CMS","forks_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/forks","keys_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/keys{/key_id}","collaborators_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/teams","hooks_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/hooks","issue_events_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/events{/number}","events_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/events","assignees_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/assignees{/user}","branches_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/branches{/branch}","tags_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/tags","blobs_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/refs{/sha}","trees_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/trees{/sha}","statuses_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/statuses/{sha}","languages_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/languages","stargazers_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/stargazers","contributors_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/contributors","subscribers_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/subscribers","subscription_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/subscription","commits_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/commits{/sha}","git_commits_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/git/commits{/sha}","comments_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/comments{/number}","issue_comment_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/comments{/number}","contents_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/contents/{+path}","compare_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/compare/{base}...{head}","merges_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/merges","archive_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/downloads","issues_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues{/number}","pulls_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls{/number}","milestones_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/milestones{/number}","notifications_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/labels{/name}","releases_url":"https://api.github.com/repos/umbraco/Umbraco-CMS/releases{/id}","created_at":"2013-06-10T13:50:46Z","updated_at":"2015-12-16T13:40:50Z","pushed_at":"2015-12-16T13:07:56Z","git_url":"git://github.com/umbraco/Umbraco-CMS.git","ssh_url":"git@github.com:umbraco/Umbraco-CMS.git","clone_url":"https://github.com/umbraco/Umbraco-CMS.git","svn_url":"https://github.com/umbraco/Umbraco-CMS","homepage":"http://umbraco.com","size":135203,"stargazers_count":1047,"watchers_count":1047,"language":"C#","has_issues":false,"has_downloads":true,"has_wiki":false,"has_pages":false,"forks_count":867,"mirror_url":null,"open_issues_count":98,"forks":867,"open_issues":98,"watchers":1047,"default_branch":"dev-v7"}},"_links":{"self":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960"},"html":{"href":"https://github.com/umbraco/Umbraco-CMS/pull/960"},"issue":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/960"},"comments":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/issues/960/comments"},"review_comments":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960/comments"},"review_comment":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/pulls/960/commits"},"statuses":{"href":"https://api.github.com/repos/umbraco/Umbraco-CMS/statuses/8260c12d645803477a5d60d438f9f09136465261"}}}}