Database Schema Repair Utility

This script manually checks for missing columns and indexes to avoid SQL syntax errors on older MySQL versions.

• Already exists: Column: placements.playback_method

• Already exists: Column: placements.video_placement

• Already exists: Column: placements.is_rewarded

• Already exists: Column: placements.refresh_interval

• Already exists: Column: ad_sources.source_type

• Already exists: Column: ad_sources.display_url

• Already exists: Column: ad_sources.display_type

• Already exists: Column: ad_sources.media_url

• Already exists: Column: ad_sources.duration

• Already exists: Column: ad_sources.file_size

• Already exists: Column: ad_sources.gross_cpm

• Already exists: Column: ad_sources.daily_cap

• Already exists: Column: ad_sources.hourly_cap

• Already exists: Column: stats.domain

• Already exists: Index: stats.idx_stats_pub

• Already exists: Index: stats.idx_stats_camp

• Already exists: Index: stats.idx_stats_adv

• Already exists: Index: stats.idx_stats_ts

Repair Complete. All columns and indexes should now be correct.