summaryrefslogtreecommitdiff
path: root/db/migrate/20190703001120_default_milestone_to_nil.rb
diff options
context:
space:
mode:
authorSimon Knox <psimyn@gmail.com>2019-08-06 15:07:18 +1000
committerSimon Knox <psimyn@gmail.com>2019-08-06 15:07:18 +1000
commitfc77b9df8b6a49c86e9c1eb949f1b1162470d2ee (patch)
tree96aad0a31543fa520626dc1c5efabff1367a0bab /db/migrate/20190703001120_default_milestone_to_nil.rb
parent9c71bf3e6df2dcb20ea19df21a127823bbe5e615 (diff)
parentfa216b0e86433192ba4e39a05f42217fb4685173 (diff)
downloadgitlab-ce-alerts-dropdown-to-modal-part-2-ce.tar.gz
Merge branch 'master' of gitlab.com:gitlab-org/gitlab-ce into alerts-dropdown-to-modal-part-2-cealerts-dropdown-to-modal-part-2-ce
Diffstat (limited to 'db/migrate/20190703001120_default_milestone_to_nil.rb')
-rw-r--r--db/migrate/20190703001120_default_milestone_to_nil.rb24
1 files changed, 24 insertions, 0 deletions
diff --git a/db/migrate/20190703001120_default_milestone_to_nil.rb b/db/migrate/20190703001120_default_milestone_to_nil.rb
new file mode 100644
index 00000000000..6a1c3603d9d
--- /dev/null
+++ b/db/migrate/20190703001120_default_milestone_to_nil.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class DefaultMilestoneToNil < ActiveRecord::Migration[5.1]
+ DOWNTIME = false
+
+ def up
+ execute(update_board_milestones_query)
+ end
+
+ def down
+ # no-op
+ end
+
+ private
+
+ # Only 105 records to update, as of 2019/07/18
+ def update_board_milestones_query
+ <<~HEREDOC
+ UPDATE boards
+ SET milestone_id = NULL
+ WHERE boards.milestone_id = -1
+ HEREDOC
+ end
+end