diff options
author | Lin Jen-Shin <godfat@godfat.org> | 2017-05-02 22:14:20 +0800 |
---|---|---|
committer | Lin Jen-Shin <godfat@godfat.org> | 2017-05-02 15:51:21 +0000 |
commit | 739e797575d47ec796206865c4d82917cb2ad93d (patch) | |
tree | da26d3b9135d693cf1786ae8c5b675784d1833a9 /db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb | |
parent | 98ae016ab207a7f4e27d151584156af6011d48d5 (diff) | |
download | gitlab-ce-739e797575d47ec796206865c4d82917cb2ad93d.tar.gz |
Add indices for auto_canceled_by_id for PostgreSQL
Diffstat (limited to 'db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb')
-rw-r--r-- | db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb b/db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb new file mode 100644 index 00000000000..0a8d2c8ff61 --- /dev/null +++ b/db/migrate/20170502140503_create_index_ci_builds_auto_canceled_by_id.rb @@ -0,0 +1,21 @@ +class CreateIndexCiBuildsAutoCanceledById < ActiveRecord::Migration + include Gitlab::Database::MigrationHelpers + + DOWNTIME = false + + disable_ddl_transaction! + + def up + # MySQL would already have the index + unless index_exists?(:ci_builds, :auto_canceled_by_id) + add_concurrent_index(:ci_builds, :auto_canceled_by_id) + end + end + + def down + # We cannot remove index for MySQL because it's needed for foreign key + if Gitlab::Database.postgresql? + remove_concurrent_index(:ci_builds, :auto_canceled_by_id) + end + end +end |