diff options
| author | abcang <abcang1015@gmail.com> | 2021-04-27 01:57:46 +0900 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-04-26 18:57:46 +0200 |
| commit | d0fc69d7213cab03c57947cac94bad1fd9cc6dba (patch) | |
| tree | 379835e0b485b6b24103ac60b5aa6855266fc070 /db/schema.rb | |
| parent | f78cbc0c32d5fc648c92b5e1de02105d6a8594c0 (diff) | |
Further improve the media attached status query for accounts (#16106)
Diffstat (limited to 'db/schema.rb')
| -rw-r--r-- | db/schema.rb | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/schema.rb b/db/schema.rb index 8dc0661fc..0d951ee95 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -10,7 +10,7 @@ # # It's strongly recommended that you check this file into your version control system. -ActiveRecord::Schema.define(version: 2021_04_21_121431) do +ActiveRecord::Schema.define(version: 2021_04_25_135952) do # These are extensions that must be enabled in order to support this database enable_extension "plpgsql" @@ -541,7 +541,7 @@ ActiveRecord::Schema.define(version: 2021_04_21_121431) do t.integer "thumbnail_file_size" t.datetime "thumbnail_updated_at" t.string "thumbnail_remote_url" - t.index ["account_id"], name: "index_media_attachments_on_account_id" + t.index ["account_id", "status_id"], name: "index_media_attachments_on_account_id_and_status_id", order: { status_id: :desc } t.index ["scheduled_status_id"], name: "index_media_attachments_on_scheduled_status_id" t.index ["shortcode"], name: "index_media_attachments_on_shortcode", unique: true t.index ["status_id"], name: "index_media_attachments_on_status_id" |