ALTER TABLE `dl_advertisers`
ADD `billing_first_name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_last_name` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_address1` VARCHAR(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_address2` VARCHAR(512) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_city` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_state` VARCHAR(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_country` VARCHAR(3) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_pin_code` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
ADD `billing_contact_mobile` VARCHAR(12) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE dl_campaigns ADD state_city varchar(20) default NULL;
ALTER TABLE dl_campaigns ADD device_custom varchar(20) default NULL;
CREATE TABLE `cc_adexchange`.`ad_review_log` ( `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT , `campaign_id` INT NOT NULL , `ad_id` INT NOT NULL , `reviewed_by` INT NOT NULL , `ad_assets` TEXT NOT NULL , `campaign_url` VARCHAR(512) NOT NULL , `status` ENUM('approved','revision','rejected') NOT NULL DEFAULT 'approved' , PRIMARY KEY (`id`));

