summaryrefslogtreecommitdiff
path: root/db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb')
-rw-r--r--db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb6
1 files changed, 6 insertions, 0 deletions
diff --git a/db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb b/db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb
new file mode 100644
index 00000000000..01d7b3f6773
--- /dev/null
+++ b/db/migrate/20151002122943_migrate_ref_and_tag_to_build.rb
@@ -0,0 +1,6 @@
+class MigrateRefAndTagToBuild < ActiveRecord::Migration
+ def change
+ execute('UPDATE ci_builds SET ref=(SELECT ref FROM ci_commits WHERE ci_commits.id = ci_builds.commit_id) WHERE ref IS NULL')
+ execute('UPDATE ci_builds SET tag=(SELECT tag FROM ci_commits WHERE ci_commits.id = ci_builds.commit_id) WHERE tag IS NULL')
+ end
+end