========================================
Migration 011: Instagram Comment Integrity Fixes
========================================

Found 8 SQL statements to execute

[1/8] Executing statement...
  ⚠ Skipped (already exists): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'post_url_hash'
[2/8] Executing statement...
  ✓ Success
[3/8] Executing statement...
  ⚠ Skipped (already exists): SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'replies_count'
[4/8] Executing statement...
  ✓ Success
[5/8] Executing statement...
  ✓ Success
[6/8] Executing statement...
  ✓ Success
[7/8] Executing statement...
  ⚠ Skipped (already exists): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'unique_comment_id'
[8/8] Executing statement...
  ⚠ Skipped (already exists): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'idx_campaign_post'

========================================
Migration Summary
========================================
Executed: 4
Skipped:  4
Errors:   0

========================================
Verification
========================================
✓ instagram_raw.post_url_hash column exists
  Total posts with URLs: 3452
  Posts with hash: 3452
✓ instagram_comments.is_deleted column exists
✓ instagram_comments.fetched_at column exists
✓ instagram_comments.replies_count column exists
✓ unique_comment_id constraint exists
⚠ Found 841 orphan comments (comments without matching posts)
  These should be cleaned up manually if needed.

========================================
Migration completed!
========================================