summaryrefslogtreecommitdiff
path: root/db/post_migrate/20191204114127_delete_legacy_triggers.rb
diff options
context:
space:
mode:
authorGitLab Bot <gitlab-bot@gitlab.com>2020-01-14 12:07:41 +0000
committerGitLab Bot <gitlab-bot@gitlab.com>2020-01-14 12:07:41 +0000
commit4ce0bee95df15c05cdb0d777eba31fe753bc443b (patch)
tree3dc6a1aae7e0a01280f6d9f7d774dd369f7863e1 /db/post_migrate/20191204114127_delete_legacy_triggers.rb
parent02ab65d49fc94be7c91e511899762236c122977d (diff)
downloadgitlab-ce-4ce0bee95df15c05cdb0d777eba31fe753bc443b.tar.gz
Add latest changes from gitlab-org/gitlab@master
Diffstat (limited to 'db/post_migrate/20191204114127_delete_legacy_triggers.rb')
-rw-r--r--db/post_migrate/20191204114127_delete_legacy_triggers.rb17
1 files changed, 17 insertions, 0 deletions
diff --git a/db/post_migrate/20191204114127_delete_legacy_triggers.rb b/db/post_migrate/20191204114127_delete_legacy_triggers.rb
new file mode 100644
index 00000000000..82d901ae689
--- /dev/null
+++ b/db/post_migrate/20191204114127_delete_legacy_triggers.rb
@@ -0,0 +1,17 @@
+# frozen_string_literal: true
+
+class DeleteLegacyTriggers < ActiveRecord::Migration[5.2]
+ DOWNTIME = false
+
+ def up
+ execute <<~SQL
+ DELETE FROM ci_triggers WHERE owner_id IS NULL
+ SQL
+
+ change_column_null :ci_triggers, :owner_id, false
+ end
+
+ def down
+ change_column_null :ci_triggers, :owner_id, true
+ end
+end