V1 Table Cleanup — Phase 8

Drop 16 dead v1 tables, the v1_backup schema, and all associated dead code from the Eko codebase. Completes the v1 -> v2 migration.

Key Deliverables

  • SQL migration dropping 16 tables in FK-safe order
  • Remove Drizzle schema definitions for dropped tables
  • Remove dead query functions, type references, and re-exports
  • Gut feature-flags.ts admin queries referencing dropped tables
  • Remove dead test files
  • Regenerate types and indexes

Tables Being Dropped

Page tracking: pages, page_observations, page_change_events, page_change_summaries, user_pages, section_dom_mappings, page_title_history, screenshot_captures Notifications: sms_notification_pages, sms_delivery_log, notification_delivery_log User features: personas, use_cases, onboarding_state Other: screen_avatars, type_metadata

Reference Documents