messengers

• id int(10) unsigned NOT NULL AUTO_INCREMENT
• dir varchar(64) COLLATE utf8_unicode_ci NOT NULL,
• company_id int(10) unsigned NOT NULL,
• name varchar(128) COLLATE utf8_unicode_ci NOT NULL,
• version varchar(16) COLLATE utf8_unicode_ci NOT NULL,
• PRIMARY KEY (`id`),
• UNIQUE INDEX `dir` (`dir`,`company_id`)

messenger_meta

• messenger_id int(10) unsigned NOT NULL AUTO_INCREMENT,
• key varchar(32) COLLATE utf8_unicode_ci NOT NULL,
• value text COLLATE utf8_unicode_ci NOT NULL,
• encrypted tinyint(1) NOT NULL DEFAULT '0',
• PRIMARY KEY (`messenger_id`,`key`)

log_messages

• id int(10) unsigned NOT NULL AUTO_INCREMENT,
• company_id int(10) unsigned NOT NULL,
• to_client_id int(10) unsigned DEFAULT NULL,
• text mediumtext COLLATE utf8_unicode_ci,
• sent tinyint(1) unsigned NOT NULL DEFAULT '0',
• error text COLLATE utf8_unicode_ci,
• date_sent datetime NOT NULL,
• PRIMARY KEY (`id`),
• INDEX `company_id` (`company_id`),
• INDEX `to_client_id` (`to_client_id`)

Update the Logs model to support the message log

• addMessage
• deleteMessage
• getMessage
• getMessageList
• getMessageListCount
• validateMessage

Add a MessengerManager model

• add
• delete
• get
• getAll
• getByDir
• upgrade
• getTypes