Changeset 2e9773f in Klonkt

Timestamp:

06/24/2026 02:19:18 PM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

59f0170

Parents:

075185a

Message:

fix(db): user_notifications boot crash on older DBs (missing columns)

The index on user_notifications(read) crashed boot when an older DB had a
user_notifications table predating the read/actor/post columns. ensureColumn each
before building the index.

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

File:

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

src/config/database.js

@@ -267 +267 @@
       created_at DATETIME DEFAULT CURRENT_TIMESTAMP
     );
-    CREATE INDEX IF NOT EXISTS idx_unotif_user ON user_notifications(user_id, read, created_at);
-  `);
+  `);
+  // Older DBs may have a user_notifications table predating these columns — add
+  // them before the index (which references `read`), else boot crashes.
+  ensureColumn('user_notifications', 'type', 'TEXT');
+  ensureColumn('user_notifications', 'actor_id', 'TEXT');
+  ensureColumn('user_notifications', 'actor_name', 'TEXT');
+  ensureColumn('user_notifications', 'post_slug', 'TEXT');
+  ensureColumn('user_notifications', 'post_title', 'TEXT');
+  ensureColumn('user_notifications', 'url', 'TEXT');
+  ensureColumn('user_notifications', 'read', 'INTEGER DEFAULT 0');
+  db.exec('CREATE INDEX IF NOT EXISTS idx_unotif_user ON user_notifications(user_id, read, created_at);');
 
   // Link-in-bio click statistics (premium #6). One counter per (site, url); the