alter table ads change admin_status admin_status enum('none','pending','approved','rejected','revision') NOT NULL DEFAULT 'none';
alter table dl_campaigns change status `status` enum('running','pause','scheduled','insufficient_funds','daily_cap_reached','pending','complete','expired','rejected','archived') NOT NULL DEFAULT 'pending';
CREATE TABLE IF NOT EXISTS `campaign_temp` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pcat_id` varchar(512),
`scat_id` varchar(512), 
`advertiser_id` int(11),
`page_id` int(11),
`adname` varchar(512),
`adurl` varchar(512),
`upload_image1` varchar(110),
`upload_image2` varchar(110),
`upload_image3` varchar(110),
`upload_image4` varchar(110),
`upload_image5` varchar(110),
`upload_image6` varchar(110),
`upload_image7` varchar(110),
`upload_image8` varchar(110),	
`upload_image9` varchar(110),
`upload_image10` varchar(110),
`upload_image11` varchar(110),
`upload_image12` varchar(110),
`upload_image13` varchar(110),
`upload_image14` varchar(110),
`upload_image15` varchar(110),
`upload_image16` varchar(110),
`upload_image17` varchar(110),
`upload_image18` varchar(110),
`upload_image19` varchar(110),
`upload_image20` varchar(110),
`county` varchar(212),
`city` varchar(212),
`pincode` varchar(212),
`daywise` varchar(212),
`datewise` varchar(212),
`telecom_operators` varchar(512),
`mobile_device` varchar(512),
`operatiing_system` varchar(300),
`os_version` varchar(300),
`browser` varchar(212),
`browser_version` varchar(200),
`total_buget` varchar(110),
`daily_budget` varchar(110),
`costper_click` varchar(120),
`create_date_time` DATETIME NOT NULL
`update_date_time` DATETIME NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;
