Changeset 9a34d31 in Klonkt for src/config/database.js

Timestamp:

06/21/2026 06:41:31 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

e25438a

Parents:

c9c6a2d

Message:

fix(notifications): table renamed to user_notifications (collision with stale table)

Older DBs still have an unused 'notifications' table (different schema, no
read column) -> CREATE TABLE IF NOT EXISTS became a no-op and the index on
read crashed the boot (demo + demohub in crash loop). Table + queries now
use user_notifications.

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

File:

• src/config/database.js (modified) (2 diffs)

src/config/database.js

@@ -254 +254 @@
   // 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 (
+  // NB: bewust 'user_notifications' — sommige oudere DBs hebben nog een stale,
+  // ongebruikte 'notifications'-tabel met een ander schema (geen read-kolom).
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS user_notifications (
       id TEXT PRIMARY KEY,
       user_id TEXT NOT NULL,
@@ -267 +269 @@
       created_at DATETIME DEFAULT CURRENT_TIMESTAMP
     );
-    CREATE INDEX IF NOT EXISTS idx_notif_user ON notifications(user_id, read, created_at);
+    CREATE INDEX IF NOT EXISTS idx_unotif_user ON user_notifications(user_id, read, created_at);
   `);