{"action":"created","comment":{"url":"https://api.github.com/repos/maragatchalian/Board/pulls/comments/27271995","id":27271995,"diff_hunk":"@@ -1,46 +1,49 @@\n---\n--- Create database\n---\n CREATE DATABASE IF NOT EXISTS board;\n-GRANT SELECT, INSERT, UPDATE, DELETE ON board.* TO board_root@localhost IDENTIFIED BY ‘board_root’;\n+GRANT SELECT, INSERT, UPDATE, DELETE ON board.* TO board_root@localhost IDENTIFIED BY 'board_root';\n FLUSH PRIVILEGES;\n \n-\n-                    \n---\n--- Create tables\n---\n-\n-                   \n-USE board;\n-                    \n+Use board;\n CREATE TABLE IF NOT EXISTS thread (\n-id                      INT UNSIGNED NOT NULL AUTO_INCREMENT,\n-title                   VARCHAR(255) NOT NULL,\n-created              TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n-PRIMARY KEY (id)\n-)ENGINE=InnoDB;\n+    id INT(11) NOT NULL AUTO_INCREMENT,\n+    user_id INT(11) NOT NULL,\n+    title VARCHAR(50) NOT NULL,\n+    created  TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n+    PRIMARY KEY (id)\n+    )ENGINE=InnoDB;\n \n-\n-                    \n CREATE TABLE IF NOT EXISTS comment (\n-id                      INT UNSIGNED NOT NULL AUTO_INCREMENT,\n-thread_id               INT UNSIGNED NOT NULL,\n-username                VARCHAR(255) NOT NULL,\n-body                    TEXT NOT NULL,\n-created                 TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n-PRIMARY KEY (id),\n-INDEX (thread_id, created)\n-)ENGINE=InnoDB;\n+    id INT(11) NOT NULL AUTO_INCREMENT,\n+    thread_id INT(11) NOT NULL,\n+    user_id  INT(11) NOT NULL,\n+    username VARCHAR(11) NOT NULL,\n+    body VARCHAR(140) NOT NULL,\n+    created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,\n+    PRIMARY KEY (id),\n+    INDEX (thread_id, created)\n+    )ENGINE=InnoDB;\n \n CREATE TABLE IF NOT EXISTS user(\n-\tid INT NOT NULL AUTO_INCREMENT,\n-\tPRIMARY KEY(id),\n-\tusername VARCHAR(255) NOT NULL,\n-\tfirst_name VARCHAR(255)NOT NULL,\n-\tlast_name VARCHAR(255)NOT NULL,\n-\temail VARCHAR(255)NOT NULL,\n-\tpassword VARCHAR(255)NOT NULL,\n-)ENGINE=InnoDB;\n-\n+    id INT(11) NOT NULL AUTO_INCREMENT,\n+    username VARCHAR(20) NOT NULL,\n+    first_name VARCHAR(50) NOT NULL,\n+    last_name VARCHAR(50) NOT NULL,\n+    password VARCHAR(50) NOT NULL,\n+    email VARCHAR(255) NOT NULL,\n+    PRIMARY KEY (id)\n+    );  ","path":"board/app/config/sql/board.sql","position":70,"original_position":70,"commit_id":"d996d26b03787ece477c7c247b17b8be47a85200","original_commit_id":"d996d26b03787ece477c7c247b17b8be47a85200","user":{"login":"fatimaPHP","id":2126588,"avatar_url":"https://avatars.githubusercontent.com/u/2126588?v=3","gravatar_id":"","url":"https://api.github.com/users/fatimaPHP","html_url":"https://github.com/fatimaPHP","followers_url":"https://api.github.com/users/fatimaPHP/followers","following_url":"https://api.github.com/users/fatimaPHP/following{/other_user}","gists_url":"https://api.github.com/users/fatimaPHP/gists{/gist_id}","starred_url":"https://api.github.com/users/fatimaPHP/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fatimaPHP/subscriptions","organizations_url":"https://api.github.com/users/fatimaPHP/orgs","repos_url":"https://api.github.com/users/fatimaPHP/repos","events_url":"https://api.github.com/users/fatimaPHP/events{/privacy}","received_events_url":"https://api.github.com/users/fatimaPHP/received_events","type":"User","site_admin":false},"body":"remove indent po","created_at":"2015-03-27T02:02:09Z","updated_at":"2015-03-27T02:02:09Z","html_url":"https://github.com/maragatchalian/Board/pull/2#discussion_r27271995","pull_request_url":"https://api.github.com/repos/maragatchalian/Board/pulls/2","_links":{"self":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/comments/27271995"},"html":{"href":"https://github.com/maragatchalian/Board/pull/2#discussion_r27271995"},"pull_request":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/2"}}},"pull_request":{"url":"https://api.github.com/repos/maragatchalian/Board/pulls/2","id":31411789,"html_url":"https://github.com/maragatchalian/Board/pull/2","diff_url":"https://github.com/maragatchalian/Board/pull/2.diff","patch_url":"https://github.com/maragatchalian/Board/pull/2.patch","issue_url":"https://api.github.com/repos/maragatchalian/Board/issues/2","number":2,"state":"open","locked":false,"title":"dev_1.1","user":{"login":"maragatchalian","id":10491936,"avatar_url":"https://avatars.githubusercontent.com/u/10491936?v=3","gravatar_id":"","url":"https://api.github.com/users/maragatchalian","html_url":"https://github.com/maragatchalian","followers_url":"https://api.github.com/users/maragatchalian/followers","following_url":"https://api.github.com/users/maragatchalian/following{/other_user}","gists_url":"https://api.github.com/users/maragatchalian/gists{/gist_id}","starred_url":"https://api.github.com/users/maragatchalian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maragatchalian/subscriptions","organizations_url":"https://api.github.com/users/maragatchalian/orgs","repos_url":"https://api.github.com/users/maragatchalian/repos","events_url":"https://api.github.com/users/maragatchalian/events{/privacy}","received_events_url":"https://api.github.com/users/maragatchalian/received_events","type":"User","site_admin":false},"body":"","created_at":"2015-03-18T09:28:56Z","updated_at":"2015-03-27T02:02:09Z","closed_at":null,"merged_at":null,"merge_commit_sha":"a43a0a27a51157cdf37ef1847987dbaae89ab2aa","assignee":null,"milestone":null,"commits_url":"https://api.github.com/repos/maragatchalian/Board/pulls/2/commits","review_comments_url":"https://api.github.com/repos/maragatchalian/Board/pulls/2/comments","review_comment_url":"https://api.github.com/repos/maragatchalian/Board/pulls/comments{/number}","comments_url":"https://api.github.com/repos/maragatchalian/Board/issues/2/comments","statuses_url":"https://api.github.com/repos/maragatchalian/Board/statuses/d996d26b03787ece477c7c247b17b8be47a85200","head":{"label":"maragatchalian:dev_1.1","ref":"dev_1.1","sha":"d996d26b03787ece477c7c247b17b8be47a85200","user":{"login":"maragatchalian","id":10491936,"avatar_url":"https://avatars.githubusercontent.com/u/10491936?v=3","gravatar_id":"","url":"https://api.github.com/users/maragatchalian","html_url":"https://github.com/maragatchalian","followers_url":"https://api.github.com/users/maragatchalian/followers","following_url":"https://api.github.com/users/maragatchalian/following{/other_user}","gists_url":"https://api.github.com/users/maragatchalian/gists{/gist_id}","starred_url":"https://api.github.com/users/maragatchalian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maragatchalian/subscriptions","organizations_url":"https://api.github.com/users/maragatchalian/orgs","repos_url":"https://api.github.com/users/maragatchalian/repos","events_url":"https://api.github.com/users/maragatchalian/events{/privacy}","received_events_url":"https://api.github.com/users/maragatchalian/received_events","type":"User","site_admin":false},"repo":{"id":30956881,"name":"Board","full_name":"maragatchalian/Board","owner":{"login":"maragatchalian","id":10491936,"avatar_url":"https://avatars.githubusercontent.com/u/10491936?v=3","gravatar_id":"","url":"https://api.github.com/users/maragatchalian","html_url":"https://github.com/maragatchalian","followers_url":"https://api.github.com/users/maragatchalian/followers","following_url":"https://api.github.com/users/maragatchalian/following{/other_user}","gists_url":"https://api.github.com/users/maragatchalian/gists{/gist_id}","starred_url":"https://api.github.com/users/maragatchalian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maragatchalian/subscriptions","organizations_url":"https://api.github.com/users/maragatchalian/orgs","repos_url":"https://api.github.com/users/maragatchalian/repos","events_url":"https://api.github.com/users/maragatchalian/events{/privacy}","received_events_url":"https://api.github.com/users/maragatchalian/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/maragatchalian/Board","description":"","fork":false,"url":"https://api.github.com/repos/maragatchalian/Board","forks_url":"https://api.github.com/repos/maragatchalian/Board/forks","keys_url":"https://api.github.com/repos/maragatchalian/Board/keys{/key_id}","collaborators_url":"https://api.github.com/repos/maragatchalian/Board/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/maragatchalian/Board/teams","hooks_url":"https://api.github.com/repos/maragatchalian/Board/hooks","issue_events_url":"https://api.github.com/repos/maragatchalian/Board/issues/events{/number}","events_url":"https://api.github.com/repos/maragatchalian/Board/events","assignees_url":"https://api.github.com/repos/maragatchalian/Board/assignees{/user}","branches_url":"https://api.github.com/repos/maragatchalian/Board/branches{/branch}","tags_url":"https://api.github.com/repos/maragatchalian/Board/tags","blobs_url":"https://api.github.com/repos/maragatchalian/Board/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/maragatchalian/Board/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/maragatchalian/Board/git/refs{/sha}","trees_url":"https://api.github.com/repos/maragatchalian/Board/git/trees{/sha}","statuses_url":"https://api.github.com/repos/maragatchalian/Board/statuses/{sha}","languages_url":"https://api.github.com/repos/maragatchalian/Board/languages","stargazers_url":"https://api.github.com/repos/maragatchalian/Board/stargazers","contributors_url":"https://api.github.com/repos/maragatchalian/Board/contributors","subscribers_url":"https://api.github.com/repos/maragatchalian/Board/subscribers","subscription_url":"https://api.github.com/repos/maragatchalian/Board/subscription","commits_url":"https://api.github.com/repos/maragatchalian/Board/commits{/sha}","git_commits_url":"https://api.github.com/repos/maragatchalian/Board/git/commits{/sha}","comments_url":"https://api.github.com/repos/maragatchalian/Board/comments{/number}","issue_comment_url":"https://api.github.com/repos/maragatchalian/Board/issues/comments{/number}","contents_url":"https://api.github.com/repos/maragatchalian/Board/contents/{+path}","compare_url":"https://api.github.com/repos/maragatchalian/Board/compare/{base}...{head}","merges_url":"https://api.github.com/repos/maragatchalian/Board/merges","archive_url":"https://api.github.com/repos/maragatchalian/Board/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/maragatchalian/Board/downloads","issues_url":"https://api.github.com/repos/maragatchalian/Board/issues{/number}","pulls_url":"https://api.github.com/repos/maragatchalian/Board/pulls{/number}","milestones_url":"https://api.github.com/repos/maragatchalian/Board/milestones{/number}","notifications_url":"https://api.github.com/repos/maragatchalian/Board/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/maragatchalian/Board/labels{/name}","releases_url":"https://api.github.com/repos/maragatchalian/Board/releases{/id}","created_at":"2015-02-18T07:57:19Z","updated_at":"2015-03-26T10:15:41Z","pushed_at":"2015-03-26T10:15:42Z","git_url":"git://github.com/maragatchalian/Board.git","ssh_url":"git@github.com:maragatchalian/Board.git","clone_url":"https://github.com/maragatchalian/Board.git","svn_url":"https://github.com/maragatchalian/Board","homepage":null,"size":658,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":1,"forks":1,"open_issues":1,"watchers":0,"default_branch":"dev_1.1"}},"base":{"label":"maragatchalian:master","ref":"master","sha":"bdca9674839eb8587ec910778e139d05439ffda8","user":{"login":"maragatchalian","id":10491936,"avatar_url":"https://avatars.githubusercontent.com/u/10491936?v=3","gravatar_id":"","url":"https://api.github.com/users/maragatchalian","html_url":"https://github.com/maragatchalian","followers_url":"https://api.github.com/users/maragatchalian/followers","following_url":"https://api.github.com/users/maragatchalian/following{/other_user}","gists_url":"https://api.github.com/users/maragatchalian/gists{/gist_id}","starred_url":"https://api.github.com/users/maragatchalian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maragatchalian/subscriptions","organizations_url":"https://api.github.com/users/maragatchalian/orgs","repos_url":"https://api.github.com/users/maragatchalian/repos","events_url":"https://api.github.com/users/maragatchalian/events{/privacy}","received_events_url":"https://api.github.com/users/maragatchalian/received_events","type":"User","site_admin":false},"repo":{"id":30956881,"name":"Board","full_name":"maragatchalian/Board","owner":{"login":"maragatchalian","id":10491936,"avatar_url":"https://avatars.githubusercontent.com/u/10491936?v=3","gravatar_id":"","url":"https://api.github.com/users/maragatchalian","html_url":"https://github.com/maragatchalian","followers_url":"https://api.github.com/users/maragatchalian/followers","following_url":"https://api.github.com/users/maragatchalian/following{/other_user}","gists_url":"https://api.github.com/users/maragatchalian/gists{/gist_id}","starred_url":"https://api.github.com/users/maragatchalian/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/maragatchalian/subscriptions","organizations_url":"https://api.github.com/users/maragatchalian/orgs","repos_url":"https://api.github.com/users/maragatchalian/repos","events_url":"https://api.github.com/users/maragatchalian/events{/privacy}","received_events_url":"https://api.github.com/users/maragatchalian/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/maragatchalian/Board","description":"","fork":false,"url":"https://api.github.com/repos/maragatchalian/Board","forks_url":"https://api.github.com/repos/maragatchalian/Board/forks","keys_url":"https://api.github.com/repos/maragatchalian/Board/keys{/key_id}","collaborators_url":"https://api.github.com/repos/maragatchalian/Board/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/maragatchalian/Board/teams","hooks_url":"https://api.github.com/repos/maragatchalian/Board/hooks","issue_events_url":"https://api.github.com/repos/maragatchalian/Board/issues/events{/number}","events_url":"https://api.github.com/repos/maragatchalian/Board/events","assignees_url":"https://api.github.com/repos/maragatchalian/Board/assignees{/user}","branches_url":"https://api.github.com/repos/maragatchalian/Board/branches{/branch}","tags_url":"https://api.github.com/repos/maragatchalian/Board/tags","blobs_url":"https://api.github.com/repos/maragatchalian/Board/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/maragatchalian/Board/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/maragatchalian/Board/git/refs{/sha}","trees_url":"https://api.github.com/repos/maragatchalian/Board/git/trees{/sha}","statuses_url":"https://api.github.com/repos/maragatchalian/Board/statuses/{sha}","languages_url":"https://api.github.com/repos/maragatchalian/Board/languages","stargazers_url":"https://api.github.com/repos/maragatchalian/Board/stargazers","contributors_url":"https://api.github.com/repos/maragatchalian/Board/contributors","subscribers_url":"https://api.github.com/repos/maragatchalian/Board/subscribers","subscription_url":"https://api.github.com/repos/maragatchalian/Board/subscription","commits_url":"https://api.github.com/repos/maragatchalian/Board/commits{/sha}","git_commits_url":"https://api.github.com/repos/maragatchalian/Board/git/commits{/sha}","comments_url":"https://api.github.com/repos/maragatchalian/Board/comments{/number}","issue_comment_url":"https://api.github.com/repos/maragatchalian/Board/issues/comments{/number}","contents_url":"https://api.github.com/repos/maragatchalian/Board/contents/{+path}","compare_url":"https://api.github.com/repos/maragatchalian/Board/compare/{base}...{head}","merges_url":"https://api.github.com/repos/maragatchalian/Board/merges","archive_url":"https://api.github.com/repos/maragatchalian/Board/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/maragatchalian/Board/downloads","issues_url":"https://api.github.com/repos/maragatchalian/Board/issues{/number}","pulls_url":"https://api.github.com/repos/maragatchalian/Board/pulls{/number}","milestones_url":"https://api.github.com/repos/maragatchalian/Board/milestones{/number}","notifications_url":"https://api.github.com/repos/maragatchalian/Board/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/maragatchalian/Board/labels{/name}","releases_url":"https://api.github.com/repos/maragatchalian/Board/releases{/id}","created_at":"2015-02-18T07:57:19Z","updated_at":"2015-03-26T10:15:41Z","pushed_at":"2015-03-26T10:15:42Z","git_url":"git://github.com/maragatchalian/Board.git","ssh_url":"git@github.com:maragatchalian/Board.git","clone_url":"https://github.com/maragatchalian/Board.git","svn_url":"https://github.com/maragatchalian/Board","homepage":null,"size":658,"stargazers_count":0,"watchers_count":0,"language":"PHP","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":1,"mirror_url":null,"open_issues_count":1,"forks":1,"open_issues":1,"watchers":0,"default_branch":"dev_1.1"}},"_links":{"self":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/2"},"html":{"href":"https://github.com/maragatchalian/Board/pull/2"},"issue":{"href":"https://api.github.com/repos/maragatchalian/Board/issues/2"},"comments":{"href":"https://api.github.com/repos/maragatchalian/Board/issues/2/comments"},"review_comments":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/2/comments"},"review_comment":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/maragatchalian/Board/pulls/2/commits"},"statuses":{"href":"https://api.github.com/repos/maragatchalian/Board/statuses/d996d26b03787ece477c7c247b17b8be47a85200"}}}}