You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
30 lines
1.0 KiB
30 lines
1.0 KiB
/**
|
|
* @signature 0ca8585781bc6656f3ca008212554441
|
|
* @version v1.11.0
|
|
* @title Add recipients field and collaborator flags
|
|
*
|
|
* This patch adds a new field called recipients to the thread entry table
|
|
* allowing agents to see a list of recipients for any thread entry where
|
|
* an email was involved (agent or user generated)
|
|
*
|
|
* It also adds a flags field to the thread_collaborator table which
|
|
* tracks whether or not the collaborator is active. As a result, we can
|
|
* remove the isactive field
|
|
*/
|
|
|
|
ALTER TABLE `%TABLE_PREFIX%thread_entry`
|
|
ADD `recipients` text AFTER `ip_address`;
|
|
|
|
ALTER TABLE `%TABLE_PREFIX%thread_collaborator`
|
|
ADD `flags` int(10) unsigned NOT NULL DEFAULT 1 AFTER `id`;
|
|
|
|
UPDATE `%TABLE_PREFIX%thread_collaborator`
|
|
SET `flags` = `isactive` + 2;
|
|
|
|
ALTER TABLE `%TABLE_PREFIX%thread_collaborator`
|
|
DROP COLUMN `isactive`;
|
|
|
|
-- Finished with patch
|
|
UPDATE `%TABLE_PREFIX%config`
|
|
SET `value` = '0ca8585781bc6656f3ca008212554441'
|
|
WHERE `key` = 'schema_signature' AND `namespace` = 'core';
|