/db/post_migrate/20170425130047_drop_ci_trigger_schedules_table.rb

https://gitlab.com/visay/gitlab-ce · Ruby · 33 lines · 26 code · 6 blank · 1 comment · 0 complexity · 7c0e26837bb65a5bad8352595dee25a1 MD5 · raw file

  1. # rubocop:disable Migration/Datetime
  2. class DropCiTriggerSchedulesTable < ActiveRecord::Migration
  3. include Gitlab::Database::MigrationHelpers
  4. DOWNTIME = false
  5. disable_ddl_transaction!
  6. def up
  7. drop_table :ci_trigger_schedules
  8. end
  9. def down
  10. create_table "ci_trigger_schedules", force: :cascade do |t|
  11. t.integer "project_id"
  12. t.integer "trigger_id", null: false
  13. t.datetime "deleted_at"
  14. t.datetime "created_at"
  15. t.datetime "updated_at"
  16. t.string "cron"
  17. t.string "cron_timezone"
  18. t.datetime "next_run_at"
  19. t.string "ref"
  20. t.boolean "active"
  21. end
  22. add_index "ci_trigger_schedules", %w(active next_run_at), name: "index_ci_trigger_schedules_on_active_and_next_run_at", using: :btree
  23. add_index "ci_trigger_schedules", ["project_id"], name: "index_ci_trigger_schedules_on_project_id", using: :btree
  24. add_index "ci_trigger_schedules", ["next_run_at"], name: "index_ci_trigger_schedules_on_next_run_at"
  25. add_concurrent_foreign_key "ci_trigger_schedules", "ci_triggers", column: :trigger_id, on_delete: :cascade
  26. end
  27. end