{"action":"created","comment":{"url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments/75205287","id":75205287,"diff_hunk":"@@ -0,0 +1,82 @@\n+USE [MPIdentityMaintenance]\n+GO\n+/****** Object:  StoredProcedure [dbo].[Get_Next_Available_ID]    Script Date: 8/17/2016 1:31:53 PM ******/\n+SET ANSI_NULLS ON\n+GO\n+SET QUOTED_IDENTIFIER ON\n+GO\n+-- ==============================================================================================================\n+-- Author:\t\tSandi Ritter\n+-- Create date: 8/12/2016\n+-- Description:\tThis process will be used by MP devs to get the next available ID for any table that has been gapped.\n+--              This process will take in a table name and then will query the range_tracker table\n+--              to verify that it is one of the gapped tables.  If it is not, it will return a message to the user.\n+--              If the input table is a gapped table, it will pull the next ID available in the range, verify\n+--              that the ID has not yet been used, update the range on the range_tracker table, and return the \n+--              ID to the user.  \n+-- ==============================================================================================================\n+ALTER PROCEDURE [dbo].[Get_Next_Available_ID]","path":"CI/SQL-Archive/20160817_143500_US4360-New SP-Get_Next_Available_ID.sql","position":18,"original_position":18,"commit_id":"d6ece71c4f5401a750af0355fdd81cb9f2b93b47","original_commit_id":"d6ece71c4f5401a750af0355fdd81cb9f2b93b47","user":{"login":"charlie-retzler","id":3252288,"avatar_url":"https://avatars.githubusercontent.com/u/3252288?v=3","gravatar_id":"","url":"https://api.github.com/users/charlie-retzler","html_url":"https://github.com/charlie-retzler","followers_url":"https://api.github.com/users/charlie-retzler/followers","following_url":"https://api.github.com/users/charlie-retzler/following{/other_user}","gists_url":"https://api.github.com/users/charlie-retzler/gists{/gist_id}","starred_url":"https://api.github.com/users/charlie-retzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/charlie-retzler/subscriptions","organizations_url":"https://api.github.com/users/charlie-retzler/orgs","repos_url":"https://api.github.com/users/charlie-retzler/repos","events_url":"https://api.github.com/users/charlie-retzler/events{/privacy}","received_events_url":"https://api.github.com/users/charlie-retzler/received_events","type":"User","site_admin":false},"body":"Do we need a if doesn't exist create procedure?","created_at":"2016-08-17T20:55:34Z","updated_at":"2016-08-17T20:55:34Z","html_url":"https://github.com/crdschurch/crds-angular/pull/2629#discussion_r75205287","pull_request_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629","_links":{"self":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments/75205287"},"html":{"href":"https://github.com/crdschurch/crds-angular/pull/2629#discussion_r75205287"},"pull_request":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629"}}},"pull_request":{"url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629","id":81705230,"html_url":"https://github.com/crdschurch/crds-angular/pull/2629","diff_url":"https://github.com/crdschurch/crds-angular/pull/2629.diff","patch_url":"https://github.com/crdschurch/crds-angular/pull/2629.patch","issue_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/2629","number":2629,"state":"open","locked":false,"title":"US4360 sql scripts for new sp and reseed process","user":{"login":"IngageRitterS","id":10061661,"avatar_url":"https://avatars.githubusercontent.com/u/10061661?v=3","gravatar_id":"","url":"https://api.github.com/users/IngageRitterS","html_url":"https://github.com/IngageRitterS","followers_url":"https://api.github.com/users/IngageRitterS/followers","following_url":"https://api.github.com/users/IngageRitterS/following{/other_user}","gists_url":"https://api.github.com/users/IngageRitterS/gists{/gist_id}","starred_url":"https://api.github.com/users/IngageRitterS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IngageRitterS/subscriptions","organizations_url":"https://api.github.com/users/IngageRitterS/orgs","repos_url":"https://api.github.com/users/IngageRitterS/repos","events_url":"https://api.github.com/users/IngageRitterS/events{/privacy}","received_events_url":"https://api.github.com/users/IngageRitterS/received_events","type":"User","site_admin":false},"body":"","created_at":"2016-08-17T19:52:03Z","updated_at":"2016-08-17T20:55:34Z","closed_at":null,"merged_at":null,"merge_commit_sha":"adce270c0a6fdedc7231ad123967c0edaaf23336","assignee":{"login":"charlie-retzler","id":3252288,"avatar_url":"https://avatars.githubusercontent.com/u/3252288?v=3","gravatar_id":"","url":"https://api.github.com/users/charlie-retzler","html_url":"https://github.com/charlie-retzler","followers_url":"https://api.github.com/users/charlie-retzler/followers","following_url":"https://api.github.com/users/charlie-retzler/following{/other_user}","gists_url":"https://api.github.com/users/charlie-retzler/gists{/gist_id}","starred_url":"https://api.github.com/users/charlie-retzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/charlie-retzler/subscriptions","organizations_url":"https://api.github.com/users/charlie-retzler/orgs","repos_url":"https://api.github.com/users/charlie-retzler/repos","events_url":"https://api.github.com/users/charlie-retzler/events{/privacy}","received_events_url":"https://api.github.com/users/charlie-retzler/received_events","type":"User","site_admin":false},"assignees":[{"login":"charlie-retzler","id":3252288,"avatar_url":"https://avatars.githubusercontent.com/u/3252288?v=3","gravatar_id":"","url":"https://api.github.com/users/charlie-retzler","html_url":"https://github.com/charlie-retzler","followers_url":"https://api.github.com/users/charlie-retzler/followers","following_url":"https://api.github.com/users/charlie-retzler/following{/other_user}","gists_url":"https://api.github.com/users/charlie-retzler/gists{/gist_id}","starred_url":"https://api.github.com/users/charlie-retzler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/charlie-retzler/subscriptions","organizations_url":"https://api.github.com/users/charlie-retzler/orgs","repos_url":"https://api.github.com/users/charlie-retzler/repos","events_url":"https://api.github.com/users/charlie-retzler/events{/privacy}","received_events_url":"https://api.github.com/users/charlie-retzler/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/crdschurch/crds-angular/milestones/16","html_url":"https://github.com/crdschurch/crds-angular/milestones/Architecture%20&%20Tech%20Tasks","labels_url":"https://api.github.com/repos/crdschurch/crds-angular/milestones/16/labels","id":1802095,"number":16,"title":"Architecture & Tech Tasks","description":null,"creator":{"login":"IngageKrizJ","id":11178122,"avatar_url":"https://avatars.githubusercontent.com/u/11178122?v=3","gravatar_id":"","url":"https://api.github.com/users/IngageKrizJ","html_url":"https://github.com/IngageKrizJ","followers_url":"https://api.github.com/users/IngageKrizJ/followers","following_url":"https://api.github.com/users/IngageKrizJ/following{/other_user}","gists_url":"https://api.github.com/users/IngageKrizJ/gists{/gist_id}","starred_url":"https://api.github.com/users/IngageKrizJ/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/IngageKrizJ/subscriptions","organizations_url":"https://api.github.com/users/IngageKrizJ/orgs","repos_url":"https://api.github.com/users/IngageKrizJ/repos","events_url":"https://api.github.com/users/IngageKrizJ/events{/privacy}","received_events_url":"https://api.github.com/users/IngageKrizJ/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":7,"state":"open","created_at":"2016-06-01T11:52:13Z","updated_at":"2016-08-17T20:53:34Z","due_on":null,"closed_at":null},"commits_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629/commits","review_comments_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629/comments","review_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments{/number}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/2629/comments","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/d6ece71c4f5401a750af0355fdd81cb9f2b93b47","head":{"label":"crdschurch:feature/US4360-GapMPTables","ref":"feature/US4360-GapMPTables","sha":"d6ece71c4f5401a750af0355fdd81cb9f2b93b47","user":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"repo":{"id":26870034,"name":"crds-angular","full_name":"crdschurch/crds-angular","owner":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/crdschurch/crds-angular","description":"Starting point for angular development at crossroads","fork":false,"url":"https://api.github.com/repos/crdschurch/crds-angular","forks_url":"https://api.github.com/repos/crdschurch/crds-angular/forks","keys_url":"https://api.github.com/repos/crdschurch/crds-angular/keys{/key_id}","collaborators_url":"https://api.github.com/repos/crdschurch/crds-angular/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/crdschurch/crds-angular/teams","hooks_url":"https://api.github.com/repos/crdschurch/crds-angular/hooks","issue_events_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/events{/number}","events_url":"https://api.github.com/repos/crdschurch/crds-angular/events","assignees_url":"https://api.github.com/repos/crdschurch/crds-angular/assignees{/user}","branches_url":"https://api.github.com/repos/crdschurch/crds-angular/branches{/branch}","tags_url":"https://api.github.com/repos/crdschurch/crds-angular/tags","blobs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/crdschurch/crds-angular/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/refs{/sha}","trees_url":"https://api.github.com/repos/crdschurch/crds-angular/git/trees{/sha}","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/{sha}","languages_url":"https://api.github.com/repos/crdschurch/crds-angular/languages","stargazers_url":"https://api.github.com/repos/crdschurch/crds-angular/stargazers","contributors_url":"https://api.github.com/repos/crdschurch/crds-angular/contributors","subscribers_url":"https://api.github.com/repos/crdschurch/crds-angular/subscribers","subscription_url":"https://api.github.com/repos/crdschurch/crds-angular/subscription","commits_url":"https://api.github.com/repos/crdschurch/crds-angular/commits{/sha}","git_commits_url":"https://api.github.com/repos/crdschurch/crds-angular/git/commits{/sha}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/comments{/number}","issue_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/comments{/number}","contents_url":"https://api.github.com/repos/crdschurch/crds-angular/contents/{+path}","compare_url":"https://api.github.com/repos/crdschurch/crds-angular/compare/{base}...{head}","merges_url":"https://api.github.com/repos/crdschurch/crds-angular/merges","archive_url":"https://api.github.com/repos/crdschurch/crds-angular/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/crdschurch/crds-angular/downloads","issues_url":"https://api.github.com/repos/crdschurch/crds-angular/issues{/number}","pulls_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls{/number}","milestones_url":"https://api.github.com/repos/crdschurch/crds-angular/milestones{/number}","notifications_url":"https://api.github.com/repos/crdschurch/crds-angular/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/crdschurch/crds-angular/labels{/name}","releases_url":"https://api.github.com/repos/crdschurch/crds-angular/releases{/id}","deployments_url":"https://api.github.com/repos/crdschurch/crds-angular/deployments","created_at":"2014-11-19T16:21:09Z","updated_at":"2016-08-01T13:30:25Z","pushed_at":"2016-08-17T20:55:18Z","git_url":"git://github.com/crdschurch/crds-angular.git","ssh_url":"git@github.com:crdschurch/crds-angular.git","clone_url":"https://github.com/crdschurch/crds-angular.git","svn_url":"https://github.com/crdschurch/crds-angular","homepage":null,"size":46338,"stargazers_count":3,"watchers_count":3,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":2,"forks":4,"open_issues":2,"watchers":3,"default_branch":"development"}},"base":{"label":"crdschurch:development","ref":"development","sha":"4e92127f2d74bb8bc0f9742bd6f7e0a78fe2b501","user":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"repo":{"id":26870034,"name":"crds-angular","full_name":"crdschurch/crds-angular","owner":{"login":"crdschurch","id":1843144,"avatar_url":"https://avatars.githubusercontent.com/u/1843144?v=3","gravatar_id":"","url":"https://api.github.com/users/crdschurch","html_url":"https://github.com/crdschurch","followers_url":"https://api.github.com/users/crdschurch/followers","following_url":"https://api.github.com/users/crdschurch/following{/other_user}","gists_url":"https://api.github.com/users/crdschurch/gists{/gist_id}","starred_url":"https://api.github.com/users/crdschurch/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/crdschurch/subscriptions","organizations_url":"https://api.github.com/users/crdschurch/orgs","repos_url":"https://api.github.com/users/crdschurch/repos","events_url":"https://api.github.com/users/crdschurch/events{/privacy}","received_events_url":"https://api.github.com/users/crdschurch/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/crdschurch/crds-angular","description":"Starting point for angular development at crossroads","fork":false,"url":"https://api.github.com/repos/crdschurch/crds-angular","forks_url":"https://api.github.com/repos/crdschurch/crds-angular/forks","keys_url":"https://api.github.com/repos/crdschurch/crds-angular/keys{/key_id}","collaborators_url":"https://api.github.com/repos/crdschurch/crds-angular/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/crdschurch/crds-angular/teams","hooks_url":"https://api.github.com/repos/crdschurch/crds-angular/hooks","issue_events_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/events{/number}","events_url":"https://api.github.com/repos/crdschurch/crds-angular/events","assignees_url":"https://api.github.com/repos/crdschurch/crds-angular/assignees{/user}","branches_url":"https://api.github.com/repos/crdschurch/crds-angular/branches{/branch}","tags_url":"https://api.github.com/repos/crdschurch/crds-angular/tags","blobs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/crdschurch/crds-angular/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/crdschurch/crds-angular/git/refs{/sha}","trees_url":"https://api.github.com/repos/crdschurch/crds-angular/git/trees{/sha}","statuses_url":"https://api.github.com/repos/crdschurch/crds-angular/statuses/{sha}","languages_url":"https://api.github.com/repos/crdschurch/crds-angular/languages","stargazers_url":"https://api.github.com/repos/crdschurch/crds-angular/stargazers","contributors_url":"https://api.github.com/repos/crdschurch/crds-angular/contributors","subscribers_url":"https://api.github.com/repos/crdschurch/crds-angular/subscribers","subscription_url":"https://api.github.com/repos/crdschurch/crds-angular/subscription","commits_url":"https://api.github.com/repos/crdschurch/crds-angular/commits{/sha}","git_commits_url":"https://api.github.com/repos/crdschurch/crds-angular/git/commits{/sha}","comments_url":"https://api.github.com/repos/crdschurch/crds-angular/comments{/number}","issue_comment_url":"https://api.github.com/repos/crdschurch/crds-angular/issues/comments{/number}","contents_url":"https://api.github.com/repos/crdschurch/crds-angular/contents/{+path}","compare_url":"https://api.github.com/repos/crdschurch/crds-angular/compare/{base}...{head}","merges_url":"https://api.github.com/repos/crdschurch/crds-angular/merges","archive_url":"https://api.github.com/repos/crdschurch/crds-angular/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/crdschurch/crds-angular/downloads","issues_url":"https://api.github.com/repos/crdschurch/crds-angular/issues{/number}","pulls_url":"https://api.github.com/repos/crdschurch/crds-angular/pulls{/number}","milestones_url":"https://api.github.com/repos/crdschurch/crds-angular/milestones{/number}","notifications_url":"https://api.github.com/repos/crdschurch/crds-angular/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/crdschurch/crds-angular/labels{/name}","releases_url":"https://api.github.com/repos/crdschurch/crds-angular/releases{/id}","deployments_url":"https://api.github.com/repos/crdschurch/crds-angular/deployments","created_at":"2014-11-19T16:21:09Z","updated_at":"2016-08-01T13:30:25Z","pushed_at":"2016-08-17T20:55:18Z","git_url":"git://github.com/crdschurch/crds-angular.git","ssh_url":"git@github.com:crdschurch/crds-angular.git","clone_url":"https://github.com/crdschurch/crds-angular.git","svn_url":"https://github.com/crdschurch/crds-angular","homepage":null,"size":46338,"stargazers_count":3,"watchers_count":3,"language":"C#","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":4,"mirror_url":null,"open_issues_count":2,"forks":4,"open_issues":2,"watchers":3,"default_branch":"development"}},"_links":{"self":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629"},"html":{"href":"https://github.com/crdschurch/crds-angular/pull/2629"},"issue":{"href":"https://api.github.com/repos/crdschurch/crds-angular/issues/2629"},"comments":{"href":"https://api.github.com/repos/crdschurch/crds-angular/issues/2629/comments"},"review_comments":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629/comments"},"review_comment":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/crdschurch/crds-angular/pulls/2629/commits"},"statuses":{"href":"https://api.github.com/repos/crdschurch/crds-angular/statuses/d6ece71c4f5401a750af0355fdd81cb9f2b93b47"}}}}
{"actor":{"display_login":"charlie-retzler"}}