DELETE FROM user_conversation_message;
DELETE FROM conversation_message;
DELETE FROM conversation;

ALTER TABLE `conversation_message` ADD `created_datetime` DATETIME NOT NULL ,
ADD `updated_datetime` DATETIME NOT NULL ,
ADD `created_by` INT NOT NULL ,
ADD `updated_by` INT NOT NULL ;

ALTER TABLE `user_conversation_message` ADD `created_datetime` DATETIME NOT NULL ,
ADD `updated_datetime` DATETIME NOT NULL ,
ADD `created_by` INT NOT NULL ,
ADD `updated_by` INT NOT NULL ;

CREATE TABLE IF NOT EXISTS `email_blast_send` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_blast_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL,
  `email` varchar(150) NOT NULL,
  `status` varchar(1) NOT NULL DEFAULT 'P',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;