diff options
| author | Claire <claire.github-309c@sitedethib.com> | 2022-01-23 13:53:58 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-01-23 13:53:58 +0100 |
| commit | 96f0b33c8b994440199bccda14123d0569c6bcc5 (patch) | |
| tree | 9067e6f277549dfa6fa5c8c7d836d449e8fa77c2 /db | |
| parent | 3a103cd317fd56aca27fca01e03647df44e3ffd2 (diff) | |
Remove old duplicate index (#17245)
Some Mastodon versions (v1.1 and v1.2) had a duplicate index in `db/schema.rb`
without any migration script creating it. #2224 (included in v1.3) removed the
duplicate index from the file but did not provide a migration script to remove
it.
This means that any instance that was installed from v1.1 or v1.2's source code
has a duplicate index and a corresponding warning in PgHero. Instances set up
using an earlier or later Mastodon version do not have this issue.
This PR removes the duplicate index if it is present.
Diffstat (limited to 'db')
| -rw-r--r-- | db/migrate/20220105163928_remove_mentions_status_id_index.rb | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/db/migrate/20220105163928_remove_mentions_status_id_index.rb b/db/migrate/20220105163928_remove_mentions_status_id_index.rb new file mode 100644 index 00000000000..56e90371928 --- /dev/null +++ b/db/migrate/20220105163928_remove_mentions_status_id_index.rb @@ -0,0 +1,9 @@ +class RemoveMentionsStatusIdIndex < ActiveRecord::Migration[6.1] + def up + remove_index :mentions, name: :mentions_status_id_index if index_exists?(:mentions, :status_id, name: :mentions_status_id_index) + end + + def down + # As this index should not exist and is a duplicate of another index, do not re-create it + end +end |