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

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

/**
 * @version v1.6 RC5
 * @signature e342f869c7a537ab3ee937fb6e21cdd4
 *
 *  Upgrade from 1.6 RC1-4 to 1.6 RC5
 *
 */

ALTER TABLE `%TABLE_PREFIX%config`
    CHANGE `default_priority` `default_priority_id` TINYINT( 2 ) UNSIGNED NOT NULL DEFAULT '2',
    CHANGE `default_template` `default_template_id` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '1',
    CHANGE `default_email` `default_email_id` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0',
    CHANGE `default_dept` `default_dept_id` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
    CHANGE `enable_pop3_fetch` `enable_mail_fetch` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
    CHANGE `api_key` `api_passphrase` VARCHAR( 125 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL;

ALTER TABLE `%TABLE_PREFIX%config`
    ADD `note_alert_active` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `message_alert_dept_manager`,
    ADD `note_alert_laststaff` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `note_alert_active`,
    ADD `note_alert_assigned` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `note_alert_laststaff`,
    ADD `note_alert_dept_manager` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `note_alert_assigned`,
    ADD `alert_email_id` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `overdue_grace_period`,
    ADD `default_smtp_id` TINYINT( 4 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `default_template_id`,
    ADD `spoof_default_smtp` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `default_smtp_id`,
    ADD `log_level` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '2' AFTER `random_ticket_ids`,
    ADD `staff_max_logins` TINYINT UNSIGNED NOT NULL DEFAULT '4' AFTER `enable_daylight_saving`,
    ADD `staff_login_timeout` INT UNSIGNED NOT NULL DEFAULT '2' AFTER `staff_max_logins`,
    ADD `client_max_logins` TINYINT UNSIGNED NOT NULL DEFAULT '4' AFTER `staff_session_timeout`,
    ADD `client_login_timeout` INT UNSIGNED NOT NULL DEFAULT '2' AFTER `client_max_logins`,
    ADD `show_answered_tickets` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `show_assigned_tickets`,
    ADD `hide_staff_name` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `show_answered_tickets`,
    ADD `log_graceperiod` INT UNSIGNED NOT NULL DEFAULT '12' AFTER `log_level`;

ALTER TABLE `%TABLE_PREFIX%email`
    ADD `userid` VARCHAR( 125 ) NOT NULL AFTER `name` ,
    ADD `userpass` VARCHAR( 125 ) NOT NULL AFTER `userid`,
    ADD `mail_active` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `userpass` ,
    ADD `mail_host` VARCHAR( 125 ) NOT NULL AFTER `mail_active` ,
    ADD `mail_protocol` ENUM( 'POP', 'IMAP' ) NOT NULL AFTER `mail_host` ,
    ADD `mail_encryption` ENUM( 'NONE', 'SSL' ) NOT NULL AFTER `mail_protocol` ,
    ADD `mail_port` INT( 6 ) NULL AFTER `mail_encryption` ,
    ADD `mail_fetchfreq` TINYINT( 3 ) NOT NULL DEFAULT '5' AFTER `mail_port` ,
    ADD `mail_fetchmax` TINYINT( 4 ) NOT NULL DEFAULT '30' AFTER `mail_fetchfreq` ,
    ADD `mail_delete` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `mail_fetchmax` ,
    ADD `mail_errors` TINYINT( 3 ) NOT NULL DEFAULT '0' AFTER `mail_delete` ,
    ADD `mail_lasterror` DATETIME NULL AFTER `mail_errors` ,
    ADD `mail_lastfetch` DATETIME NULL AFTER `mail_lasterror` ,
    ADD `smtp_active` TINYINT( 1 ) NOT NULL AFTER `mail_lastfetch` ,
    ADD `smtp_host` VARCHAR( 125 ) NOT NULL AFTER `smtp_active` ,
    ADD `smtp_port` INT( 6 ) NULL AFTER `smtp_host` ,
    ADD `smtp_auth` TINYINT( 1 ) NOT NULL DEFAULT '1' AFTER `smtp_port` ;

-- Transfer old POP3 settings to "new" email table
UPDATE `%TABLE_PREFIX%email` as T1 JOIN `%TABLE_PREFIX%email_pop3` as T2 ON(T1.email_id = T2.`email_id`)
    SET
     `updated`=NOW(),
     `mail_protocol`='POP',
     `mail_encryption`='NONE',
     `mail_port`=110,
     `mail_active`=0,
     `mail_delete`=T2.`delete_msgs`,
     `mail_host`=T2.`pophost`,
     `mail_fetchfreq`=T2.`fetchfreq`,
     `userid`=T2.`popuser`,
     `userpass`=T2.`poppasswd`;

-- Transfer alert email configuration
INSERT INTO `%TABLE_PREFIX%email` (`created`, `updated`, `priority_id`,
    `dept_id`, `name`, `email`)
    SELECT NOW(), NOW(), 2, COALESCE(`default_dept_id`, 1), 'osTicket Alerts',
        `alert_email`
    FROM `%TABLE_PREFIX%config` WHERE `id`=1;

UPDATE `%TABLE_PREFIX%config` SET `alert_email_id` = last_insert_id()
    WHERE id=1;

ALTER TABLE `%TABLE_PREFIX%department`
    ADD `autoresp_email_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `email_id`,
    ADD `tpl_id` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `dept_id`,
    ADD INDEX ( `tpl_id` ),
    ADD INDEX ( `autoresp_email_id` ) ;

-- Transfer no-reply email configuration
INSERT INTO `%TABLE_PREFIX%email` (`created`, `updated`, `priority_id`,
    `dept_id`, `name`, `email`)
    SELECT NOW(), NOW(), 2, COALESCE(`default_dept_id`, 1), 'No Reply',
        `noreply_email`
    FROM `%TABLE_PREFIX%config` WHERE `id`=1;

UPDATE `%TABLE_PREFIX%department` SET `autoresp_email_id` = last_insert_id()
    WHERE noreply_autoresp=1;

ALTER TABLE `%TABLE_PREFIX%groups` ADD `can_edit_tickets` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `dept_access` ;

UPDATE `%TABLE_PREFIX%groups`  SET `can_edit_tickets`=1 WHERE `can_delete_tickets`=1;

ALTER TABLE `%TABLE_PREFIX%ticket`
    ADD `phone_ext` VARCHAR( 8 ) NULL DEFAULT NULL AFTER `phone`,
    ADD `topic`  VARCHAR(64) NULL DEFAULT NULL AFTER `subject`,
    ADD `duedate` DATETIME NULL AFTER `isoverdue`,
    ADD `isanswered` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `isoverdue`,
    ADD `lastmessage` DATETIME NULL AFTER `closed`,
    ADD `lastresponse` DATETIME NULL AFTER `lastmessage`,
    ADD INDEX ( `duedate` ) ;

ALTER TABLE `%TABLE_PREFIX%ticket`
    CHANGE `source` `source` ENUM( 'Web', 'Email', 'Phone', 'Other' ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Other' ;

ALTER TABLE `%TABLE_PREFIX%email_template`
    ADD `note_alert_subj` VARCHAR( 255 ) NOT NULL AFTER `message_alert_body` ,
    ADD `note_alert_body` TEXT NOT NULL AFTER `note_alert_subj`,
    ADD `notes` TEXT NULL AFTER `name`;

UPDATE `%TABLE_PREFIX%email_template`  SET  `note_alert_subj` = 'New Internal Note Alert',
       `note_alert_body` = '%staff,\r\n\r\nInternal note appended to ticket #%ticket\r\n\r\n----------------------\r\nName: %name\r\n\r\n%note\r\n-------------------\r\n\r\nTo view/respond to the ticket, please login to the support ticket system.\r\n\r\nYour friendly,\r\n\r\nCustomer Support System - powered by osTicket.';

-- Update path and variables on email templates
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, 'view.php', 'ticket.php'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, 'view.php', 'ticket.php'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, 'view.php', 'ticket.php'),
        `ticket_reply_body` = REPLACE(
                REPLACE(`ticket_reply_body`, 'view.php', 'ticket.php'),
            '%message', '%response');

ALTER TABLE `%TABLE_PREFIX%ticket_message`
    ADD `messageId` VARCHAR( 255 ) NULL AFTER `ticket_id`,
    ADD INDEX ( `messageId` ) ;

DROP TABLE IF EXISTS `%TABLE_PREFIX%api_key`;
CREATE TABLE `%TABLE_PREFIX%api_key` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `isactive` tinyint(1) NOT NULL default '1',
  `ipaddr` varchar(16) NOT NULL,
  `apikey` varchar(255) NOT NULL,
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ipaddr` (`ipaddr`)
) DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `%TABLE_PREFIX%syslog`;
CREATE TABLE `%TABLE_PREFIX%syslog` (
  `log_id` int(11) unsigned NOT NULL auto_increment,
  `log_type` enum('Debug','Warning','Error') NOT NULL,
  `title` varchar(255) NOT NULL,
  `log` text NOT NULL,
  `logger` varchar(64) NOT NULL,
  `ip_address` varchar(16) NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `updated` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`log_id`),
  KEY `log_type` (`log_type`)
) DEFAULT CHARSET=utf8;

UPDATE `%TABLE_PREFIX%config`
    SET `ostversion`='1.6 RC5';

[+] ..
[-] 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]