{"action":"created","comment":{"url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/comments/106682954","pull_request_review_id":27620488,"id":106682954,"diff_hunk":"@@ -878,26 +878,26 @@ CREATE TABLE `repositories` (\n   `db_project_id` int(11) NOT NULL,\n   `name` varchar(255) COLLATE utf8_bin NOT NULL,\n   `remote_project_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',\n-  `rebuild` enum('transitive','direct','local') CHARACTER SET utf8 DEFAULT NULL,\n-  `block` enum('all','local','never') CHARACTER SET utf8 DEFAULT NULL,\n-  `linkedbuild` enum('off','localdep','all') CHARACTER SET utf8 DEFAULT NULL,\n+  `rebuild` varchar(10) CHARACTER SET utf8 DEFAULT NULL,\n+  `block` varchar(5) CHARACTER SET utf8 DEFAULT NULL,\n+  `linkedbuild` varchar(8) CHARACTER SET utf8 DEFAULT NULL,\n   `hostsystem_id` int(11) DEFAULT NULL,\n   PRIMARY KEY (`id`),\n-  UNIQUE KEY `projects_name_index` (`db_project_id`,`name`,`remote_project_name`),\n-  KEY `remote_project_name_index` (`remote_project_name`),\n-  KEY `hostsystem_id` (`hostsystem_id`),\n+  UNIQUE KEY `projects_name_index` (`db_project_id`,`name`,`remote_project_name`) USING BTREE,\n+  KEY `hostsystem_id` (`hostsystem_id`) USING BTREE,\n+  KEY `remote_project_name_index` (`remote_project_name`) USING BTREE,\n   CONSTRAINT `repositories_ibfk_1` FOREIGN KEY (`db_project_id`) REFERENCES `projects` (`id`),\n   CONSTRAINT `repositories_ibfk_2` FOREIGN KEY (`hostsystem_id`) REFERENCES `repositories` (`id`)\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;\n \n CREATE TABLE `repository_architectures` (\n+  `id` int(11) NOT NULL AUTO_INCREMENT,","path":"src/api/db/structure.sql","position":544,"original_position":544,"commit_id":"6173de39a285abbbe05a5c551af7e223c03d39b9","original_commit_id":"6173de39a285abbbe05a5c551af7e223c03d39b9","user":{"login":"evanrolfe","id":9274,"avatar_url":"https://avatars0.githubusercontent.com/u/9274?v=3","gravatar_id":"","url":"https://api.github.com/users/evanrolfe","html_url":"https://github.com/evanrolfe","followers_url":"https://api.github.com/users/evanrolfe/followers","following_url":"https://api.github.com/users/evanrolfe/following{/other_user}","gists_url":"https://api.github.com/users/evanrolfe/gists{/gist_id}","starred_url":"https://api.github.com/users/evanrolfe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evanrolfe/subscriptions","organizations_url":"https://api.github.com/users/evanrolfe/orgs","repos_url":"https://api.github.com/users/evanrolfe/repos","events_url":"https://api.github.com/users/evanrolfe/events{/privacy}","received_events_url":"https://api.github.com/users/evanrolfe/received_events","type":"User","site_admin":false},"body":"Non-trivial difference, needs to be checked.","created_at":"2017-03-17T15:53:49Z","updated_at":"2017-03-17T15:56:37Z","html_url":"https://github.com/openSUSE/open-build-service/pull/2854#discussion_r106682954","pull_request_url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854","_links":{"self":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/comments/106682954"},"html":{"href":"https://github.com/openSUSE/open-build-service/pull/2854#discussion_r106682954"},"pull_request":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854"}}},"pull_request":{"url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854","id":111310339,"html_url":"https://github.com/openSUSE/open-build-service/pull/2854","diff_url":"https://github.com/openSUSE/open-build-service/pull/2854.diff","patch_url":"https://github.com/openSUSE/open-build-service/pull/2854.patch","issue_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2854","number":2854,"state":"open","locked":false,"title":"[prototype] Make migrations run sequentially","user":{"login":"evanrolfe","id":9274,"avatar_url":"https://avatars0.githubusercontent.com/u/9274?v=3","gravatar_id":"","url":"https://api.github.com/users/evanrolfe","html_url":"https://github.com/evanrolfe","followers_url":"https://api.github.com/users/evanrolfe/followers","following_url":"https://api.github.com/users/evanrolfe/following{/other_user}","gists_url":"https://api.github.com/users/evanrolfe/gists{/gist_id}","starred_url":"https://api.github.com/users/evanrolfe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evanrolfe/subscriptions","organizations_url":"https://api.github.com/users/evanrolfe/orgs","repos_url":"https://api.github.com/users/evanrolfe/repos","events_url":"https://api.github.com/users/evanrolfe/events{/privacy}","received_events_url":"https://api.github.com/users/evanrolfe/received_events","type":"User","site_admin":false},"body":"I'm just making this PR as a \"prototype\" - something to demonstrate thats its possible that we can have the migrations run sequentially in order to generate the entire database.\r\n\r\nAll i have done is replaced the first migration [001_initial_database.rb](https://github.com/opensuse/open-build-service/blob/master/src/api/db/migrate/001_initial_database.rb#L745) with the schema dump for the obs 2.5 database.\r\n\r\nAs you can see there are some differences between structure.sql in master and between what gets generated by running the migrations sequentially. Most of those are just adding `USING BTREE` to the indices however some of the differences are non-trivial and we will need to decide which is the correct way to go for these differences if we wish to merge this PR.","created_at":"2017-03-17T15:52:51Z","updated_at":"2017-03-17T15:56:37Z","closed_at":null,"merged_at":null,"merge_commit_sha":"2f39d00806961b73a84e68a03b5d032408753fde","assignee":null,"assignees":[],"milestone":null,"commits_url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854/commits","review_comments_url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854/comments","review_comment_url":"https://api.github.com/repos/openSUSE/open-build-service/pulls/comments{/number}","comments_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/2854/comments","statuses_url":"https://api.github.com/repos/openSUSE/open-build-service/statuses/6173de39a285abbbe05a5c551af7e223c03d39b9","head":{"label":"evanrolfe:feature/migrations_run_sequentially","ref":"feature/migrations_run_sequentially","sha":"6173de39a285abbbe05a5c551af7e223c03d39b9","user":{"login":"evanrolfe","id":9274,"avatar_url":"https://avatars0.githubusercontent.com/u/9274?v=3","gravatar_id":"","url":"https://api.github.com/users/evanrolfe","html_url":"https://github.com/evanrolfe","followers_url":"https://api.github.com/users/evanrolfe/followers","following_url":"https://api.github.com/users/evanrolfe/following{/other_user}","gists_url":"https://api.github.com/users/evanrolfe/gists{/gist_id}","starred_url":"https://api.github.com/users/evanrolfe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evanrolfe/subscriptions","organizations_url":"https://api.github.com/users/evanrolfe/orgs","repos_url":"https://api.github.com/users/evanrolfe/repos","events_url":"https://api.github.com/users/evanrolfe/events{/privacy}","received_events_url":"https://api.github.com/users/evanrolfe/received_events","type":"User","site_admin":false},"repo":{"id":76869212,"name":"open-build-service","full_name":"evanrolfe/open-build-service","owner":{"login":"evanrolfe","id":9274,"avatar_url":"https://avatars0.githubusercontent.com/u/9274?v=3","gravatar_id":"","url":"https://api.github.com/users/evanrolfe","html_url":"https://github.com/evanrolfe","followers_url":"https://api.github.com/users/evanrolfe/followers","following_url":"https://api.github.com/users/evanrolfe/following{/other_user}","gists_url":"https://api.github.com/users/evanrolfe/gists{/gist_id}","starred_url":"https://api.github.com/users/evanrolfe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/evanrolfe/subscriptions","organizations_url":"https://api.github.com/users/evanrolfe/orgs","repos_url":"https://api.github.com/users/evanrolfe/repos","events_url":"https://api.github.com/users/evanrolfe/events{/privacy}","received_events_url":"https://api.github.com/users/evanrolfe/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/evanrolfe/open-build-service","description":"A generic system to build and distribute packages from sources in an automatic, consistent and reproducible way. Release your software for a wide range of operating systems and hardware architectures.","fork":true,"url":"https://api.github.com/repos/evanrolfe/open-build-service","forks_url":"https://api.github.com/repos/evanrolfe/open-build-service/forks","keys_url":"https://api.github.com/repos/evanrolfe/open-build-service/keys{/key_id}","collaborators_url":"https://api.github.com/repos/evanrolfe/open-build-service/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/evanrolfe/open-build-service/teams","hooks_url":"https://api.github.com/repos/evanrolfe/open-build-service/hooks","issue_events_url":"https://api.github.com/repos/evanrolfe/open-build-service/issues/events{/number}","events_url":"https://api.github.com/repos/evanrolfe/open-build-service/events","assignees_url":"https://api.github.com/repos/evanrolfe/open-build-service/assignees{/user}","branches_url":"https://api.github.com/repos/evanrolfe/open-build-service/branches{/branch}","tags_url":"https://api.github.com/repos/evanrolfe/open-build-service/tags","blobs_url":"https://api.github.com/repos/evanrolfe/open-build-service/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/evanrolfe/open-build-service/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/evanrolfe/open-build-service/git/refs{/sha}","trees_url":"https://api.github.com/repos/evanrolfe/open-build-service/git/trees{/sha}","statuses_url":"https://api.github.com/repos/evanrolfe/open-build-service/statuses/{sha}","languages_url":"https://api.github.com/repos/evanrolfe/open-build-service/languages","stargazers_url":"https://api.github.com/repos/evanrolfe/open-build-service/stargazers","contributors_url":"https://api.github.com/repos/evanrolfe/open-build-service/contributors","subscribers_url":"https://api.github.com/repos/evanrolfe/open-build-service/subscribers","subscription_url":"https://api.github.com/repos/evanrolfe/open-build-service/subscription","commits_url":"https://api.github.com/repos/evanrolfe/open-build-service/commits{/sha}","git_commits_url":"https://api.github.com/repos/evanrolfe/open-build-service/git/commits{/sha}","comments_url":"https://api.github.com/repos/evanrolfe/open-build-service/comments{/number}","issue_comment_url":"https://api.github.com/repos/evanrolfe/open-build-service/issues/comments{/number}","contents_url":"https://api.github.com/repos/evanrolfe/open-build-service/contents/{+path}","compare_url":"https://api.github.com/repos/evanrolfe/open-build-service/compare/{base}...{head}","merges_url":"https://api.github.com/repos/evanrolfe/open-build-service/merges","archive_url":"https://api.github.com/repos/evanrolfe/open-build-service/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/evanrolfe/open-build-service/downloads","issues_url":"https://api.github.com/repos/evanrolfe/open-build-service/issues{/number}","pulls_url":"https://api.github.com/repos/evanrolfe/open-build-service/pulls{/number}","milestones_url":"https://api.github.com/repos/evanrolfe/open-build-service/milestones{/number}","notifications_url":"https://api.github.com/repos/evanrolfe/open-build-service/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/evanrolfe/open-build-service/labels{/name}","releases_url":"https://api.github.com/repos/evanrolfe/open-build-service/releases{/id}","deployments_url":"https://api.github.com/repos/evanrolfe/open-build-service/deployments","created_at":"2016-12-19T14:32:08Z","updated_at":"2016-12-19T14:32:14Z","pushed_at":"2017-03-17T15:47:09Z","git_url":"git://github.com/evanrolfe/open-build-service.git","ssh_url":"git@github.com:evanrolfe/open-build-service.git","clone_url":"https://github.com/evanrolfe/open-build-service.git","svn_url":"https://github.com/evanrolfe/open-build-service","homepage":"http://openbuildservice.org/","size":49123,"stargazers_count":0,"watchers_count":0,"language":"Ruby","has_issues":false,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"openSUSE:master","ref":"master","sha":"ca026f81b20709156ead8e3859fab66259bac38a","user":{"login":"openSUSE","id":623819,"avatar_url":"https://avatars1.githubusercontent.com/u/623819?v=3","gravatar_id":"","url":"https://api.github.com/users/openSUSE","html_url":"https://github.com/openSUSE","followers_url":"https://api.github.com/users/openSUSE/followers","following_url":"https://api.github.com/users/openSUSE/following{/other_user}","gists_url":"https://api.github.com/users/openSUSE/gists{/gist_id}","starred_url":"https://api.github.com/users/openSUSE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openSUSE/subscriptions","organizations_url":"https://api.github.com/users/openSUSE/orgs","repos_url":"https://api.github.com/users/openSUSE/repos","events_url":"https://api.github.com/users/openSUSE/events{/privacy}","received_events_url":"https://api.github.com/users/openSUSE/received_events","type":"Organization","site_admin":false},"repo":{"id":2046192,"name":"open-build-service","full_name":"openSUSE/open-build-service","owner":{"login":"openSUSE","id":623819,"avatar_url":"https://avatars1.githubusercontent.com/u/623819?v=3","gravatar_id":"","url":"https://api.github.com/users/openSUSE","html_url":"https://github.com/openSUSE","followers_url":"https://api.github.com/users/openSUSE/followers","following_url":"https://api.github.com/users/openSUSE/following{/other_user}","gists_url":"https://api.github.com/users/openSUSE/gists{/gist_id}","starred_url":"https://api.github.com/users/openSUSE/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openSUSE/subscriptions","organizations_url":"https://api.github.com/users/openSUSE/orgs","repos_url":"https://api.github.com/users/openSUSE/repos","events_url":"https://api.github.com/users/openSUSE/events{/privacy}","received_events_url":"https://api.github.com/users/openSUSE/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/openSUSE/open-build-service","description":"A generic system to build and distribute packages from sources in an automatic, consistent and reproducible way. Release your software for a wide range of operating systems and hardware architectures.","fork":false,"url":"https://api.github.com/repos/openSUSE/open-build-service","forks_url":"https://api.github.com/repos/openSUSE/open-build-service/forks","keys_url":"https://api.github.com/repos/openSUSE/open-build-service/keys{/key_id}","collaborators_url":"https://api.github.com/repos/openSUSE/open-build-service/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/openSUSE/open-build-service/teams","hooks_url":"https://api.github.com/repos/openSUSE/open-build-service/hooks","issue_events_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/events{/number}","events_url":"https://api.github.com/repos/openSUSE/open-build-service/events","assignees_url":"https://api.github.com/repos/openSUSE/open-build-service/assignees{/user}","branches_url":"https://api.github.com/repos/openSUSE/open-build-service/branches{/branch}","tags_url":"https://api.github.com/repos/openSUSE/open-build-service/tags","blobs_url":"https://api.github.com/repos/openSUSE/open-build-service/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/openSUSE/open-build-service/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/openSUSE/open-build-service/git/refs{/sha}","trees_url":"https://api.github.com/repos/openSUSE/open-build-service/git/trees{/sha}","statuses_url":"https://api.github.com/repos/openSUSE/open-build-service/statuses/{sha}","languages_url":"https://api.github.com/repos/openSUSE/open-build-service/languages","stargazers_url":"https://api.github.com/repos/openSUSE/open-build-service/stargazers","contributors_url":"https://api.github.com/repos/openSUSE/open-build-service/contributors","subscribers_url":"https://api.github.com/repos/openSUSE/open-build-service/subscribers","subscription_url":"https://api.github.com/repos/openSUSE/open-build-service/subscription","commits_url":"https://api.github.com/repos/openSUSE/open-build-service/commits{/sha}","git_commits_url":"https://api.github.com/repos/openSUSE/open-build-service/git/commits{/sha}","comments_url":"https://api.github.com/repos/openSUSE/open-build-service/comments{/number}","issue_comment_url":"https://api.github.com/repos/openSUSE/open-build-service/issues/comments{/number}","contents_url":"https://api.github.com/repos/openSUSE/open-build-service/contents/{+path}","compare_url":"https://api.github.com/repos/openSUSE/open-build-service/compare/{base}...{head}","merges_url":"https://api.github.com/repos/openSUSE/open-build-service/merges","archive_url":"https://api.github.com/repos/openSUSE/open-build-service/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/openSUSE/open-build-service/downloads","issues_url":"https://api.github.com/repos/openSUSE/open-build-service/issues{/number}","pulls_url":"https://api.github.com/repos/openSUSE/open-build-service/pulls{/number}","milestones_url":"https://api.github.com/repos/openSUSE/open-build-service/milestones{/number}","notifications_url":"https://api.github.com/repos/openSUSE/open-build-service/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/openSUSE/open-build-service/labels{/name}","releases_url":"https://api.github.com/repos/openSUSE/open-build-service/releases{/id}","deployments_url":"https://api.github.com/repos/openSUSE/open-build-service/deployments","created_at":"2011-07-14T06:52:57Z","updated_at":"2017-03-17T14:07:21Z","pushed_at":"2017-03-17T15:52:52Z","git_url":"git://github.com/openSUSE/open-build-service.git","ssh_url":"git@github.com:openSUSE/open-build-service.git","clone_url":"https://github.com/openSUSE/open-build-service.git","svn_url":"https://github.com/openSUSE/open-build-service","homepage":"http://openbuildservice.org/","size":49045,"stargazers_count":253,"watchers_count":253,"language":"Ruby","has_issues":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":185,"mirror_url":null,"open_issues_count":331,"forks":185,"open_issues":331,"watchers":253,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854"},"html":{"href":"https://github.com/openSUSE/open-build-service/pull/2854"},"issue":{"href":"https://api.github.com/repos/openSUSE/open-build-service/issues/2854"},"comments":{"href":"https://api.github.com/repos/openSUSE/open-build-service/issues/2854/comments"},"review_comments":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854/comments"},"review_comment":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/openSUSE/open-build-service/pulls/2854/commits"},"statuses":{"href":"https://api.github.com/repos/openSUSE/open-build-service/statuses/6173de39a285abbbe05a5c551af7e223c03d39b9"}}}}
{"actor":{"display_login":"evanrolfe"}}