Changeset 55bc7f9 in Klonkt for src/config/database.js

Timestamp:

06/24/2026 12:09:08 PM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

3a2c9d3

Parents:

47a0d29

Message:

feat(activitypub): reply back to the fediverse (Phase 4 outbound)

Site owner can reply to an inbound fediverse interaction from the post page. The
reply is sent as a signed Create(Note) with inReplyTo + @Mention to the remote
actor's inbox + our followers, stored in ap_outbox, shown in the thread, and
resolvable at /ap/notes/<id>.

Co-Authored-By: Claude <noreply@…>

File:

• src/config/database.js (modified) (1 diff)

src/config/database.js

@@ -332 +332 @@
     );
     CREATE INDEX IF NOT EXISTS idx_ap_inter_post ON ap_interactions(post_id, kind);
+    CREATE TABLE IF NOT EXISTS ap_outbox (
+      id TEXT PRIMARY KEY,            -- note path segment (uuid) → /ap/notes/<id>
+      site_slug TEXT NOT NULL,
+      post_id TEXT NOT NULL,
+      post_slug TEXT,
+      in_reply_to TEXT,               -- remote status uri we reply to
+      to_actor TEXT,                  -- remote actor uri (mentioned)
+      to_handle TEXT,
+      content TEXT NOT NULL,          -- sanitized HTML of our reply
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+    );
+    CREATE INDEX IF NOT EXISTS idx_ap_outbox_post ON ap_outbox(post_id);
   `);
 }