diff options
| author | Douwe Maan <douwe@gitlab.com> | 2016-02-09 16:12:58 +0000 |
|---|---|---|
| committer | Douwe Maan <douwe@gitlab.com> | 2016-02-09 16:12:58 +0000 |
| commit | a52c5778bb9d95097cc965539731a2ef846c3ff0 (patch) | |
| tree | b2afb1d9b4e9179b1d1161814775b25e7ca46295 | |
| parent | 6b0801d4f3bcdce5c7aaeb31227782293abbfa68 (diff) | |
| parent | 6c3cd241e87938373d31d5d4914fccda74145e02 (diff) | |
| download | gitlab-ce-a52c5778bb9d95097cc965539731a2ef846c3ff0.tar.gz | |
Merge branch 'index_snippet' into 'master'
Add index for snippet's updated_at
@DouweM We are ordering by `updated_at` but there is no index.
cc @yorickpeterse
See merge request !2768
| -rw-r--r-- | db/migrate/20160209130428_add_index_to_snippet.rb | 5 | ||||
| -rw-r--r-- | db/schema.rb | 3 |
2 files changed, 7 insertions, 1 deletions
diff --git a/db/migrate/20160209130428_add_index_to_snippet.rb b/db/migrate/20160209130428_add_index_to_snippet.rb new file mode 100644 index 00000000000..95d5719be59 --- /dev/null +++ b/db/migrate/20160209130428_add_index_to_snippet.rb @@ -0,0 +1,5 @@ +class AddIndexToSnippet < ActiveRecord::Migration + def change + add_index :snippets, :updated_at + end +end diff --git a/db/schema.rb b/db/schema.rb index f2eb48e37ed..13bb3938490 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -11,7 +11,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 20160129135155) do +ActiveRecord::Schema.define(version: 20160209130428) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -771,6 +771,7 @@ ActiveRecord::Schema.define(version: 20160129135155) do add_index "snippets", ["created_at"], name: "index_snippets_on_created_at", using: :btree add_index "snippets", ["expires_at"], name: "index_snippets_on_expires_at", using: :btree add_index "snippets", ["project_id"], name: "index_snippets_on_project_id", using: :btree + add_index "snippets", ["updated_at"], name: "index_snippets_on_updated_at", using: :btree add_index "snippets", ["visibility_level"], name: "index_snippets_on_visibility_level", using: :btree create_table "spam_logs", force: :cascade do |t| |