Details
-
Type: Sub-task
-
Status: Closed
-
Priority: Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 4.12.0-b1
-
Component/s: None
-
Labels:None
Description
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