Function deleteMember

packages/core/src/query/member-ops.ts:113–124

(db: DatabaseAdapter, memberId: number)

 * Delete a member and all their messages / name history.
 */
export function deleteMember(db: DatabaseAdapter, memberId: number): boolean {
  try {
    db.transaction(() => {
      db.prepare('DELETE FROM message WHERE sender_id = ?').run(memberId)
      db.prepare('DELETE FROM member_name_history WHERE member_id = ?').run(memberId)
      db.prepare('DELETE FROM member WHERE id = ?').run(memberId)
    })
    return true
  } catch {
    return false
  }
}

/**
 * Ensure the `aliases` column exists on the `member` table (DDL migration).