Index: src/config/database.js
===================================================================
--- src/config/database.js	(revision 5e61b173e0211ca213200be10da0a4230dcc31cf)
+++ src/config/database.js	(revision c9c6a2d6cf1cf1611a79c699dd70c435bda3c203)
@@ -252,4 +252,22 @@
   `);
 
+  // Meldingen: iemand reageert op je reactie / post, of liket je post. Snapshots
+  // van naam/titel zodat de lijst goedkoop te tonen is zonder joins.
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS notifications (
+      id TEXT PRIMARY KEY,
+      user_id TEXT NOT NULL,
+      type TEXT NOT NULL,
+      actor_id TEXT,
+      actor_name TEXT,
+      post_slug TEXT,
+      post_title TEXT,
+      url TEXT,
+      read INTEGER DEFAULT 0,
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
+    );
+    CREATE INDEX IF NOT EXISTS idx_notif_user ON notifications(user_id, read, created_at);
+  `);
+
   // Link-in-bio klikstatistiek (premium #6). Per (site, url) een teller; de
   // link-in-bio-pagina linkt via /links/go/:i dat de klik telt en doorstuurt.