From c98b422d89c65d496c3c608130d11fb02c954733 Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Sun, 1 Sep 2024 11:16:21 +0100
Subject: [PATCH] Drop references to OAuth 1 tables

---
 cookbooks/db/files/default/monthly-reindex.sql |  3 ---
 cookbooks/db/recipes/master.rb                 | 10 ----------
 2 files changed, 13 deletions(-)

diff --git a/cookbooks/db/files/default/monthly-reindex.sql b/cookbooks/db/files/default/monthly-reindex.sql
index 65412d414..8a0d1ecbc 100644
--- a/cookbooks/db/files/default/monthly-reindex.sql
+++ b/cookbooks/db/files/default/monthly-reindex.sql
@@ -7,7 +7,6 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_comments;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changeset_tags;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets;
 REINDEX (VERBOSE) TABLE CONCURRENTLY changesets_subscribers;
-REINDEX (VERBOSE) TABLE CONCURRENTLY client_applications;
 REINDEX (VERBOSE) TABLE CONCURRENTLY current_relation_members;
 REINDEX (VERBOSE) TABLE CONCURRENTLY delayed_jobs;
 REINDEX (VERBOSE) TABLE CONCURRENTLY diary_comments;
@@ -25,8 +24,6 @@ REINDEX (VERBOSE) TABLE CONCURRENTLY notes;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_grants;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_access_tokens;
 REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_applications;
-REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_nonces;
-REINDEX (VERBOSE) TABLE CONCURRENTLY oauth_tokens;
 REINDEX (VERBOSE) TABLE CONCURRENTLY redactions;
 REINDEX (VERBOSE) TABLE CONCURRENTLY reports;
 REINDEX (VERBOSE) TABLE CONCURRENTLY schema_migrations;
diff --git a/cookbooks/db/recipes/master.rb b/cookbooks/db/recipes/master.rb
index c2d1da024..606e902bf 100644
--- a/cookbooks/db/recipes/master.rb
+++ b/cookbooks/db/recipes/master.rb
@@ -83,7 +83,6 @@ CGIMAP_PERMISSIONS = {
   "changeset_comments" => [:select],
   "changeset_tags" => [:select],
   "changesets" => [:select, :update],
-  "client_applications" => [:select],
   "current_node_tags" => [:select, :insert, :delete],
   "current_nodes" => [:select, :insert, :update],
   "current_nodes_id_seq" => [:update],
@@ -101,9 +100,6 @@ CGIMAP_PERMISSIONS = {
   "oauth_access_grants" => [:select],
   "oauth_access_tokens" => [:select],
   "oauth_applications" => [:select],
-  "oauth_nonces" => [:select, :insert],
-  "oauth_nonces_id_seq" => [:update],
-  "oauth_tokens" => [:select],
   "relation_members" => [:select, :insert],
   "relation_tags" => [:select, :insert],
   "relations" => [:select, :insert],
@@ -151,7 +147,6 @@ PROMETHEUS_PERMISSIONS = {
   changeset_tags
   changesets
   changesets_subscribers
-  client_applications
   current_node_tags
   current_nodes
   current_relation_members
@@ -179,9 +174,7 @@ PROMETHEUS_PERMISSIONS = {
   oauth_access_grants
   oauth_access_tokens
   oauth_applications
-  oauth_nonces
   oauth_openid_requests
-  oauth_tokens
   redactions
   relation_members
   relation_tags
@@ -218,7 +211,6 @@ end
   active_storage_variant_records_id_seq
   changeset_comments_id_seq
   changesets_id_seq
-  client_applications_id_seq
   current_nodes_id_seq
   current_relations_id_seq
   current_ways_id_seq
@@ -236,9 +228,7 @@ end
   oauth_access_grants_id_seq
   oauth_access_tokens_id_seq
   oauth_applications_id_seq
-  oauth_nonces_id_seq
   oauth_openid_requests_id_seq
-  oauth_tokens_id_seq
   redactions_id_seq
   reports_id_seq
   user_blocks_id_seq
-- 
2.39.5