Manage note_subscriptions table

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index 8a0d1ecbce7203558b4150bf1aaa75f358251e97..ab9ae105b12e92895d1837ff80992e58e4355bba 100644 (file)
--- a/cookbooks/db/files/default/monthly-reindex.sql
+++ b/cookbooks/db/files/default/monthly-reindex.sql
@@ -20,6 +20,7 @@ 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;

diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb
index 606e902bff69be86dc635c4fc1814021a125fd9b..3e57941f7673dbd64422de12e910904118d561bd 100644 (file)
--- a/cookbooks/db/recipes/master.rb
+++ b/cookbooks/db/recipes/master.rb
@@ -170,6 +170,7 @@ PROMETHEUS_PERMISSIONS = {
   node_tags
   nodes
   note_comments
+  note_subscriptions
   notes
   oauth_access_grants
   oauth_access_tokens