Index: src/config/database.js
===================================================================
--- src/config/database.js	(revision 737ea05350ed2cb26c87fffc0f5a108905f63c7e)
+++ src/config/database.js	(revision 7f265ceaf13b1424663badd9afaa64fcfab3d0bd)
@@ -347,4 +347,16 @@
     );
     CREATE INDEX IF NOT EXISTS idx_poll_votes_post ON poll_votes(post_id);
+    CREATE TABLE IF NOT EXISTS ap_mentions (
+      id INTEGER PRIMARY KEY AUTOINCREMENT,
+      slug TEXT NOT NULL,           -- our mentioned site/actor
+      object_uri TEXT NOT NULL,     -- the remote note that mentions us
+      note_url TEXT,                -- its human URL (open/interact)
+      actor_uri TEXT, actor_name TEXT, actor_handle TEXT, actor_icon TEXT, actor_url TEXT,
+      content TEXT,                 -- sanitized HTML snippet of the mentioning note
+      published TEXT,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      UNIQUE(slug, object_uri)
+    );
+    CREATE INDEX IF NOT EXISTS idx_ap_mentions_slug ON ap_mentions(slug, created_at);
     CREATE TABLE IF NOT EXISTS ap_reports (
       id INTEGER PRIMARY KEY AUTOINCREMENT,