Changeset 5e61b17 in Klonkt for src/config/database.js

Timestamp:

06/21/2026 03:16:51 PM (3 months ago)

Author:

roboburr <roboburr@…>

Branches:

main

Children:

11b3ba5

Parents:

4885eab

Message:

feat(i18n): admin-configurable language — personal + default for visitors

• users.lang column: personal interface language per account (follows across devices/sessions). Switcher (/lang/:code) and Account select both write it.
• app_setting default_lang: admin picks the default language for visitors in Admin → Settings (overrides env/browser; empty = automatic).
• resolveLang priority: session choice → users.lang → default_lang (DB) → env KLONKT_DEFAULT_LANG → browser → nl.
• Account: language select; admin-settings: default language select. NL/EN/DE keys.

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

File:

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

src/config/database.js

@@ -43 +43 @@
   // Read-only/kijk-account: kan alles bekijken maar geen wijzigingen doen.
   ensureColumn('users', 'readonly', 'INTEGER DEFAULT 0');
+  // Persoonlijke interface-taal (nl|en|de). Null = volg de standaard (site/env/browser).
+  ensureColumn('users', 'lang', 'TEXT');
   // Site-level moderation toggle. 'trust' = auto-approve, 'moderate' = pending until reviewed.
   ensureColumn('sites', 'comments_moderation_mode', "TEXT DEFAULT 'moderate'");