


ALTER TABLE `ad_spots`
  ADD COLUMN `pop_mode` ENUM('url','code') NOT NULL DEFAULT 'url' AFTER `vast_url`,
  ADD COLUMN `popunder_url` VARCHAR(500) DEFAULT NULL AFTER `pop_mode`,
  ADD COLUMN `pop_delay` SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER `popunder_url`,
  ADD COLUMN `pop_cap` SMALLINT UNSIGNED NOT NULL DEFAULT 1 AFTER `pop_delay`,
  ADD COLUMN `pop_window` SMALLINT UNSIGNED NOT NULL DEFAULT 24 AFTER `pop_cap`;
