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

Timestamp:

06/24/2026 04:08:34 PM (3 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

19a72df

Parents:

d0cab9d

Message:

feat(fediverse-client): block/defederate accounts & domains

Block an @handle or a whole domain (/blokkeren + 🚫 on timeline items): their
inbound activities are silently dropped (202) and their stored content is purged.
New ap_blocks table + isBlockedAny gate in the inbox. Top-bar bell now points to
the fediverse /meldingen (gated to site managers via canManageFedi) instead of the
dead native notifications.

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

File:

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

src/config/database.js

@@ -379 +379 @@
     );
     CREATE INDEX IF NOT EXISTS idx_ap_timeline_slug ON ap_timeline(slug, published);
+    CREATE TABLE IF NOT EXISTS ap_blocks (
+      id INTEGER PRIMARY KEY AUTOINCREMENT,
+      slug TEXT NOT NULL,          -- our site that set the block
+      target TEXT NOT NULL,        -- actor URI (actor block) or domain (domain block)
+      kind TEXT NOT NULL,          -- 'actor' | 'domain'
+      label TEXT,                  -- display (@handle or domain)
+      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
+      UNIQUE(slug, target)
+    );
+    CREATE INDEX IF NOT EXISTS idx_ap_blocks_target ON ap_blocks(target);
   `);
 }