summaryrefslogtreecommitdiff
path: root/db/migrate/20170404163427_add_trigger_id_foreign_key.rb
diff options
context:
space:
mode:
authorShinya Maeda <gitlab.shinyamaeda@gmail.com>2017-04-05 01:54:45 +0900
committerShinya Maeda <gitlab.shinyamaeda@gmail.com>2017-04-06 23:46:59 +0900
commit4688eb47c6fe135fb9baad5a5d56b1dfa685cc7f (patch)
tree73ed8531a88ff7088ea419aa4518be02cd82f3ae /db/migrate/20170404163427_add_trigger_id_foreign_key.rb
parent1dbc888e3306f30ca0882aece86ccd1a817e0ab8 (diff)
downloadgitlab-ce-4688eb47c6fe135fb9baad5a5d56b1dfa685cc7f.tar.gz
Rename cron_time_zone to cron_timezone. Separate add_concurrent_foreign_key.
Diffstat (limited to 'db/migrate/20170404163427_add_trigger_id_foreign_key.rb')
-rw-r--r--db/migrate/20170404163427_add_trigger_id_foreign_key.rb15
1 files changed, 15 insertions, 0 deletions
diff --git a/db/migrate/20170404163427_add_trigger_id_foreign_key.rb b/db/migrate/20170404163427_add_trigger_id_foreign_key.rb
new file mode 100644
index 00000000000..6679a95ca11
--- /dev/null
+++ b/db/migrate/20170404163427_add_trigger_id_foreign_key.rb
@@ -0,0 +1,15 @@
+class AddTriggerIdForeignKey < ActiveRecord::Migration
+ include Gitlab::Database::MigrationHelpers
+
+ DOWNTIME = false
+
+ disable_ddl_transaction!
+
+ def up
+ add_concurrent_foreign_key :ci_trigger_schedules, :ci_triggers, column: :trigger_id, on_delete: :cascade
+ end
+
+ def down
+ remove_foreign_key :ci_trigger_schedules, column: :trigger_id
+ end
+end