{"action":"created","comment":{"url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/comments/30294099","id":30294099,"diff_hunk":"@@ -712,18 +712,22 @@ CREATE TABLE `%TABLE_PREFIX%lock` (\n   KEY `staff_id` (`staff_id`)\n ) DEFAULT CHARSET=utf8;\n \n-DROP TABLE IF EXISTS `%TABLE_PREFIX%ticket_event`;\n-CREATE TABLE `%TABLE_PREFIX%ticket_event` (\n-  `ticket_id` int(11) unsigned NOT NULL default '0',\n+DROP TABLE IF EXISTS `%TABLE_PREFIX%thread_event`;\n+CREATE TABLE `%TABLE_PREFIX%thread_event` (\n+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n+  `thread_id` int(11) unsigned NOT NULL default '0',\n   `staff_id` int(11) unsigned NOT NULL,\n   `team_id` int(11) unsigned NOT NULL,\n   `dept_id` int(11) unsigned NOT NULL,\n   `topic_id` int(11) unsigned NOT NULL,\n-  `state` enum('created','closed','reopened','assigned','transferred','overdue') NOT NULL,\n-  `staff` varchar(255) NOT NULL default 'SYSTEM',\n+  `state` enum('created','closed','reopened','assigned','transferred','overdue','edited','viewed','error','collab','resent') NOT NULL,\n+  `data` varchar(1024) DEFAULT NULL COMMENT 'Encoded differences',","path":"setup/inc/streams/core/install-mysql.sql","position":18,"original_position":18,"commit_id":"f9c0eaeb0d15f2411a4e5cedb9dd21d8629eb8e6","original_commit_id":"f9c0eaeb0d15f2411a4e5cedb9dd21d8629eb8e6","user":{"login":"greezybacon","id":672074,"avatar_url":"https://avatars.githubusercontent.com/u/672074?v=3","gravatar_id":"","url":"https://api.github.com/users/greezybacon","html_url":"https://github.com/greezybacon","followers_url":"https://api.github.com/users/greezybacon/followers","following_url":"https://api.github.com/users/greezybacon/following{/other_user}","gists_url":"https://api.github.com/users/greezybacon/gists{/gist_id}","starred_url":"https://api.github.com/users/greezybacon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greezybacon/subscriptions","organizations_url":"https://api.github.com/users/greezybacon/orgs","repos_url":"https://api.github.com/users/greezybacon/repos","events_url":"https://api.github.com/users/greezybacon/events{/privacy}","received_events_url":"https://api.github.com/users/greezybacon/received_events","type":"User","site_admin":false},"body":"This can be ascii collated which will help better space utilization in database row packing","created_at":"2015-05-14T02:41:52Z","updated_at":"2015-05-14T02:41:52Z","html_url":"https://github.com/osTicket/osTicket-1.8/pull/2058#discussion_r30294099","pull_request_url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058","_links":{"self":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/comments/30294099"},"html":{"href":"https://github.com/osTicket/osTicket-1.8/pull/2058#discussion_r30294099"},"pull_request":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058"}}},"pull_request":{"url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058","id":35389529,"html_url":"https://github.com/osTicket/osTicket-1.8/pull/2058","diff_url":"https://github.com/osTicket/osTicket-1.8/pull/2058.diff","patch_url":"https://github.com/osTicket/osTicket-1.8/pull/2058.patch","issue_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2058","number":2058,"state":"open","locked":false,"title":"Feature :: Thread events","user":{"login":"greezybacon","id":672074,"avatar_url":"https://avatars.githubusercontent.com/u/672074?v=3","gravatar_id":"","url":"https://api.github.com/users/greezybacon","html_url":"https://github.com/greezybacon","followers_url":"https://api.github.com/users/greezybacon/followers","following_url":"https://api.github.com/users/greezybacon/following{/other_user}","gists_url":"https://api.github.com/users/greezybacon/gists{/gist_id}","starred_url":"https://api.github.com/users/greezybacon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greezybacon/subscriptions","organizations_url":"https://api.github.com/users/greezybacon/orgs","repos_url":"https://api.github.com/users/greezybacon/repos","events_url":"https://api.github.com/users/greezybacon/events{/privacy}","received_events_url":"https://api.github.com/users/greezybacon/received_events","type":"User","site_admin":false},"body":"This feature suggests a more modern look and feel to the ticket thread and retires many of the system-posted \"internal notes\", such as assignments, transfers, and edits. This allows internal notes to be reserved for agent communication and real notes.\r\n\r\nIt also removes the requirement for assignment and transfer comments as well as comments required when editing a ticket.\r\n\r\n### Screenshots\r\n![screen shot 2015-05-13 at 9 33 30 pm](https://cloud.githubusercontent.com/assets/672074/7625081/5800da2a-f9b8-11e4-8071-0a0b7031328a.png)\r\n![screen shot 2015-05-13 at 9 36 17 pm](https://cloud.githubusercontent.com/assets/672074/7625082/5b19d4aa-f9b8-11e4-858a-9e7f329d6625.png)\r\n","created_at":"2015-05-14T02:39:59Z","updated_at":"2015-05-14T02:41:52Z","closed_at":null,"merged_at":null,"merge_commit_sha":"c6dfffe92eb84976b1292111c6a09c6eed644e2c","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058/commits","review_comments_url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058/comments","review_comment_url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/comments{/number}","comments_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2058/comments","statuses_url":"https://api.github.com/repos/osTicket/osTicket-1.8/statuses/f9c0eaeb0d15f2411a4e5cedb9dd21d8629eb8e6","head":{"label":"greezybacon:feature/ticket-events","ref":"feature/ticket-events","sha":"f9c0eaeb0d15f2411a4e5cedb9dd21d8629eb8e6","user":{"login":"greezybacon","id":672074,"avatar_url":"https://avatars.githubusercontent.com/u/672074?v=3","gravatar_id":"","url":"https://api.github.com/users/greezybacon","html_url":"https://github.com/greezybacon","followers_url":"https://api.github.com/users/greezybacon/followers","following_url":"https://api.github.com/users/greezybacon/following{/other_user}","gists_url":"https://api.github.com/users/greezybacon/gists{/gist_id}","starred_url":"https://api.github.com/users/greezybacon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greezybacon/subscriptions","organizations_url":"https://api.github.com/users/greezybacon/orgs","repos_url":"https://api.github.com/users/greezybacon/repos","events_url":"https://api.github.com/users/greezybacon/events{/privacy}","received_events_url":"https://api.github.com/users/greezybacon/received_events","type":"User","site_admin":false},"repo":{"id":12064648,"name":"osTicket-1.8","full_name":"greezybacon/osTicket-1.8","owner":{"login":"greezybacon","id":672074,"avatar_url":"https://avatars.githubusercontent.com/u/672074?v=3","gravatar_id":"","url":"https://api.github.com/users/greezybacon","html_url":"https://github.com/greezybacon","followers_url":"https://api.github.com/users/greezybacon/followers","following_url":"https://api.github.com/users/greezybacon/following{/other_user}","gists_url":"https://api.github.com/users/greezybacon/gists{/gist_id}","starred_url":"https://api.github.com/users/greezybacon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greezybacon/subscriptions","organizations_url":"https://api.github.com/users/greezybacon/orgs","repos_url":"https://api.github.com/users/greezybacon/repos","events_url":"https://api.github.com/users/greezybacon/events{/privacy}","received_events_url":"https://api.github.com/users/greezybacon/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/greezybacon/osTicket-1.8","description":"Codename: Rumors","fork":true,"url":"https://api.github.com/repos/greezybacon/osTicket-1.8","forks_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/forks","keys_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/keys{/key_id}","collaborators_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/teams","hooks_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/hooks","issue_events_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/issues/events{/number}","events_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/events","assignees_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/assignees{/user}","branches_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/branches{/branch}","tags_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/tags","blobs_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/git/refs{/sha}","trees_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/git/trees{/sha}","statuses_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/statuses/{sha}","languages_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/languages","stargazers_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/stargazers","contributors_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/contributors","subscribers_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/subscribers","subscription_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/subscription","commits_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/commits{/sha}","git_commits_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/git/commits{/sha}","comments_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/comments{/number}","issue_comment_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/issues/comments{/number}","contents_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/contents/{+path}","compare_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/compare/{base}...{head}","merges_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/merges","archive_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/downloads","issues_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/issues{/number}","pulls_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/pulls{/number}","milestones_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/milestones{/number}","notifications_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/labels{/name}","releases_url":"https://api.github.com/repos/greezybacon/osTicket-1.8/releases{/id}","created_at":"2013-08-12T19:41:05Z","updated_at":"2015-04-10T13:02:51Z","pushed_at":"2015-05-14T02:33:02Z","git_url":"git://github.com/greezybacon/osTicket-1.8.git","ssh_url":"git@github.com:greezybacon/osTicket-1.8.git","clone_url":"https://github.com/greezybacon/osTicket-1.8.git","svn_url":"https://github.com/greezybacon/osTicket-1.8","homepage":null,"size":24932,"stargazers_count":1,"watchers_count":1,"language":"PHP","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":6,"mirror_url":null,"open_issues_count":1,"forks":6,"open_issues":1,"watchers":1,"default_branch":"develop"}},"base":{"label":"osTicket:develop-next","ref":"develop-next","sha":"204100b2c7dcbccc5b76d7a3bb19371dd70c4def","user":{"login":"osTicket","id":371413,"avatar_url":"https://avatars.githubusercontent.com/u/371413?v=3","gravatar_id":"","url":"https://api.github.com/users/osTicket","html_url":"https://github.com/osTicket","followers_url":"https://api.github.com/users/osTicket/followers","following_url":"https://api.github.com/users/osTicket/following{/other_user}","gists_url":"https://api.github.com/users/osTicket/gists{/gist_id}","starred_url":"https://api.github.com/users/osTicket/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/osTicket/subscriptions","organizations_url":"https://api.github.com/users/osTicket/orgs","repos_url":"https://api.github.com/users/osTicket/repos","events_url":"https://api.github.com/users/osTicket/events{/privacy}","received_events_url":"https://api.github.com/users/osTicket/received_events","type":"Organization","site_admin":false},"repo":{"id":12063996,"name":"osTicket-1.8","full_name":"osTicket/osTicket-1.8","owner":{"login":"osTicket","id":371413,"avatar_url":"https://avatars.githubusercontent.com/u/371413?v=3","gravatar_id":"","url":"https://api.github.com/users/osTicket","html_url":"https://github.com/osTicket","followers_url":"https://api.github.com/users/osTicket/followers","following_url":"https://api.github.com/users/osTicket/following{/other_user}","gists_url":"https://api.github.com/users/osTicket/gists{/gist_id}","starred_url":"https://api.github.com/users/osTicket/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/osTicket/subscriptions","organizations_url":"https://api.github.com/users/osTicket/orgs","repos_url":"https://api.github.com/users/osTicket/repos","events_url":"https://api.github.com/users/osTicket/events{/privacy}","received_events_url":"https://api.github.com/users/osTicket/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/osTicket/osTicket-1.8","description":"The osTicket open source ticketing system official project repository, for versions 1.8 and later","fork":false,"url":"https://api.github.com/repos/osTicket/osTicket-1.8","forks_url":"https://api.github.com/repos/osTicket/osTicket-1.8/forks","keys_url":"https://api.github.com/repos/osTicket/osTicket-1.8/keys{/key_id}","collaborators_url":"https://api.github.com/repos/osTicket/osTicket-1.8/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/osTicket/osTicket-1.8/teams","hooks_url":"https://api.github.com/repos/osTicket/osTicket-1.8/hooks","issue_events_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/events{/number}","events_url":"https://api.github.com/repos/osTicket/osTicket-1.8/events","assignees_url":"https://api.github.com/repos/osTicket/osTicket-1.8/assignees{/user}","branches_url":"https://api.github.com/repos/osTicket/osTicket-1.8/branches{/branch}","tags_url":"https://api.github.com/repos/osTicket/osTicket-1.8/tags","blobs_url":"https://api.github.com/repos/osTicket/osTicket-1.8/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/osTicket/osTicket-1.8/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/osTicket/osTicket-1.8/git/refs{/sha}","trees_url":"https://api.github.com/repos/osTicket/osTicket-1.8/git/trees{/sha}","statuses_url":"https://api.github.com/repos/osTicket/osTicket-1.8/statuses/{sha}","languages_url":"https://api.github.com/repos/osTicket/osTicket-1.8/languages","stargazers_url":"https://api.github.com/repos/osTicket/osTicket-1.8/stargazers","contributors_url":"https://api.github.com/repos/osTicket/osTicket-1.8/contributors","subscribers_url":"https://api.github.com/repos/osTicket/osTicket-1.8/subscribers","subscription_url":"https://api.github.com/repos/osTicket/osTicket-1.8/subscription","commits_url":"https://api.github.com/repos/osTicket/osTicket-1.8/commits{/sha}","git_commits_url":"https://api.github.com/repos/osTicket/osTicket-1.8/git/commits{/sha}","comments_url":"https://api.github.com/repos/osTicket/osTicket-1.8/comments{/number}","issue_comment_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/comments{/number}","contents_url":"https://api.github.com/repos/osTicket/osTicket-1.8/contents/{+path}","compare_url":"https://api.github.com/repos/osTicket/osTicket-1.8/compare/{base}...{head}","merges_url":"https://api.github.com/repos/osTicket/osTicket-1.8/merges","archive_url":"https://api.github.com/repos/osTicket/osTicket-1.8/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/osTicket/osTicket-1.8/downloads","issues_url":"https://api.github.com/repos/osTicket/osTicket-1.8/issues{/number}","pulls_url":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls{/number}","milestones_url":"https://api.github.com/repos/osTicket/osTicket-1.8/milestones{/number}","notifications_url":"https://api.github.com/repos/osTicket/osTicket-1.8/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/osTicket/osTicket-1.8/labels{/name}","releases_url":"https://api.github.com/repos/osTicket/osTicket-1.8/releases{/id}","created_at":"2013-08-12T19:10:14Z","updated_at":"2015-05-13T23:22:36Z","pushed_at":"2015-05-14T02:39:59Z","git_url":"git://github.com/osTicket/osTicket-1.8.git","ssh_url":"git@github.com:osTicket/osTicket-1.8.git","clone_url":"https://github.com/osTicket/osTicket-1.8.git","svn_url":"https://github.com/osTicket/osTicket-1.8","homepage":"osticket.com","size":30364,"stargazers_count":347,"watchers_count":347,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":336,"mirror_url":null,"open_issues_count":747,"forks":336,"open_issues":747,"watchers":347,"default_branch":"develop"}},"_links":{"self":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058"},"html":{"href":"https://github.com/osTicket/osTicket-1.8/pull/2058"},"issue":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2058"},"comments":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/issues/2058/comments"},"review_comments":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058/comments"},"review_comment":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/pulls/2058/commits"},"statuses":{"href":"https://api.github.com/repos/osTicket/osTicket-1.8/statuses/f9c0eaeb0d15f2411a4e5cedb9dd21d8629eb8e6"}}}}