summaryrefslogtreecommitdiff
path: root/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb
diff options
context:
space:
mode:
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.rb10
1 files changed, 10 insertions, 0 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
new file mode 100644
index 00000000000..cd449806717
--- /dev/null
+++ b/db/migrate/20150924125436_migrate_project_id_for_ci_commits.rb
@@ -0,0 +1,10 @@
+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"
+ )
+ end
+end