ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / centosnipponia / public_html / ticketing.nipponia.com / ticketing-old / include / upgrader / streams / core

/**
 * @signature 0d6099a650cc7884eb59a040feab2ce8
 * @version v1.10.0
 * @title Add events to the ticket thread
 *
 */

ALTER TABLE `%TABLE_PREFIX%ticket_event`
  ADD `id` int(10) unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST,
  CHANGE `ticket_id` `thread_id` int(11) unsigned NOT NULL default '0',
  CHANGE `staff` `username` varchar(128) NOT NULL default 'SYSTEM',
  CHANGE `state` `state` enum('created','closed','reopened','assigned','transferred','overdue','edited','viewed','error','collab','resent') NOT NULL,
  ADD `data` varchar(1024) DEFAULT NULL COMMENT 'Encoded differences' AFTER `state`,
  ADD `uid` int(11) unsigned DEFAULT NULL AFTER `username`,
  ADD `uid_type` char(1) NOT NULL DEFAULT 'S' AFTER `uid`,
  RENAME TO `%TABLE_PREFIX%thread_event`;

-- Change the `ticket_id` column to the values in `%thread`.`id`
CREATE TABLE `%TABLE_PREFIX%_ticket_thread_evt`
    (PRIMARY KEY (`object_id`))
    SELECT `object_id`, `id` FROM `%TABLE_PREFIX%thread`
    WHERE `object_type` = 'T';

UPDATE `%TABLE_PREFIX%thread_event` A1
    LEFT JOIN `%TABLE_PREFIX%_ticket_thread_evt` A2 ON (A1.`thread_id` = A2.`object_id`)
    SET A1.`thread_id` = A2.`id`;

DROP TABLE `%TABLE_PREFIX%_ticket_thread_evt`;

-- Attempt to connect the `username` to the staff_id
UPDATE `%TABLE_PREFIX%thread_event` A1
    LEFT JOIN `%TABLE_PREFIX%staff` A2 ON (A2.`username` = A1.`username`)
    SET A1.`uid` = A2.`staff_id`
    WHERE A1.`username` != 'SYSTEM';

ALTER TABLE `%TABLE_PREFIX%user_email`
  ADD `flags` int(10) unsigned NOT NULL DEFAULT 0 AFTER `user_id`;

ALTER TABLE `%TABLE_PREFIX%form`
  CHANGE `deletable` `flags` int(10) unsigned NOT NULL DEFAULT 1;

-- Previous versions did not correctly mark the internal forms as NOT deletable
UPDATE `%TABLE_PREFIX%form`
  SET `flags` = 0 WHERE `type` IN ('T','U','C','O','A');

ALTER TABLE `%TABLE_PREFIX%team`
  ADD `flags` int(10) unsigned NOT NULL default 1 AFTER `lead_id`;

UPDATE `%TABLE_PREFIX%team`
  SET `flags` = CASE WHEN `isenabled` THEN 1 ELSE 0 END
              + CASE WHEN `noalerts` THEN 2 ELSE 0 END;

-- Migrate %config[namespace=dept.x, key=alert_members_only]
ALTER TABLE `%TABLE_PREFIX%department`
  ADD `flags` int(10) unsigned NOT NULL default 0 AFTER `manager_id`;

UPDATE `%TABLE_PREFIX%department` A1
  JOIN `%TABLE_PREFIX%config` A2
    ON (A2.`namespace` = CONCAT('dept.', A1.`id`) AND A2.`key` = 'assign_members_only')
  SET A1.`flags` = 1 WHERE A2.`value` != '';

-- Migrate %config[namespace=sla.x, key=transient]
ALTER TABLE `%TABLE_PREFIX%sla`
  ADD `flags` int(10) unsigned NOT NULL default 3 AFTER `id`;

UPDATE `%TABLE_PREFIX%sla` A1
  SET A1.`flags` =
      (CASE WHEN A1.`isactive` THEN 1 ELSE 0 END)
    | (CASE WHEN A1.`enable_priority_escalation` THEN 2 ELSE 0 END)
    | (CASE WHEN A1.`disable_overdue_alerts` THEN 4 ELSE 0 END)
    | (CASE WHEN (SELECT `value` FROM `%TABLE_PREFIX%config` `config`
            WHERE`config`.`namespace` = CONCAT('sla.', A1.`id`) AND `config`.`key` = 'transient')
            = '1' THEN 8 ELSE 0 END);

ALTER TABLE `%TABLE_PREFIX%ticket`
  ADD `source_extra` varchar(40) NULL default NULL AFTER `source`;

-- Retire %config[namespace=list.x, key=configuration]
ALTER TABLE `%TABLE_PREFIX%list`
  ADD `configuration` text NOT NULL DEFAULT '' AFTER `type`;

UPDATE `%TABLE_PREFIX%list` A1
  JOIN `%TABLE_PREFIX%config` A2
    ON (A2.`namespace` = CONCAT('list.', A1.`id`) AND A2.`key` = 'configuration')
  SET A1.`configuration` = A2.`value`;

-- Rebuild %ticket__cdata as UTF8
DROP TABLE IF EXISTS `%TABLE_PREFIX%ticket__cdata`;

-- Move `enable_html_thread` to `enable_richtext`
UPDATE `%TABLE_PREFIX%config`
  SET `key` = 'enable_richtext'
  WHERE `namespace` = 'core' AND `key` = 'enable_html_thread';

SET @name_format = (SELECT `value` FROM `%TABLE_PREFIX%config` A1
    WHERE A1.`namespace` = 'core' AND A1.`key` = 'name_format');
INSERT INTO `%TABLE_PREFIX%config`
    (`namespace`, `key`, `value`) VALUES
    ('core', 'agent_name_format', @name_format),
    ('core', 'client_name_format', @name_format);

-- Drop search table and turn on reindexing
DROP TABLE IF EXISTS `%TABLE_PREFIX%_search`;

UPDATE `%TABLE_PREFIX%config` SET `value` = '1'
  WHERE `key` = 'reindex' and `namespace` = 'mysqlsearch';

-- Support varying names for duplicated content
ALTER TABLE `%TABLE_PREFIX%attachment`
  ADD `name` varchar(255) NULL default NULL AFTER `file_id`;

-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
    SET `value` = '0d6099a650cc7884eb59a040feab2ce8'
    WHERE `key` = 'schema_signature' AND `namespace` = 'core';

[+] ..
[-] 00c949a6-8b923d61.patch.sql [edit]
[-] 00c949a6-8b923d61.task.php [edit]
[-] 00ff231f-9f3b454c.patch.sql [edit]
[-] 02decaa2-60fcbee1.patch.sql [edit]
[-] 03ff59bf-b26f29a6.cleanup.sql [edit]
[-] 03ff59bf-b26f29a6.patch.sql [edit]
[-] 0ca85857-86707325.patch.sql [edit]
[-] 0d6099a6-98ad7d55.cleanup.sql [edit]
[-] 0d6099a6-98ad7d55.patch.sql [edit]
[-] 0d6099a6-98ad7d55.task.php [edit]
[-] 15719536-dd0022fb.patch.sql [edit]
[-] 15af7cd3-98ae1ed2.patch.sql [edit]
[-] 15b30765-dd0022fb.cleanup.sql [edit]
[-] 15b30765-dd0022fb.patch.sql [edit]
[-] 15b30765-dd0022fb.task.php [edit]
[-] 16fcef4a-d51f303a.patch.sql [edit]
[-] 1b0fce99-ed60ba20.patch.sql [edit]
[-] 1da1bcba-15b30765.patch.sql [edit]
[-] 1ee831c8-36f6b328.cleanup.sql [edit]
[-] 1ee831c8-36f6b328.patch.sql [edit]
[-] 1ee831c8-36f6b328.task.php [edit]
[-] 26fd79dc-00c949a6.cleanup.sql [edit]
[-] 26fd79dc-00c949a6.patch.sql [edit]
[-] 26fd79dc-00c949a6.task.php [edit]
[-] 2d590ffa-9143a511.patch.sql [edit]
[-] 2e20a0eb-98ae1ed2.patch.sql [edit]
[-] 2e7531a2-d0e37dca.patch.sql [edit]
[-] 32de1766-852ca89e.patch.sql [edit]
[-] 36f6b328-5cd0a25a.cleanup.sql [edit]
[-] 36f6b328-5cd0a25a.patch.sql [edit]
[-] 36f6b328-5cd0a25a.task.php [edit]
[-] 4323a6a8-9ef33a06.patch.sql [edit]
[-] 435c62c3-2e7531a2.cleanup.sql [edit]
[-] 435c62c3-2e7531a2.patch.sql [edit]
[-] 435c62c3-2e7531a2.task.php [edit]
[-] 49478749-c2d2fabf.patch.sql [edit]
[-] 4bd47d94-e7038ce9.cleanup.sql [edit]
[-] 4bd47d94-e7038ce9.patch.sql [edit]
[-] 4bd47d94-e7038ce9.task.php [edit]
[-] 522e5b78-02decaa2.patch.sql [edit]
[-] 526c601b-cce1ba43.patch.sql [edit]
[-] 5cd0a25a-2d590ffa.cleanup.sql [edit]
[-] 5cd0a25a-2d590ffa.patch.sql [edit]
[-] 5cd0a25a-2d590ffa.task.php [edit]
[-] 60fcbee1-f8856d56.patch.sql [edit]
[-] 61c9d5d7-6de40a4d.patch.sql [edit]
[-] 61c9d5d7-6de40a4d.task.php [edit]
[-] 6de40a4d-1b0fce99.patch.sql [edit]
[-] 70921d5c-26fd79dc.patch.sql [edit]
[-] 740428f9-8aeda901.patch.sql [edit]
[-] 7be60a84-522e5b78.patch.sql [edit]
[-] 83a22ba2-5fb92bef.patch.sql [edit]
[-] 852ca89e-740428f9.patch.sql [edit]
[-] 86707325-526c601b.cleanup.sql [edit]
[-] 86707325-526c601b.patch.sql [edit]
[-] 87d4a323-4bd47d94.patch.sql [edit]
[-] 87d4a323-4bd47d94.task.php [edit]
[-] 8aeda901-16fcef4a.patch.sql [edit]
[-] 8aeda901-16fcef4a.task.php [edit]
[-] 8b923d61-9b5550da.patch.sql [edit]
[-] 8f99b8bf-03ff59bf.cleanup.sql [edit]
[-] 8f99b8bf-03ff59bf.patch.sql [edit]
[-] 8f99b8bf-03ff59bf.task.php [edit]
[-] 914098f4-87d4a323.patch.sql [edit]
[-] 9143a511-0d6099a6.cleanup.sql [edit]
[-] 9143a511-0d6099a6.patch.sql [edit]
[-] 9143a511-0d6099a6.task.php [edit]
[-] 934954de-f1ccd3bb.patch.sql [edit]
[-] 934954de-f1ccd3bb.task.php [edit]
[-] 934b8db8-ad9d0a5f.patch.sql [edit]
[-] 934b8db8-ad9d0a5f.task.php [edit]
[-] 98ad7d55-934b8db8.patch.sql [edit]
[-] 98ae1ed2-e342f869.cleanup.sql [edit]
[-] 98ae1ed2-e342f869.patch.sql [edit]
[-] 98ae1ed2-e342f869.task.php [edit]
[-] 9b5550da-e6978154.patch.sql [edit]
[-] 9ef33a06-8f99b8bf.patch.sql [edit]
[-] 9f3b454c-c0fd16f4.patch.sql [edit]
[-] a67ba35e-98ae1ed2.patch.sql [edit]
[-] aa4664af-b19dc97d.patch.sql [edit]
[-] abe9c0cb-bbb021fb.patch.sql [edit]
[-] ad9d0a5f-0ca85857.patch.sql [edit]
[-] add62892-c37e1656.patch.sql [edit]
[-] aee589ab-98ae1ed2.patch.sql [edit]
[-] b19dc97d-435c62c3.patch.sql [edit]
[-] b26f29a6-1ee831c8.cleanup.sql [edit]
[-] b26f29a6-1ee831c8.patch.sql [edit]
[-] b26f29a6-1ee831c8.task.php [edit]
[-] bbb021fb-49478749.patch.sql [edit]
[-] c00511c7-7be60a84.cleanup.sql [edit]
[-] c00511c7-7be60a84.patch.sql [edit]
[-] c00511c7-7be60a84.task.php [edit]
[-] c0fd16f4-d959a00e.patch.sql [edit]
[-] c2d2fabf-aa4664af.patch.sql [edit]
[-] c37e1656-e2b4e5cb.patch.sql [edit]
[-] c37e1656-e2b4e5cb.task.php [edit]
[-] cc6d1b03-914098f4.patch.sql [edit]
[-] cce1ba43-e7dfe821.patch.sql [edit]
[-] d0e37dca-1da1bcba.patch.sql [edit]
[-] d51f303a-dad45ca2.patch.sql [edit]
[-] d51f303a-dad45ca2.task.php [edit]
[-] d959a00e-32de1766.patch.sql [edit]
[-] dad45ca2-61c9d5d7.cleanup.sql [edit]
[-] dad45ca2-61c9d5d7.patch.sql [edit]
[-] dad45ca2-61c9d5d7.task.php [edit]
[-] dd0022fb-f4da0c9b.patch.sql [edit]
[-] ddbe2e76-add62892.patch.sql [edit]
[-] e2b4e5cb-f0d2e14d.cleanup.sql [edit]
[-] e2b4e5cb-f0d2e14d.patch.sql [edit]
[-] e2b4e5cb-f0d2e14d.task.php [edit]
[-] e342f869-c00511c7.patch.sql [edit]
[-] e6978154-cc6d1b03.patch.sql [edit]
[-] e7038ce9-ddbe2e76.patch.sql [edit]
[-] e7038ce9-ddbe2e76.task.php [edit]
[-] e7dfe821-70921d5c.patch.sql [edit]
[-] ed60ba20-934954de.patch.sql [edit]
[-] f0d2e14d-83a22ba2.cleanup.sql [edit]
[-] f0d2e14d-83a22ba2.patch.sql [edit]
[-] f0d2e14d-83a22ba2.task.php [edit]
[-] f1ccd3bb-f5692e24.cleanup.sql [edit]
[-] f1ccd3bb-f5692e24.patch.sql [edit]
[-] f1ccd3bb-f5692e24.task.php [edit]
[-] f4da0c9b-00ff231f.patch.sql [edit]
[-] f5692e24-4323a6a8.patch.sql [edit]
[-] f5692e24-4323a6a8.task.php [edit]
[-] f8856d56-abe9c0cb.patch.sql [edit]