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

Timestamp:

06/27/2026 03:01:13 PM (2 months ago)

Author:

Robin Genis <roboburr@…>

Branches:

main

Children:

3746f6a

Parents:

98fe58a

Message:

chore: code cleanup — remove dead files, deps, DB tables, Google-login remnants

• Deleted dead files: routes/notifications.js + services/NotificationService.js + views/pages/notifications.ejs (old bell, unmounted; live fedi notifications live in posts.js); deploy/verify.ps1 (stale smoke test).
• package.json — drop unused ws dependency (no WebSocket since Prutter was removed).
• .env.example — drop GOOGLE_* vars (Google login removed).
• config/database.js — remove CREATE statements for dead tables (circle_links/remote_actors/ remote_posts from old Circles v1; user_notifications; post_likes). No DROP — existing rows stay.
• services/i18n.js — remove dead keys: hub, prutter, and the whole Google-login set (+ the agoog.* wizard + glog.* notices, ~280 lines). Kept aseo.verify_google. solo_desc/login_google_only de-Googled.
• views/pages/auth-login.ejs — drop the dead Google error block + button CSS; the password login form is unchanged.
• deploy/post-receive — fix stale pm2 reload prutcms -> klonkt.

File:

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

src/config/database.js

@@ -163 +163 @@
   `);
 
-  // ── Circles (federation) ────────────────────────────────────
-  // Decentralised, asymmetric connections between solo instances.
-  db.exec(`
-    CREATE TABLE IF NOT EXISTS circle_links (
-      id TEXT PRIMARY KEY,
-      local_site_id TEXT NOT NULL,
-      remote_url TEXT NOT NULL,
-      remote_actor_id TEXT,
-      label TEXT,
-      status TEXT DEFAULT 'active',
-      added_at DATETIME DEFAULT CURRENT_TIMESTAMP,
-      last_synced DATETIME,
-      last_error TEXT,
-      UNIQUE(local_site_id, remote_url),
-      FOREIGN KEY (local_site_id) REFERENCES sites(id)
-    );
-    CREATE TABLE IF NOT EXISTS remote_actors (
-      id TEXT PRIMARY KEY,
-      url TEXT UNIQUE NOT NULL,
-      name TEXT,
-      summary TEXT,
-      avatar TEXT,
-      public_key TEXT NOT NULL,
-      fetched_at DATETIME DEFAULT CURRENT_TIMESTAMP
-    );
-    CREATE TABLE IF NOT EXISTS remote_posts (
-      id TEXT PRIMARY KEY,
-      actor_id TEXT NOT NULL,
-      published DATETIME,
-      title TEXT,
-      summary TEXT,
-      url TEXT,
-      media_json TEXT,
-      raw_json TEXT,
-      fetched_at DATETIME DEFAULT CURRENT_TIMESTAMP,
-      FOREIGN KEY (actor_id) REFERENCES remote_actors(id)
-    );
-  `);
-
-  // Tags from the original post — shown in the circle feed (comma-separated string).
-  ensureColumn('remote_posts', 'tags', 'TEXT');
-
   // Newsletter / mailing list (premium). Subscribers per site; double opt-in when SMTP
   // is configured (status 'pending' until confirmed), otherwise single opt-in ('confirmed').
@@ -252 +210 @@
   `);
 
-  // Notifications: someone replies to your comment / post, or likes your post. Snapshots
-  // of name/title so the list can be shown cheaply without joins.
-  // NB: deliberately named 'user_notifications' — some older DBs still have a stale,
-  // unused 'notifications' table with a different schema (no read column).
-  db.exec(`
-    CREATE TABLE IF NOT EXISTS user_notifications (
-      id TEXT PRIMARY KEY,
-      user_id TEXT NOT NULL,
-      type TEXT NOT NULL,
-      actor_id TEXT,
-      actor_name TEXT,
-      post_slug TEXT,
-      post_title TEXT,
-      url TEXT,
-      read INTEGER DEFAULT 0,
-      created_at DATETIME DEFAULT CURRENT_TIMESTAMP
-    );
-  `);
-  // Older DBs may have a user_notifications table predating these columns — add
-  // them before the index (which references `read`), else boot crashes.
-  ensureColumn('user_notifications', 'type', 'TEXT');
-  ensureColumn('user_notifications', 'actor_id', 'TEXT');
-  ensureColumn('user_notifications', 'actor_name', 'TEXT');
-  ensureColumn('user_notifications', 'post_slug', 'TEXT');
-  ensureColumn('user_notifications', 'post_title', 'TEXT');
-  ensureColumn('user_notifications', 'url', 'TEXT');
-  ensureColumn('user_notifications', 'read', 'INTEGER DEFAULT 0');
-  db.exec('CREATE INDEX IF NOT EXISTS idx_unotif_user ON user_notifications(user_id, read, created_at);');
-
   // Link-in-bio click statistics (premium #6). One counter per (site, url); the
   // link-in-bio page links via /links/go/:i which counts the click and redirects.
@@ -293 +222 @@
   `);
 
-  // Likes / favourites: a logged-in user can like a post. The set of
-  // posts a user liked = their favourites (/favorieten page). One row
-  // per (post, user); unique so that liking is idempotent.
-  db.exec(`
-    CREATE TABLE IF NOT EXISTS post_likes (
-      post_id TEXT NOT NULL,
-      user_id TEXT NOT NULL,
-      created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
-      PRIMARY KEY (post_id, user_id)
-    );
-    CREATE INDEX IF NOT EXISTS idx_post_likes_user ON post_likes(user_id, created_at);
-    CREATE INDEX IF NOT EXISTS idx_post_likes_post ON post_likes(post_id);
-  `);
 
   // ── ActivityPub (fediverse bridge) ──────────────────────────