Manage new notification tables in the main database

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index fa8faff760709996af1c88346df5d843d6f9a3d4..230ce510bf1f210bb35f2251eb03596687a2363c 100644 (file)
--- 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 eb15a5b671a9d469f85bc4d1e323fb2bd21dfdf8..80ef431a205e5dafc597716e7bb3be36a45ebcbc 100644 (file)
--- 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