From f34c2a2c95559bcb2d068abd611fff5cc677f159 Mon Sep 17 00:00:00 2001
From: Vika <vika@fireburn.ru>
Date: Fri, 21 Jul 2023 17:43:01 +0300
Subject: Split Postgres schemas into two

Now the postgres schemas are completely independent of each
other. This took a while to figure out!
---
 kittybox-rs/migrations/0002_webmention_queue.sql | 13 -------------
 1 file changed, 13 deletions(-)
 delete mode 100644 kittybox-rs/migrations/0002_webmention_queue.sql

(limited to 'kittybox-rs/migrations/0002_webmention_queue.sql')

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;
-- 
cgit 1.4.1

