Changeset c16e0a5 in Klonkt for src/config/database.js

Timestamp:

06/24/2026 11:44:23 AM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

47a0d29

Parents:

eb852c5

Message:

feat(activitypub): inbound interactions — replies, likes, boosts (Phase 2)

Inbox now stores incoming Create(reply to our note), Like and Announce (boost),
plus Undo(Like/Announce) and Delete(reply). New ap_interactions table; the post
page shows a 'From the fediverse' section (counts + replies with avatar/handle,
sanitized). Actor name/icon resolved best-effort; reply HTML sanitized.

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

File:

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

src/config/database.js

@@ -316 +316 @@
     );
     CREATE INDEX IF NOT EXISTS idx_ap_followers_slug ON ap_followers(slug);
+    CREATE TABLE IF NOT EXISTS ap_interactions (
+      id INTEGER PRIMARY KEY AUTOINCREMENT,
+      kind TEXT NOT NULL,                   -- 'reply' | 'like' | 'announce'
+      post_id TEXT NOT NULL,
+      object_uri TEXT NOT NULL DEFAULT '',  -- remote note id (reply) or '' (like/announce)
+      actor_uri TEXT NOT NULL,
+      actor_name TEXT,
+      actor_handle TEXT,
+      actor_url TEXT,
+      actor_icon TEXT,
+      content TEXT,                         -- sanitized HTML (reply)
+      published TEXT,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      UNIQUE(kind, post_id, actor_uri, object_uri)
+    );
+    CREATE INDEX IF NOT EXISTS idx_ap_inter_post ON ap_interactions(post_id, kind);
   `);
 }