From 7fc7a73935152b97e40d49b3221abb4a9788ee09 Mon Sep 17 00:00:00 2001 From: Tom Hughes Date: Thu, 19 Mar 2026 08:48:14 +0000 Subject: [PATCH] Manage new notification tables in the main database --- cookbooks/db/files/default/monthly-reindex.sql | 2 ++ cookbooks/db/recipes/master.rb | 4 ++++ 2 files changed, 6 insertions(+) diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql index fa8faff76..230ce510b 100644 --- a/cookbooks/db/files/default/monthly-reindex.sql +++ b/cookbooks/db/files/default/monthly-reindex.sql @@ -22,6 +22,8 @@ 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 noticed_events; +REINDEX (VERBOSE) TABLE CONCURRENTLY noticed_notifications; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens; REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications; diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb index eb15a5b67..80ef431a2 100644 --- a/cookbooks/db/recipes/master.rb +++ b/cookbooks/db/recipes/master.rb @@ -171,6 +171,8 @@ PROMETHEUS_PERMISSIONS = { note_comments note_subscriptions notes + noticed_events + noticed_notifications oauth_access_grants oauth_access_tokens oauth_applications @@ -228,6 +230,8 @@ end messages_id_seq note_comments_id_seq notes_id_seq + noticed_events_id_seq + noticed_notifications_id_seq oauth_access_grants_id_seq oauth_access_tokens_id_seq oauth_applications_id_seq -- 2.39.5