From f7deb52fd18f602bf6ef862c90e81f48cda6e45b Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 22 May 2025 19:09:16 +0100 Subject: [PATCH] Manage the social_links table in the API database --- cookbooks/db/files/default/monthly-reindex.sql | 1 + cookbooks/db/recipes/master.rb | 2 ++ 2 files changed, 3 insertions(+) diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql index ab9ae105b..ffa5faadb 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -28,6 +28,7 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications; REINDEX (VERBOSE) TABLE CONCURRENTLY redactions; REINDEX (VERBOSE) TABLE CONCURRENTLY reports; REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations; +REINDEX (VERBOSE) TABLE CONCURRENTLY social_links; REINDEX (VERBOSE) TABLE CONCURRENTLY user_blocks; REINDEX (VERBOSE) TABLE CONCURRENTLY user_mutes; REINDEX (VERBOSE) TABLE CONCURRENTLY user_preferences; diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb index 3e57941f7..f27820652 100644 --- a/cookbooks/db/recipes/master.rb +++ b/cookbooks/db/recipes/master.rb @@ -182,6 +182,7 @@ PROMETHEUS_PERMISSIONS = { relations reports schema_migrations + social_links user_blocks user_mutes user_preferences @@ -232,6 +233,7 @@ end oauth_openid_requests_id_seq redactions_id_seq reports_id_seq + social_links_id_seq user_blocks_id_seq user_mutes_id_seq user_roles_id_seq -- 2.39.5