[CORE-3758] Create messenger tables/models - Blesta

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

Activity

Ascending order - Click to sort in descending order

Jonathan Reissmueller created issue - 16/Jul/20 6:12 PM

Jonathan Reissmueller made changes - 16/Jul/20 6:13 PM

Field	Original Value	New Value
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 KEY `dir` (`dir`,`company_id`) 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`), * KEY `company_id` (`company_id`), * KEY `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	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 KEY `dir` (`dir`,`company_id`) 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`), * KEY `company_id` (`company_id`), * KEY `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

Jonathan Reissmueller made changes - 16/Jul/20 7:07 PM

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 KEY `dir` (`dir`,`company_id`)

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`),
* KEY `company_id` (`company_id`),
* KEY `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

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 KEY `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`),
* KEY `company_id` (`company_id`),
* KEY `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

Jonathan Reissmueller made changes - 22/Jul/20 2:05 PM

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 KEY `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`),
* KEY `company_id` (`company_id`),
* KEY `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

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

Abdy Franco made changes - 07/Aug/20 4:44 PM

Assignee

Abdy Franco [ abdy ]

Automated transition triggered when Abdy Franco created a branch in Stash - 07/Aug/20 4:45 PM

Status

Open [ 1 ]

In Progress [ 3 ]

Abdy Franco made changes - 07/Aug/20 7:29 PM

Remaining Estimate		0 minutes [ 0 ]
Time Spent		3 hours, 29 minutes [ 12540 ]
Worklog Id	13964 [ 13964 ]

Abdy Franco made changes - 10/Aug/20 6:19 PM

Time Spent	3 hours, 29 minutes [ 12540 ]	1 day, 2 hours, 9 minutes [ 36540 ]
Worklog Id	13966 [ 13966 ]

Automated transition triggered when Abdy Franco created pull request #954 in Stash - 10/Aug/20 6:19 PM

Status	In Progress [ 3 ]	In Review [ 5 ]
Resolution		Fixed [ 1 ]

Automated transition triggered when Abdy Franco merged pull request #954 in Stash - 10/Aug/20 6:19 PM

Status

In Review [ 5 ]

Closed [ 6 ]

People

Assignee:

Abdy Franco

Reporter:

Jonathan Reissmueller

Votes:

0 Vote for this issue

Watchers:

1 Start watching this issue

Dates

Created:

16/Jul/20 6:12 PM

Updated:

10/Aug/20 6:19 PM

Resolved:

10/Aug/20 6:19 PM

Fix Release Date:

17/Sep/20

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1d 2h 9m

Agile

Completed Sprint:

4.12.0 Sprint 4 ended 08/Sep/20
View on Board