=== DATABASE TABLES CHECK ===
All tables found: 13
Tables: affiliate_clicks, affiliate_tracking, alert_history, email_queue, price_history, products, system_analytics, test_price_history, test_products, test_users, user_events, user_sessions, users

Checking required tables:
✅ products - EXISTS
   Columns: 22
✅ users - EXISTS
   Columns: 33
✅ user_events - EXISTS
   Columns: 7
✅ user_sessions - EXISTS
   Columns: 11
✅ alert_history - EXISTS
   Columns: 11
✅ system_analytics - EXISTS
   Columns: 5
✅ affiliate_clicks - EXISTS
   Columns: 7
✅ email_queue - EXISTS
   Columns: 11

Testing users table:
Users count: 0
Users table columns:
  - id (int(11))
  - extension_id (varchar(255))
  - email (varchar(255))
  - subscription_type (enum('free','premium','enterprise'))
  - subscription_status (enum('active','inactive','trial','expired'))
  - trial_start_date (datetime)
  - trial_end_date (datetime)
  - first_name (varchar(100))
  - last_name (varchar(100))
  - language (varchar(10))
  - timezone (varchar(50))
  - browser (varchar(50))
  - browser_version (varchar(20))
  - os (varchar(50))
  - device_type (varchar(20))
  - screen_resolution (varchar(20))
  - install_date (datetime)
  - referral_source (varchar(100))
  - utm_source (varchar(100))
  - utm_medium (varchar(100))
  - utm_campaign (varchar(100))
  - utm_content (varchar(100))
  - utm_term (varchar(100))
  - total_sessions (int(11))
  - total_time_spent (int(11))
  - products_added_count (int(11))
  - last_active (datetime)
  - settings (longtext)
  - email_marketing_consent (tinyint(1))
  - marketing_consent_date (datetime)
  - affiliate_enabled (tinyint(1))
  - created_at (datetime)
  - updated_at (datetime)

=== END CHECK ===