From f52c257d41d1b65acef1402df543ea8848951dbf Mon Sep 17 00:00:00 2001
From: Freya Murphy <freya@freyacat.org>
Date: Wed, 18 Sep 2024 15:03:04 -0400
Subject: fix sitemap, drop old tables

---
 src/db/migrations/0001.sql | 14 ++++++++++++++
 1 file changed, 14 insertions(+)
 create mode 100644 src/db/migrations/0001.sql

(limited to 'src/db/migrations/0001.sql')

diff --git a/src/db/migrations/0001.sql b/src/db/migrations/0001.sql
new file mode 100644
index 0000000..f2bb5f6
--- /dev/null
+++ b/src/db/migrations/0001.sql
@@ -0,0 +1,14 @@
+BEGIN TRANSACTION;
+SET search_path = public;
+
+-- Migration Start
+DROP TABLE admin.request_log;
+DROP TYPE admin.request_log_method_type;
+DROP SEQUENCE sys.request_log_id_seq;
+DROP TABLE admin.banned;
+-- Migration End;
+
+-- Set Current Revision
+UPDATE sys.database_info SET curr_revision = 2 WHERE name = current_database();
+
+COMMIT TRANSACTION;
-- 
cgit v1.2.3-freya

