diff options
| author | Andreas Brandl <abrandl@gitlab.com> | 2018-03-20 23:39:17 +0300 |
|---|---|---|
| committer | Andreas Brandl <abrandl@gitlab.com> | 2018-03-21 15:41:24 +0300 |
| commit | 5f8abe4783a252c5979d87572ceaeb37b11d59dc (patch) | |
| tree | 3dbb3b9468a9b7538a72c18d0147abdb45a006e4 | |
| parent | c0bfe9db5f90ee7f07c371af8e23744b60e04815 (diff) | |
Flip column order in new index.
| -rw-r--r-- | db/migrate/20180320182229_add_indexes_for_user_activity_queries.rb | 4 | ||||
| -rw-r--r-- | db/schema.rb | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/db/migrate/20180320182229_add_indexes_for_user_activity_queries.rb b/db/migrate/20180320182229_add_indexes_for_user_activity_queries.rb index 4baf8146b64..ba2dd7c8cf8 100644 --- a/db/migrate/20180320182229_add_indexes_for_user_activity_queries.rb +++ b/db/migrate/20180320182229_add_indexes_for_user_activity_queries.rb @@ -6,12 +6,12 @@ class AddIndexesForUserActivityQueries < ActiveRecord::Migration disable_ddl_transaction! def up - add_concurrent_index :events, [:project_id, :author_id] + add_concurrent_index :events, [:author_id, :project_id] add_concurrent_index :user_interacted_projects, :user_id end def down - remove_concurrent_index :events, [:project_id, :author_id] + remove_concurrent_index :events, [:author_id, :project_id] patch_foreign_keys do remove_concurrent_index :user_interacted_projects, :user_id diff --git a/db/schema.rb b/db/schema.rb index 6024fc24b0b..e441ca2a1f0 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -727,8 +727,8 @@ ActiveRecord::Schema.define(version: 20180320182229) do end add_index "events", ["action"], name: "index_events_on_action", using: :btree + add_index "events", ["author_id", "project_id"], name: "index_events_on_author_id_and_project_id", using: :btree add_index "events", ["author_id"], name: "index_events_on_author_id", using: :btree - add_index "events", ["project_id", "author_id"], name: "index_events_on_project_id_and_author_id", using: :btree add_index "events", ["project_id", "id"], name: "index_events_on_project_id_and_id", using: :btree add_index "events", ["target_type", "target_id"], name: "index_events_on_target_type_and_target_id", using: :btree |