ALTER TABLE `m_smtp` ADD `bmh_server` VARCHAR(128) NOT NULL ;
ALTER TABLE `m_smtp` ADD `bmh_port` INT(11) NOT NULL ;
ALTER TABLE `m_smtp` ADD `bmh_service` VARCHAR(128) NOT NULL ;
ALTER TABLE `m_smtp` ADD `bmh_soption` VARCHAR(128) NOT NULL ;
ALTER TABLE `m_smtp` ADD `bmh_folder` VARCHAR(128) NOT NULL ;

ALTER TABLE `m_campaign_rec_conn` ADD `bounced` INT(1) NOT NULL ;
ALTER TABLE `m_campaign_rec_conn` ADD `rule_cat` VARCHAR(32) NOT NULL ;
ALTER TABLE `m_campaign_rec_conn` ADD `clicked` INT(11) NOT NULL ;
ALTER TABLE `m_campaign_rec_conn` ADD `ip_receiver` VARCHAR(128) NOT NULL ;

CREATE TABLE m_geolocation (
  ip_receiver varchar(48) NOT NULL,
  user_agent varchar(128) NOT NULL,
  city varchar(48) NOT NULL,
  region varchar(48) NOT NULL,
  country_code varchar(12) NOT NULL,
  country_name varchar(48) NOT NULL,
  continent_code varchar(12) NOT NULL,
  latitude varchar(12) NOT NULL,
  longitude varchar(12) NOT NULL,
  region_code varchar(12) NOT NULL,
  region_name varchar(48) NOT NULL,
  currency_code varchar(12) NOT NULL,
  PRIMARY KEY (ip_receiver)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;