CREATE TABLE `campaign_webpage` (
 `page_id` int(11) NOT NULL AUTO_INCREMENT,
 `webpage_name` varchar(255) NOT NULL,
 `advertiser_id` int(11) NOT NULL,
 `body_bg_color` varchar(150) NOT NULL,
 `heading_bg_color` varchar(150) NOT NULL,
 `heading_txt_color` varchar(150) NOT NULL,
 `heading_text` varchar(255) NOT NULL,
 `mid_bg_color` varchar(150) NOT NULL,
 `mid_txt_color` varchar(150) NOT NULL,
 `mid_text` tinytext NOT NULL,
 `mid_image_isflg` enum('0','1') NOT NULL DEFAULT '1',
 `mid_imagename` varchar(255) NOT NULL,
 `mid_youtube_url` tinytext NOT NULL,
 `footer_bg_color` varchar(150) NOT NULL,
 `footer_txt_color` varchar(150) NOT NULL,
 `footer_address` varchar(255) NOT NULL,
 `footer_phone` varchar(50) NOT NULL,
 `footer_email` varchar(255) NOT NULL,
 `added_date` datetime NOT NULL,
 `modified_date` datetime NOT NULL,
 PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


alter table dl_campaigns add column page_id int(11) DEFAULT NULL;


