summaryrefslogtreecommitdiff
path: root/db/migrate/20160528043124_add_users_state_index.rb
diff options
context:
space:
mode:
authorStan Hu <stanhu@gmail.com>2016-05-28 03:05:34 -0700
committerStan Hu <stanhu@gmail.com>2016-05-29 23:03:08 -0700
commit9485b65abb4efaec1f8369d66e289ad882341330 (patch)
treeaf33149a0815bfb5753e913f8dfe168e10935133 /db/migrate/20160528043124_add_users_state_index.rb
parent43c35b0f20fb3bb67ea2b96bf8f806c7e95b6aec (diff)
downloadgitlab-ce-9485b65abb4efaec1f8369d66e289ad882341330.tar.gz
Add DB index on users.state
Closes #17920
Diffstat (limited to 'db/migrate/20160528043124_add_users_state_index.rb')
-rw-r--r--db/migrate/20160528043124_add_users_state_index.rb9
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrate/20160528043124_add_users_state_index.rb b/db/migrate/20160528043124_add_users_state_index.rb
new file mode 100644
index 00000000000..e77a5460737
--- /dev/null
+++ b/db/migrate/20160528043124_add_users_state_index.rb
@@ -0,0 +1,9 @@
+class AddUsersStateIndex < ActiveRecord::Migration
+ include Gitlab::Database::MigrationHelpers
+
+ disable_ddl_transaction!
+
+ def change
+ add_concurrent_index :users, :state
+ end
+end