alter table bf_campaign drop column sms_text;
CREATE TABLE `bf_city_sms_queue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sender_id` varchar(50) DEFAULT 'BILLFR',
  `cities` longtext,
  `sms_text` varchar(4096) DEFAULT NULL,
  `campaign_id` int(11) DEFAULT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_updated` datetime DEFAULT NULL,
  `response` text,
  `status` enum('a','i','e') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

-- Added user_count field in campaign table
alter table bf_campaign add column user_count int default null after validity_date;

-- Added offer suggestion table
 CREATE TABLE `bf_predict_offer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` enum('title','description','sms_text','discount') DEFAULT NULL,
  `value` longtext NOT NULL,
  `date_added` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_updated` datetime DEFAULT CURRENT_TIMESTAMP,
  `added_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `status` enum('a','i') DEFAULT 'a',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
