summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
authorBrett Walker <bwalker@gitlab.com>2019-07-09 17:34:44 -0500
committerBrett Walker <bwalker@gitlab.com>2019-07-22 10:48:46 -0500
commitb0eafaaca10ce291490ee8b69cae0ce7592c1694 (patch)
treeec8e0534c49c13c8fad958fcbe5f4e9d5496c3ce /db/schema.rb
parent8073b0554fc8f7dddc250025aaf5cedd09f423cb (diff)
downloadgitlab-ce-b0eafaaca10ce291490ee8b69cae0ce7592c1694.tar.gz
Add index for issues on relative position, projectbw-add-index-for-relative-position
and state
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb1
1 files changed, 1 insertions, 0 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 79cd1a3a797..681353121db 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -1682,6 +1682,7 @@ ActiveRecord::Schema.define(version: 2019_07_15_114644) do
t.index ["project_id", "created_at", "id", "state"], name: "index_issues_on_project_id_and_created_at_and_id_and_state", using: :btree
t.index ["project_id", "due_date", "id", "state"], name: "idx_issues_on_project_id_and_due_date_and_id_and_state_partial", where: "(due_date IS NOT NULL)", using: :btree
t.index ["project_id", "iid"], name: "index_issues_on_project_id_and_iid", unique: true, using: :btree
+ t.index ["project_id", "state", "relative_position", "id"], name: "index_issues_on_project_id_and_state_and_rel_position_and_id", order: { id: :desc }, using: :btree
t.index ["project_id", "updated_at", "id", "state"], name: "index_issues_on_project_id_and_updated_at_and_id_and_state", using: :btree
t.index ["relative_position"], name: "index_issues_on_relative_position", using: :btree
t.index ["state"], name: "index_issues_on_state", using: :btree