Add foreign key to pipeline schedules

This wasn't added in the commit before this one, as this wouldn't fit in
a `#change` method, as it seems the `add_concurrent_X` methods aren't
auto reversable.

2 files changed, 21 insertions, 1 deletions

diff --git a/db/migrate/20170420085345_add_foreign_key_to_pipeline_schedule.rb b/db/migrate/20170420085345_add_foreign_key_to_pipeline_schedule.rb
new file mode 100644
index 00000000000..4b326b2f250
--- /dev/null
+++ b/db/migrate/20170420085345_add_foreign_key_to_pipeline_schedule.rb
@@ -0,0 +1,18 @@
+# See http://doc.gitlab.com/ce/development/migration_style_guide.html
+# for more information on how to write migrations for GitLab.
+
+class AddForeignKeyToPipelineSchedule < ActiveRecord::Migration
+  include Gitlab::Database::MigrationHelpers
+
+  DOWNTIME = false
+
+  disable_ddl_transaction!
+
+  def up
+    add_concurrent_foreign_key(:ci_pipeline_schedules, :ci_triggers, column: :trigger_id)
+  end
+
+  def down
+    remove_foreign_key(:ci_pipeline_schedules, column: :trigger_id)
+  end
+end
diff --git a/db/schema.rb b/db/schema.rb
index 764eff0d796..6b792966f1f 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -11,7 +11,7 @@
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 20170418103908) do
+ActiveRecord::Schema.define(version: 20170420085345) do
 
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
@@ -240,6 +240,7 @@ ActiveRecord::Schema.define(version: 20170418103908) do
 
   create_table "ci_pipeline_schedules", force: :cascade do |t|
     t.integer "project_id"
+    t.integer "trigger_id", null: false
     t.datetime "deleted_at"
     t.datetime "created_at"
     t.datetime "updated_at"
@@ -1375,6 +1376,7 @@ ActiveRecord::Schema.define(version: 20170418103908) do
   add_foreign_key "boards", "projects"
   add_foreign_key "chat_teams", "namespaces", on_delete: :cascade
   add_foreign_key "ci_builds", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_a2141b1522", on_delete: :nullify
+  add_foreign_key "ci_pipeline_schedules", "ci_triggers", column: "trigger_id", name: "fk_f786baca2c", on_delete: :cascade
   add_foreign_key "ci_pipelines", "ci_pipelines", column: "auto_canceled_by_id", name: "fk_262d4c2d19", on_delete: :nullify
   add_foreign_key "ci_trigger_requests", "ci_triggers", column: "trigger_id", name: "fk_b8ec8b7245", on_delete: :cascade
   add_foreign_key "ci_trigger_schedules", "ci_triggers", column: "trigger_id", name: "fk_90a406cc94", on_delete: :cascade