INSERT IGNORE INTO ad_zones (slug, name, description, page, position, is_active) VALUES
('before_comments', 'Before Comments', 'Displayed above the comments section on the watch page.', 'watch', 2, 1),
('between_related', 'Between Related Videos', 'Inserted between related video thumbnails below the player.', 'watch', 3, 1),
('player_pause', 'Pause Ad', 'Shown in the center of the player when the viewer pauses the video.', 'player', 2, 1),
('player_popunder', 'Player Popunder', 'A popunder opened by a player action you choose: when the viewer clicks the player, pauses, or resumes playback.', 'player', 3, 1),
('listing_top', 'Top of Listings', 'Displayed at the top of listing pages (search results, tag pages, etc.).', 'listing', 1, 1),
('category_top', 'Top of Category', 'Displayed at the top of category pages, below the category title.', 'category', 1, 1),
('category_between', 'Between Videos (Category)', 'Inserted between video thumbnails on category pages.', 'category', 2, 1),
('category_bottom', 'Below Category Listings', 'Displayed at the bottom of category pages.', 'category', 3, 1),
('performer_top', 'Top of Performer', 'Displayed at the top of performer pages, below the performer info.', 'performer', 1, 1),
('performer_between', 'Between Videos (Performer)', 'Inserted between video thumbnails on performer pages.', 'performer', 2, 1),
('performer_bottom', 'Below Performer Listings', 'Displayed at the bottom of performer pages.', 'performer', 3, 1),
('homepage_hero', 'Hero Banner', 'Large banner at the very top of the homepage, before any video.', 'homepage', 1, 1),
('homepage_hero_left', 'Hero — Left Square', 'Square ad to the LEFT of the homepage hero banner (shown on wide screens only).', 'homepage', 2, 1),
('homepage_hero_right', 'Hero — Right Square', 'Square ad to the RIGHT of the homepage hero banner (shown on wide screens only).', 'homepage', 3, 1),
('homepage_between', 'Between Sections', 'Inserted between video sections (e.g. between Latest and Most Viewed).', 'homepage', 4, 1),
('homepage_bottom', 'Below Content', 'At the bottom of the homepage, after all video sections.', 'homepage', 5, 1),
('interstitial', 'Interstitial', 'Full-screen ad shown once per visit, after a short delay, with a close button. Off until you add a creative.', 'all', 5, 1),
('push', 'In-Page Push', 'Small notification card that slides in from the corner once per visit (icon image + headline). Off until you add a creative.', 'all', 6, 1);

UPDATE ad_zones SET page = 'player',    position = 1 WHERE slug = 'in_player';
UPDATE ad_zones SET page = 'all',       position = 1 WHERE slug = 'header_banner';
UPDATE ad_zones SET page = 'all',       position = 2 WHERE slug = 'footer_banner';
UPDATE ad_zones SET page = 'all',       position = 3 WHERE slug = 'popup';
UPDATE ad_zones SET page = 'all',       position = 4 WHERE slug = 'mobile_sticky';
UPDATE ad_zones SET page = 'watch',     position = 1 WHERE slug = 'before_player';
UPDATE ad_zones SET page = 'watch',     position = 4 WHERE slug = 'after_player';
UPDATE ad_zones SET page = 'watch',     position = 5 WHERE slug = 'sidebar';
UPDATE ad_zones SET page = 'listing',   position = 2 WHERE slug = 'listing_between';
UPDATE ad_zones SET page = 'listing',   position = 3 WHERE slug = 'listing_bottom';

UPDATE ad_zones SET name = 'Popup / Popunder', description = 'Opens an offer behind the current tab. Each popunder has its own custom trigger delay (instant, 5s, 1 min 30...) and a frequency cap.' WHERE slug = 'popup';
