X-Git-Url: https://git.openstreetmap.org./chef.git/blobdiff_plain/68db87bff88a17bc250d072431882ba9f171a7be..fbd1e8f60e9535b88f46f0b33b49e85f7787b962:/cookbooks/db/files/default/monthly-reindex.sql

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index 2789789be..ab9ae105b 100644
--- a/cookbooks/db/files/default/monthly-reindex.sql
+++ b/cookbooks/db/files/default/monthly-reindex.sql
@@ -7,7 +7,6 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_comments;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_tags;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets_subscribers;
-REINDEX (VERBOSE) TABLE CONCURRENTLY client_applications;
 REINDEX (VERBOSE) TABLE CONCURRENTLY current_relation_members;
 REINDEX (VERBOSE) TABLE CONCURRENTLY delayed_jobs;
 REINDEX (VERBOSE) TABLE CONCURRENTLY diary_comments;
@@ -21,12 +20,11 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY issues;
 REINDEX (VERBOSE) TABLE CONCURRENTLY languages;
 REINDEX (VERBOSE) TABLE CONCURRENTLY messages;
 REINDEX (VERBOSE) TABLE CONCURRENTLY note_comments;
+REINDEX (VERBOSE) TABLE CONCURRENTLY note_subscriptions;
 REINDEX (VERBOSE) TABLE CONCURRENTLY notes;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications;
-REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_nonces;
-REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_tokens;
 REINDEX (VERBOSE) TABLE CONCURRENTLY redactions;
 REINDEX (VERBOSE) TABLE CONCURRENTLY reports;
 REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations;
@@ -34,5 +32,4 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY user_blocks;
 REINDEX (VERBOSE) TABLE CONCURRENTLY user_mutes;
 REINDEX (VERBOSE) TABLE CONCURRENTLY user_preferences;
 REINDEX (VERBOSE) TABLE CONCURRENTLY user_roles;
-REINDEX (VERBOSE) TABLE CONCURRENTLY user_tokens;
 REINDEX (VERBOSE) TABLE CONCURRENTLY users;