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

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

/**
 * @version v1.7.1
 * @signature 852ca89e1440e736d763b3b87f039bd7
 *
 *  - Changes config table to be key/value based and allows for
 *    configuration key clobbering by defining a namespace for the keys. The
 *    current configuration settings are stored in the 'core' namespace
 */

DROP TABLE IF EXISTS `%TABLE_PREFIX%_config`;
CREATE TABLE `%TABLE_PREFIX%_config` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `namespace` varchar(64) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` text NOT NULL,
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY (`namespace`, `key`)
) DEFAULT CHARSET=utf8;

INSERT INTO `%TABLE_PREFIX%_config` (`key`, `value`, `namespace`) VALUES
  ('isonline', (SELECT `isonline` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_daylight_saving', (SELECT `enable_daylight_saving` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('staff_ip_binding', (SELECT `staff_ip_binding` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('staff_max_logins', (SELECT `staff_max_logins` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('staff_login_timeout', (SELECT `staff_login_timeout` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('staff_session_timeout', (SELECT `staff_session_timeout` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('passwd_reset_period', (SELECT `passwd_reset_period` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('client_max_logins', (SELECT `client_max_logins` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('client_login_timeout', (SELECT `client_login_timeout` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('client_session_timeout', (SELECT `client_session_timeout` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('max_page_size', (SELECT `max_page_size` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('max_open_tickets', (SELECT `max_open_tickets` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('max_file_size', (SELECT `max_file_size` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('max_user_file_uploads', (SELECT `max_user_file_uploads` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('max_staff_file_uploads', (SELECT `max_staff_file_uploads` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('autolock_minutes', (SELECT `autolock_minutes` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overdue_grace_period', (SELECT `overdue_grace_period` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('alert_email_id', (SELECT `alert_email_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_email_id', (SELECT `default_email_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_dept_id', (SELECT `default_dept_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_sla_id', (SELECT `default_sla_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_priority_id', (SELECT `default_priority_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_template_id', (SELECT `default_template_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_timezone_id', (SELECT `default_timezone_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('default_smtp_id', (SELECT `default_smtp_id` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_email_spoofing', (SELECT `allow_email_spoofing` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('clickable_urls', (SELECT `clickable_urls` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_priority_change', (SELECT `allow_priority_change` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('use_email_priority', (SELECT `use_email_priority` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_kb', (SELECT `enable_kb` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_premade', (SELECT `enable_premade` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_captcha', (SELECT `enable_captcha` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_auto_cron', (SELECT `enable_auto_cron` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('enable_mail_polling', (SELECT `enable_mail_polling` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('send_sys_errors', (SELECT `send_sys_errors` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('send_sql_errors', (SELECT `send_sql_errors` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('send_mailparse_errors', (SELECT `send_mailparse_errors` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('send_login_errors', (SELECT `send_login_errors` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('save_email_headers', (SELECT `save_email_headers` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('strip_quoted_reply', (SELECT `strip_quoted_reply` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('log_ticket_activity', (SELECT `log_ticket_activity` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_autoresponder', (SELECT `ticket_autoresponder` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('message_autoresponder', (SELECT `message_autoresponder` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_notice_active', (SELECT `ticket_notice_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_alert_active', (SELECT `ticket_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_alert_admin', (SELECT `ticket_alert_admin` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_alert_dept_manager', (SELECT `ticket_alert_dept_manager` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('ticket_alert_dept_members', (SELECT `ticket_alert_dept_members` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('message_alert_active', (SELECT `message_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('message_alert_laststaff', (SELECT `message_alert_laststaff` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('message_alert_assigned', (SELECT `message_alert_assigned` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('message_alert_dept_manager', (SELECT `message_alert_dept_manager` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('note_alert_active', (SELECT `note_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('note_alert_laststaff', (SELECT `note_alert_laststaff` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('note_alert_assigned', (SELECT `note_alert_assigned` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('note_alert_dept_manager', (SELECT `note_alert_dept_manager` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('transfer_alert_active', (SELECT `transfer_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('transfer_alert_assigned', (SELECT `transfer_alert_assigned` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('transfer_alert_dept_manager', (SELECT `transfer_alert_dept_manager` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('transfer_alert_dept_members', (SELECT `transfer_alert_dept_members` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overdue_alert_active', (SELECT `overdue_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overdue_alert_assigned', (SELECT `overdue_alert_assigned` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overdue_alert_dept_manager', (SELECT `overdue_alert_dept_manager` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overdue_alert_dept_members', (SELECT `overdue_alert_dept_members` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('assigned_alert_active', (SELECT `assigned_alert_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('assigned_alert_staff', (SELECT `assigned_alert_staff` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('assigned_alert_team_lead', (SELECT `assigned_alert_team_lead` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('assigned_alert_team_members', (SELECT `assigned_alert_team_members` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('auto_assign_reopened_tickets', (SELECT `auto_assign_reopened_tickets` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('show_related_tickets', (SELECT `show_related_tickets` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('show_assigned_tickets', (SELECT `show_assigned_tickets` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('show_answered_tickets', (SELECT `show_answered_tickets` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('show_notes_inline', (SELECT `show_notes_inline` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('hide_staff_name', (SELECT `hide_staff_name` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('overlimit_notice_active', (SELECT `overlimit_notice_active` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('email_attachments', (SELECT `email_attachments` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_attachments', (SELECT `allow_attachments` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_email_attachments', (SELECT `allow_email_attachments` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_online_attachments', (SELECT `allow_online_attachments` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allow_online_attachments_onlogin', (SELECT `allow_online_attachments_onlogin` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('random_ticket_ids', (SELECT `random_ticket_ids` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('log_level', (SELECT `log_level` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('log_graceperiod', (SELECT `log_graceperiod` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('upload_dir', (SELECT `upload_dir` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('allowed_filetypes', (SELECT `allowed_filetypes` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('time_format', (SELECT `time_format` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('date_format', (SELECT `date_format` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('datetime_format', (SELECT `datetime_format` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('daydatetime_format', (SELECT `daydatetime_format` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('reply_separator', (SELECT `reply_separator` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('admin_email', (SELECT `admin_email` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('helpdesk_title', (SELECT `helpdesk_title` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('helpdesk_url', (SELECT `helpdesk_url` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core')
, ('schema_signature', (SELECT `schema_signature` FROM `%TABLE_PREFIX%config` WHERE `id` = 1), 'core');

DROP TABLE `%TABLE_PREFIX%config`;
ALTER TABLE `%TABLE_PREFIX%_config` RENAME TO `%TABLE_PREFIX%config`;

-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
    SET `value` = '852ca89e1440e736d763b3b87f039bd7'
	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]