ALTER TABLE ad_spots ADD COLUMN player_position ENUM('preroll','midroll','postroll','overlay') DEFAULT NULL AFTER vast_url;
ALTER TABLE ad_spots ADD COLUMN midroll_at TINYINT UNSIGNED DEFAULT 50 AFTER player_position;
ALTER TABLE ad_spots ADD COLUMN skip_after TINYINT UNSIGNED DEFAULT 5 AFTER midroll_at;



DELETE FROM ad_zones WHERE slug = 'player_overlay' AND (SELECT c FROM (SELECT COUNT(*) c FROM ad_zones WHERE slug = 'in_player') t) > 0;
UPDATE ad_zones SET slug = 'in_player', name = 'In-Player Ads', description = 'Video ads displayed inside the player: pre-roll, mid-roll, post-roll, or overlay banners.' WHERE slug = 'player_overlay';
