about summary refs log tree commit diff
path: root/kittybox-rs/migrations/webmention/0001_init.sql
diff options
context:
space:
mode:
authorVika <vika@fireburn.ru>2023-07-29 21:59:56 +0300
committerVika <vika@fireburn.ru>2023-07-29 21:59:56 +0300
commit0617663b249f9ca488e5de652108b17d67fbaf45 (patch)
tree11564b6c8fa37bf9203a0a4cc1c4e9cc088cb1a5 /kittybox-rs/migrations/webmention/0001_init.sql
parent26c2b79f6a6380ae3224e9309b9f3352f5717bd7 (diff)
downloadkittybox-0617663b249f9ca488e5de652108b17d67fbaf45.tar.zst
Moved the entire Kittybox tree into the root
Diffstat (limited to 'kittybox-rs/migrations/webmention/0001_init.sql')
-rw-r--r--kittybox-rs/migrations/webmention/0001_init.sql15
1 files changed, 0 insertions, 15 deletions
diff --git a/kittybox-rs/migrations/webmention/0001_init.sql b/kittybox-rs/migrations/webmention/0001_init.sql
deleted file mode 100644
index 9e7a192..0000000
--- a/kittybox-rs/migrations/webmention/0001_init.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-CREATE SCHEMA IF NOT EXISTS kittybox_webmention;
-
-CREATE TABLE kittybox_webmention.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_webmention.incoming_webmention_queue (attempts);
-
-CREATE RULE notify_incoming_webmention AS
-ON INSERT TO kittybox_webmention.incoming_webmention_queue
-DO ALSO NOTIFY incoming_webmention;