Changeset 6351545 in Klonkt for src/config/database.js

Timestamp:

06/14/2026 08:18:50 AM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

07775b7

Parents:

9e27d64

Message:

tenancy: runtime Solo/Hub mode + mode-aware /admin (Phase 1)

Admin can switch live between modes in Admin -> Settings:

• solo: exactly one site (the primary/owner site), no /sites routing, leaner /admin.
• hub: main site + /sites/:slug routing (company; /gebruikers + assignment flow = Phase 2).

Switching is non-destructive (hides only, deletes nothing).

• app_settings (key/value singleton) + SettingsService (cached getTenancy/setTenancy).
• resolveSite: solo pins to the primary site + disables /sites/:slug + host mapping.
• /admin/settings (god-only) toggle; /admin dashboard rewritten, mode-aware.

Tested on the demo: solo/hub dashboard tiles, /sites routing per mode, toggle back/forth.

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

File:

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

src/config/database.js

@@ -93 +93 @@
       ON playlist_tracks(playlist_id, position);
   `);
+
+  // Globale app-instellingen (key/value singleton). O.a. de tenancy-modus
+  // (solo = één site, hub = bedrijfssite + /gebruikers). Default = solo.
+  db.exec(`
+    CREATE TABLE IF NOT EXISTS app_settings (
+      key TEXT PRIMARY KEY,
+      value TEXT,
+      updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
+    );
+  `);
+  db.prepare("INSERT OR IGNORE INTO app_settings (key, value) VALUES ('tenancy', 'solo')").run();
 }