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

Timestamp:

06/27/2026 09:46:03 PM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

d2b7247

Parents:

3746f6a

Message:

chore(cleanup): remove the dead comments_moderation_mode column + handling

Native comments are gone; this column was set but never read. Removed from the site
INSERT (admin-sites create) and UPDATE (save) in lockstep (column + placeholder + value),
from ensurePrimarySite's seed INSERT, the ensureColumn in database.js, and the 3 unused
i18n keys (asite.comment_moderation / moderation_trust / moderation_moderate, x3 langs).
No DROP — the column stays in existing DBs as harmless dead data. require_login_to_comment
is kept (still used by PermissionsService).

File:

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

src/config/database.js

@@ -46 +46 @@
   ensureColumn('users', 'lang', 'TEXT');
   // Site-level moderation toggle. 'trust' = auto-approve, 'moderate' = pending until reviewed.
-  ensureColumn('sites', 'comments_moderation_mode', "TEXT DEFAULT 'moderate'");
   // Circles: whether this site may appear in other sites' circles (surfacing opt-out).
   ensureColumn('sites', 'allow_circle', 'INTEGER DEFAULT 1');