- Extend tag schema with slug, description, and cached postCount
  - Add tag_merge_suggestions table for AI-powered duplicate detection
  - Enhance TagInput with autocomplete showing post counts
  - Add PopularTagsSidebar component for feed filtering
  - Implement tag filtering in feed via URL params (?tag=javascript)
  - Create admin dashboard at /admin/tags with:
    - Searchable/sortable tag table
    - Tag editing (title, slug, description)
    - Merge mode for consolidating duplicate tags
    - AI merge suggestions panel (ready for integration)
  - Add migration to convert RSS source categories to tags
  - Add tag.search, tag.getPopular, tag.getOrCreate API endpoints
  - Add admin endpoints: getAdminStats, update, mergeTags, recalculateCounts

…ality

  - Add missing postId and commentId to notification inserts in comment
    and discussion routers
  - Update notification table foreign keys to reference new posts/comments
    tables instead of legacy Post/Comment tables
  - Change postId column type from text to uuid and commentId from integer
    to uuid to match new table schemas
  - Update notification cards with modern grey/white styling (rounded
    corners, proper borders, hover effects)
  - Add E2E tests for notification display and creation flow
  - Add seed script for testing notifications locally

Add JsonLd component and structured data schemas (Article, NewsArticle, Person, Organization, WebSite, Breadcrumb)
Integrate JSON-LD into homepage, layout, user profiles, and article pages
Update robots.txt to block problematic paths and allow AI crawlers (GPTBot, Claude-Web, PerplexityBot, etc.)
Add data completeness badge to admin sources showing missing fields
Improve admin sources action button styling
Remove debug blue background from table styles

- Added missing newline at the end of _journal.json file.
- Simplified import statements in notifications.spec.ts and structured-data/index.ts for better clarity.
- Reformatted code in seed-notifications.ts for consistent indentation and readability.
- Enhanced readability of import statements in content.ts and tag.ts by aligning them properly.
- Updated test expectations in notifications.spec.ts to improve clarity and maintainability.

…ing FK constraints

The migration was failing because postId (text) and commentId (integer)
couldn't reference posts.id and comments.id (both uuid). This updates the
migration to:
- Convert postId from text to uuid using legacy_post_id lookup
- Convert commentId from integer to uuid using legacy_comment_id lookup
- Make the migration idempotent (safe to run multiple times)
- Update snapshot to reflect the new column types

Co-Authored-By: Claude Opus 4.5 <[email protected]>

…checks

…ability

…ss actions and notifications

… and reducing dependency on TRPC responses

… waiting for network idle state

…aded" for improved test reliability

Fix editor "Saved" indicator for new posts by setting savedTime in the
CREATE branch. Add test.slow() for Firefox publish test timeout. Replace
force-click bookmark buttons with proper TRPC mutation response waits.

Hide banned users' posts by updating status to draft on ban and restoring
on unban. Add defense-in-depth LEFT JOIN on banned_users to post and feed
query endpoints.

Co-Authored-By: Claude Opus 4.6 <[email protected]>