From: Tom Hughes <tom@compton.nu>
Date: Thu, 31 Oct 2024 18:18:57 +0000 (+0000)
Subject: Manage note_subscriptions table
X-Git-Url: https://git.openstreetmap.org./chef.git/commitdiff_plain/a09747b8cd8c23922273cd7af77c9d2db6f1929e

Manage note_subscriptions table
---

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index 8a0d1ecbc..ab9ae105b 100644
--- 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 606e902bf..3e57941f7 100644
--- 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