diff options
| author | Kamil Trzcinski <ayufan@ayufan.eu> | 2015-09-28 16:49:40 +0200 |
|---|---|---|
| committer | Kamil Trzcinski <ayufan@ayufan.eu> | 2015-09-29 10:47:04 +0200 |
| commit | 9498a40052603a0687a0fa6370e50e97bc078301 (patch) | |
| tree | 2e026ade9c435531dc92db40480d1a7db312132c /db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb | |
| parent | 0f3deac362cf2800ceaf17f4cded765f6c9d577c (diff) | |
| download | gitlab-ce-9498a40052603a0687a0fa6370e50e97bc078301.tar.gz | |
Fix migrations
Diffstat (limited to 'db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb')
| -rw-r--r-- | db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb | 8 |
1 files changed, 2 insertions, 6 deletions
diff --git a/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb b/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb index cd449806717..2be57b6062e 100644 --- a/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb +++ b/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb @@ -1,10 +1,6 @@ class MigrateProjectIdForCiCommits < ActiveRecord::Migration def up - execute( - "UPDATE ci_commits " + - "JOIN ci_projects ON ci_projects.id = ci_commits.project_id " + - "SET gl_project_id=ci_projects.gitlab_id " + - "WHERE gl_project_id IS NULL" - ) + subquery = 'SELECT gitlab_id FROM ci_projects WHERE ci_projects.id = ci_commits.project_id' + execute("UPDATE ci_commits SET gl_project_id=(#{subquery}) WHERE gl_project_id IS NULL") end end |