Split Postgres schemas into two

Now the postgres schemas are completely independent of each
other. This took a while to figure out!

1 files changed, 0 insertions, 13 deletions

diff --git a/kittybox-rs/migrations/0002_webmention_queue.sql b/kittybox-rs/migrations/0002_webmention_queue.sql
deleted file mode 100644
index 708933b..0000000
--- a/kittybox-rs/migrations/0002_webmention_queue.sql
+++ /dev/null
@@ -1,13 +0,0 @@
-CREATE TABLE kittybox.incoming_webmention_queue (
-       id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
-       source TEXT NOT NULL,
-       target TEXT NOT NULL,
-       recv_timestamp TIMESTAMPTZ NOT NULL DEFAULT now(),
-       attempts INTEGER NOT NULL DEFAULT 0
-);
-
-CREATE INDEX webmention_jobs_by_attempts ON kittybox.incoming_webmention_queue (attempts);
-
-CREATE RULE notify_incoming_webmention AS
-ON INSERT TO kittybox.incoming_webmention_queue
-DO ALSO NOTIFY incoming_webmention;