diff options
author | Vika <vika@fireburn.ru> | 2023-07-29 21:59:56 +0300 |
---|---|---|
committer | Vika <vika@fireburn.ru> | 2023-07-29 21:59:56 +0300 |
commit | 0617663b249f9ca488e5de652108b17d67fbaf45 (patch) | |
tree | 11564b6c8fa37bf9203a0a4cc1c4e9cc088cb1a5 /kittybox-rs/migrations/webmention/0001_init.sql | |
parent | 26c2b79f6a6380ae3224e9309b9f3352f5717bd7 (diff) | |
download | kittybox-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.sql | 15 |
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; |