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

Timestamp:

06/27/2026 08:10:43 AM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

c21197a

Parents:

92f6976

Message:

feat(nsfw): custom content-warning text + blur in the Cirkel

• Per-post content-warning text (like Mastodon): editor field; used as the on-site veil/banner label and the fediverse Note summary (falls back to 'Gevoelige inhoud').
• Cirkel feed now blurs remote sensitive posts: ap_timeline gets nsfw+cw (captured from the incoming Note's sensitive/summary), getCirkelPosts returns them, circle.js maps them so post-card/tile show the veil.

File:

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

src/config/database.js

@@ -85 +85 @@
   ensureColumn('posts', 'fan_only', 'INTEGER DEFAULT 0');  // fan-only preview (premium #3)
   ensureColumn('posts', 'nsfw',     'INTEGER DEFAULT 0');  // sensitive content → blur + click-to-reveal; fediverse sensitive
+  ensureColumn('posts', 'content_warning', 'TEXT');        // custom CW label (empty = default "Gevoelige inhoud")
   ensureColumn('posts', 'type',    "TEXT DEFAULT 'post'");  // post | foto | video | audio
 
@@ -416 +417 @@
   ensureColumn('ap_timeline', 'boosted', 'INTEGER DEFAULT 0');
   ensureColumn('ap_timeline', 'liked', 'INTEGER DEFAULT 0'); // a feed post you liked (⭐) → toggle
+  ensureColumn('ap_timeline', 'nsfw', 'INTEGER DEFAULT 0');  // remote sensitive post → blur in the Cirkel
+  ensureColumn('ap_timeline', 'cw', 'TEXT');                 // remote content-warning text
 }