{"action":"created","comment":{"url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/comments/186645867","pull_request_review_id":118261011,"id":186645867,"diff_hunk":"@@ -0,0 +1,43 @@\n+CREATE DATABASE doingsdone\n+    DEFAULT CHARACTER SET utf8\n+    DEFAULT COLLATE utf8_general_ci;\n+\n+USE doingsdone;\n+\n+CREATE TABLE users (\n+   user_id int AUTO_INCREMENT PRIMARY KEY,\n+   reg_date datetime,\n+   email char(128),\n+   name char(50),\n+   user_pass char(64),\n+   contacts text\n+);\n+\n+CREATE TABLE projects (\n+   project_id int AUTO_INCREMENT PRIMARY KEY,\n+   project_name char(20),\n+   user_id int\n+);\n+\n+CREATE TABLE tasks (\n+   task_id int AUTO_INCREMENT PRIMARY KEY,\n+   creation_date datetime, \n+   done_date datetime,\n+   description char(60),\n+   file_name char(255),\n+   completion_date datetime,\n+   user_id int,\n+   project_id int\n+);\n+\n+CREATE UNIQUE INDEX user_id ON users(user_id);\n+CREATE UNIQUE INDEX email ON users(email);\n+CREATE UNIQUE INDEX project_id ON projects(project_id);\n+CREATE UNIQUE INDEX task_id ON tasks(task_id);\n+\n+CREATE INDEX u_mail ON users(email);\n+CREATE INDEX u_pass ON users(user_pass);\n+CREATE INDEX p_user ON projects(user_id);\n+CREATE INDEX t_description ON tasks(description);\n+CREATE INDEX t_completion ON tasks(completion_date);\n+CREATE INDEX t_proj_user ON tasks(project_id, user_id);","path":"schema.sql","position":43,"original_position":43,"commit_id":"e85d18bc2d81728fe793c35a86eb90aaf2cacf01","original_commit_id":"e85d18bc2d81728fe793c35a86eb90aaf2cacf01","user":{"login":"denlapaev","id":3096564,"avatar_url":"https://avatars0.githubusercontent.com/u/3096564?v=4","gravatar_id":"","url":"https://api.github.com/users/denlapaev","html_url":"https://github.com/denlapaev","followers_url":"https://api.github.com/users/denlapaev/followers","following_url":"https://api.github.com/users/denlapaev/following{/other_user}","gists_url":"https://api.github.com/users/denlapaev/gists{/gist_id}","starred_url":"https://api.github.com/users/denlapaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denlapaev/subscriptions","organizations_url":"https://api.github.com/users/denlapaev/orgs","repos_url":"https://api.github.com/users/denlapaev/repos","events_url":"https://api.github.com/users/denlapaev/events{/privacy}","received_events_url":"https://api.github.com/users/denlapaev/received_events","type":"User","site_admin":false},"body":"еще нужно прописать связи","created_at":"2018-05-08T08:01:03Z","updated_at":"2018-05-08T08:01:43Z","html_url":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7#discussion_r186645867","pull_request_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7","author_association":"COLLABORATOR","_links":{"self":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/comments/186645867"},"html":{"href":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7#discussion_r186645867"},"pull_request":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7"}}},"pull_request":{"url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7","id":186471773,"html_url":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7","diff_url":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7.diff","patch_url":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7.patch","issue_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/7","number":7,"state":"open","locked":false,"title":"Создание схемы БД личного проекта","user":{"login":"Kotelevets","id":38089141,"avatar_url":"https://avatars0.githubusercontent.com/u/38089141?v=4","gravatar_id":"","url":"https://api.github.com/users/Kotelevets","html_url":"https://github.com/Kotelevets","followers_url":"https://api.github.com/users/Kotelevets/followers","following_url":"https://api.github.com/users/Kotelevets/following{/other_user}","gists_url":"https://api.github.com/users/Kotelevets/gists{/gist_id}","starred_url":"https://api.github.com/users/Kotelevets/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kotelevets/subscriptions","organizations_url":"https://api.github.com/users/Kotelevets/orgs","repos_url":"https://api.github.com/users/Kotelevets/repos","events_url":"https://api.github.com/users/Kotelevets/events{/privacy}","received_events_url":"https://api.github.com/users/Kotelevets/received_events","type":"User","site_admin":false},"body":"\n\n---\n:mortar_board: [Создание схемы БД личного проекта](https://up.htmlacademy.ru/php/5/user/45449/tasks/9)","created_at":"2018-05-07T21:37:08Z","updated_at":"2018-05-08T08:01:43Z","closed_at":null,"merged_at":null,"merge_commit_sha":"cb7b3b1ff5200311fad36688ce5df9912cb5ab2c","assignee":{"login":"denlapaev","id":3096564,"avatar_url":"https://avatars0.githubusercontent.com/u/3096564?v=4","gravatar_id":"","url":"https://api.github.com/users/denlapaev","html_url":"https://github.com/denlapaev","followers_url":"https://api.github.com/users/denlapaev/followers","following_url":"https://api.github.com/users/denlapaev/following{/other_user}","gists_url":"https://api.github.com/users/denlapaev/gists{/gist_id}","starred_url":"https://api.github.com/users/denlapaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denlapaev/subscriptions","organizations_url":"https://api.github.com/users/denlapaev/orgs","repos_url":"https://api.github.com/users/denlapaev/repos","events_url":"https://api.github.com/users/denlapaev/events{/privacy}","received_events_url":"https://api.github.com/users/denlapaev/received_events","type":"User","site_admin":false},"assignees":[{"login":"denlapaev","id":3096564,"avatar_url":"https://avatars0.githubusercontent.com/u/3096564?v=4","gravatar_id":"","url":"https://api.github.com/users/denlapaev","html_url":"https://github.com/denlapaev","followers_url":"https://api.github.com/users/denlapaev/followers","following_url":"https://api.github.com/users/denlapaev/following{/other_user}","gists_url":"https://api.github.com/users/denlapaev/gists{/gist_id}","starred_url":"https://api.github.com/users/denlapaev/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/denlapaev/subscriptions","organizations_url":"https://api.github.com/users/denlapaev/orgs","repos_url":"https://api.github.com/users/denlapaev/repos","events_url":"https://api.github.com/users/denlapaev/events{/privacy}","received_events_url":"https://api.github.com/users/denlapaev/received_events","type":"User","site_admin":false}],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7/commits","review_comments_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7/comments","review_comment_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/comments{/number}","comments_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/7/comments","statuses_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/statuses/e85d18bc2d81728fe793c35a86eb90aaf2cacf01","head":{"label":"Kotelevets:module4-task1","ref":"module4-task1","sha":"e85d18bc2d81728fe793c35a86eb90aaf2cacf01","user":{"login":"Kotelevets","id":38089141,"avatar_url":"https://avatars0.githubusercontent.com/u/38089141?v=4","gravatar_id":"","url":"https://api.github.com/users/Kotelevets","html_url":"https://github.com/Kotelevets","followers_url":"https://api.github.com/users/Kotelevets/followers","following_url":"https://api.github.com/users/Kotelevets/following{/other_user}","gists_url":"https://api.github.com/users/Kotelevets/gists{/gist_id}","starred_url":"https://api.github.com/users/Kotelevets/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kotelevets/subscriptions","organizations_url":"https://api.github.com/users/Kotelevets/orgs","repos_url":"https://api.github.com/users/Kotelevets/repos","events_url":"https://api.github.com/users/Kotelevets/events{/privacy}","received_events_url":"https://api.github.com/users/Kotelevets/received_events","type":"User","site_admin":false},"repo":{"id":130911348,"name":"45449-doingsdone","full_name":"Kotelevets/45449-doingsdone","owner":{"login":"Kotelevets","id":38089141,"avatar_url":"https://avatars0.githubusercontent.com/u/38089141?v=4","gravatar_id":"","url":"https://api.github.com/users/Kotelevets","html_url":"https://github.com/Kotelevets","followers_url":"https://api.github.com/users/Kotelevets/followers","following_url":"https://api.github.com/users/Kotelevets/following{/other_user}","gists_url":"https://api.github.com/users/Kotelevets/gists{/gist_id}","starred_url":"https://api.github.com/users/Kotelevets/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Kotelevets/subscriptions","organizations_url":"https://api.github.com/users/Kotelevets/orgs","repos_url":"https://api.github.com/users/Kotelevets/repos","events_url":"https://api.github.com/users/Kotelevets/events{/privacy}","received_events_url":"https://api.github.com/users/Kotelevets/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/Kotelevets/45449-doingsdone","description":"Александр Котелевец","fork":true,"url":"https://api.github.com/repos/Kotelevets/45449-doingsdone","forks_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/forks","keys_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/keys{/key_id}","collaborators_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/teams","hooks_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/hooks","issue_events_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/issues/events{/number}","events_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/events","assignees_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/assignees{/user}","branches_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/branches{/branch}","tags_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/tags","blobs_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/git/refs{/sha}","trees_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/git/trees{/sha}","statuses_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/statuses/{sha}","languages_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/languages","stargazers_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/stargazers","contributors_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/contributors","subscribers_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/subscribers","subscription_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/subscription","commits_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/commits{/sha}","git_commits_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/git/commits{/sha}","comments_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/comments{/number}","issue_comment_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/issues/comments{/number}","contents_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/contents/{+path}","compare_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/compare/{base}...{head}","merges_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/merges","archive_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/downloads","issues_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/issues{/number}","pulls_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/pulls{/number}","milestones_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/milestones{/number}","notifications_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/labels{/name}","releases_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/releases{/id}","deployments_url":"https://api.github.com/repos/Kotelevets/45449-doingsdone/deployments","created_at":"2018-04-24T20:41:17Z","updated_at":"2018-05-07T20:54:23Z","pushed_at":"2018-05-07T21:36:14Z","git_url":"git://github.com/Kotelevets/45449-doingsdone.git","ssh_url":"git@github.com:Kotelevets/45449-doingsdone.git","clone_url":"https://github.com/Kotelevets/45449-doingsdone.git","svn_url":"https://github.com/Kotelevets/45449-doingsdone","homepage":null,"size":188,"stargazers_count":0,"watchers_count":0,"language":"HTML","has_issues":false,"has_projects":true,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"htmlacademy-php:master","ref":"master","sha":"edd56e679b5c6cd89af569a3a9db6a9734881b82","user":{"login":"htmlacademy-php","id":27206120,"avatar_url":"https://avatars1.githubusercontent.com/u/27206120?v=4","gravatar_id":"","url":"https://api.github.com/users/htmlacademy-php","html_url":"https://github.com/htmlacademy-php","followers_url":"https://api.github.com/users/htmlacademy-php/followers","following_url":"https://api.github.com/users/htmlacademy-php/following{/other_user}","gists_url":"https://api.github.com/users/htmlacademy-php/gists{/gist_id}","starred_url":"https://api.github.com/users/htmlacademy-php/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/htmlacademy-php/subscriptions","organizations_url":"https://api.github.com/users/htmlacademy-php/orgs","repos_url":"https://api.github.com/users/htmlacademy-php/repos","events_url":"https://api.github.com/users/htmlacademy-php/events{/privacy}","received_events_url":"https://api.github.com/users/htmlacademy-php/received_events","type":"Organization","site_admin":false},"repo":{"id":130900564,"name":"45449-doingsdone","full_name":"htmlacademy-php/45449-doingsdone","owner":{"login":"htmlacademy-php","id":27206120,"avatar_url":"https://avatars1.githubusercontent.com/u/27206120?v=4","gravatar_id":"","url":"https://api.github.com/users/htmlacademy-php","html_url":"https://github.com/htmlacademy-php","followers_url":"https://api.github.com/users/htmlacademy-php/followers","following_url":"https://api.github.com/users/htmlacademy-php/following{/other_user}","gists_url":"https://api.github.com/users/htmlacademy-php/gists{/gist_id}","starred_url":"https://api.github.com/users/htmlacademy-php/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/htmlacademy-php/subscriptions","organizations_url":"https://api.github.com/users/htmlacademy-php/orgs","repos_url":"https://api.github.com/users/htmlacademy-php/repos","events_url":"https://api.github.com/users/htmlacademy-php/events{/privacy}","received_events_url":"https://api.github.com/users/htmlacademy-php/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/htmlacademy-php/45449-doingsdone","description":"Александр Котелевец","fork":false,"url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone","forks_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/forks","keys_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/keys{/key_id}","collaborators_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/teams","hooks_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/hooks","issue_events_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/events{/number}","events_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/events","assignees_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/assignees{/user}","branches_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/branches{/branch}","tags_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/tags","blobs_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/git/refs{/sha}","trees_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/git/trees{/sha}","statuses_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/statuses/{sha}","languages_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/languages","stargazers_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/stargazers","contributors_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/contributors","subscribers_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/subscribers","subscription_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/subscription","commits_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/commits{/sha}","git_commits_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/git/commits{/sha}","comments_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/comments{/number}","issue_comment_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/comments{/number}","contents_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/contents/{+path}","compare_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/compare/{base}...{head}","merges_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/merges","archive_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/downloads","issues_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues{/number}","pulls_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls{/number}","milestones_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/milestones{/number}","notifications_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/labels{/name}","releases_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/releases{/id}","deployments_url":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/deployments","created_at":"2018-04-24T18:55:30Z","updated_at":"2018-05-07T20:03:37Z","pushed_at":"2018-05-07T21:37:08Z","git_url":"git://github.com/htmlacademy-php/45449-doingsdone.git","ssh_url":"git@github.com:htmlacademy-php/45449-doingsdone.git","clone_url":"https://github.com/htmlacademy-php/45449-doingsdone.git","svn_url":"https://github.com/htmlacademy-php/45449-doingsdone","homepage":"https://github.com/Kotelevets/45449-doingsdone","size":188,"stargazers_count":0,"watchers_count":0,"language":"HTML","has_issues":false,"has_projects":true,"has_downloads":false,"has_wiki":false,"has_pages":false,"forks_count":1,"mirror_url":null,"archived":false,"open_issues_count":1,"license":null,"forks":1,"open_issues":1,"watchers":0,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7"},"html":{"href":"https://github.com/htmlacademy-php/45449-doingsdone/pull/7"},"issue":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/7"},"comments":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/issues/7/comments"},"review_comments":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7/comments"},"review_comment":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/pulls/7/commits"},"statuses":{"href":"https://api.github.com/repos/htmlacademy-php/45449-doingsdone/statuses/e85d18bc2d81728fe793c35a86eb90aaf2cacf01"}},"author_association":"CONTRIBUTOR"}}
{"actor":{"display_login":"denlapaev"}}