Index: src/config/database.js
===================================================================
--- src/config/database.js	(revision 3289a6433bf12cccc844824d53d4f353853ef2f0)
+++ src/config/database.js	(revision 2f42b60f28814a5e5d3f88ee044133288f805a8e)
@@ -354,4 +354,12 @@
     );
     CREATE INDEX IF NOT EXISTS idx_ap_outbox_post ON ap_outbox(post_id);
+    -- Your like/boost state on a REMOTE post (the interact page), so those become toggles.
+    CREATE TABLE IF NOT EXISTS ap_my_reactions (
+      site_slug TEXT NOT NULL,
+      target_uri TEXT NOT NULL,
+      kind TEXT NOT NULL,             -- 'like' | 'boost'
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      UNIQUE(site_slug, target_uri, kind)
+    );
   `);
   ensureColumn('ap_interactions', 'parent_uri', 'TEXT'); // nesting (existing DBs)