summaryrefslogtreecommitdiff
path: root/db/schema.rb
diff options
context:
space:
mode:
authorShinya Maeda <shinya@gitlab.com>2018-12-06 16:05:26 +0900
committerShinya Maeda <shinya@gitlab.com>2018-12-06 16:05:26 +0900
commit0e8b9c4a1ecbd3e52ba379494872e019ec7edfe1 (patch)
tree2896994ff804e60089fdcaf6471a559ab4215158 /db/schema.rb
parentec2c268b5ea51a11ded3dc87b034cca81b5090c4 (diff)
downloadgitlab-ce-partial-index-for-merge_request_id.tar.gz
Change to partial indexpartial-index-for-merge_request_id
Diffstat (limited to 'db/schema.rb')
-rw-r--r--db/schema.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/schema.rb b/db/schema.rb
index 65a69c2850c..201b59ecd0a 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -476,7 +476,7 @@ ActiveRecord::Schema.define(version: 20181126153547) do
t.integer "iid"
t.integer "merge_request_id"
t.index ["auto_canceled_by_id"], name: "index_ci_pipelines_on_auto_canceled_by_id", using: :btree
- t.index ["merge_request_id"], name: "index_ci_pipelines_on_merge_request_id", using: :btree
+ t.index ["merge_request_id"], name: "index_ci_pipelines_on_merge_request_id", where: "(merge_request_id IS NOT NULL)", using: :btree
t.index ["pipeline_schedule_id"], name: "index_ci_pipelines_on_pipeline_schedule_id", using: :btree
t.index ["project_id", "iid"], name: "index_ci_pipelines_on_project_id_and_iid", unique: true, where: "(iid IS NOT NULL)", using: :btree
t.index ["project_id", "ref", "status", "id"], name: "index_ci_pipelines_on_project_id_and_ref_and_status_and_id", using: :btree