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

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

/*
 * @version=1.7RC2+
 * 
 * change variable names
 */

-- Canned Responses (with variables)
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%id', '%{ticket.id}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%ticket', '%{ticket.number}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%name', '%{ticket.name}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%email', '%{ticket.email}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%subject', '%{ticket.subject}');

UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%status', '%{ticket.status}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%priority', '%{ticket.priority}');

UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%auth', '%{ticket.auth_token}');

UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%phone', '%{ticket.phone_number}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%createdate', '%{ticket.create_date}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%duedate', '%{ticket.due_date}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%closedate', '%{ticket.close_date}');

UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%topic', '%{ticket.topic.name}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%dept', '%{ticket.dept.name}');
UPDATE `%TABLE_PREFIX%canned_response` SET `response` = REPLACE(`response`, '%team', '%{ticket.team.name}');

-- %id
UPDATE `%TABLE_PREFIX%email_template` 
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%id', '%{ticket.id}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%id', '%{ticket.id}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%id', '%{ticket.id}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%id', '%{ticket.id}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%id', '%{ticket.id}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%id', '%{ticket.id}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%id', '%{ticket.id}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%id', '%{ticket.id}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%id', '%{ticket.id}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%id', '%{ticket.id}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%id', '%{ticket.id}');

-- %ticket
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%ticket', '%{ticket.number}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%ticket', '%{ticket.number}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%ticket', '%{ticket.number}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%ticket', '%{ticket.number}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%ticket', '%{ticket.number}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%ticket', '%{ticket.number}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%ticket', '%{ticket.number}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%ticket', '%{ticket.number}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%ticket', '%{ticket.number}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%ticket', '%{ticket.number}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%ticket', '%{ticket.number}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%ticket', '%{ticket.number}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%ticket', '%{ticket.number}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%ticket', '%{ticket.number}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%ticket', '%{ticket.number}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%ticket', '%{ticket.number}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%ticket', '%{ticket.number}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%ticket', '%{ticket.number}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%ticket', '%{ticket.number}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%ticket', '%{ticket.number}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%ticket', '%{ticket.number}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%ticket', '%{ticket.number}');

-- %subject
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%subject', '%{ticket.subject}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%subject', '%{ticket.subject}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%subject', '%{ticket.subject}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%subject', '%{ticket.subject}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%subject', '%{ticket.subject}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%subject', '%{ticket.subject}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%subject', '%{ticket.subject}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%subject', '%{ticket.subject}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%subject', '%{ticket.subject}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%subject', '%{ticket.subject}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%subject', '%{ticket.subject}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%subject', '%{ticket.subject}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%subject', '%{ticket.subject}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%subject', '%{ticket.subject}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%subject', '%{ticket.subject}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%subject', '%{ticket.subject}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%subject', '%{ticket.subject}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%subject', '%{ticket.subject}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%subject', '%{ticket.subject}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%subject', '%{ticket.subject}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%subject', '%{ticket.subject}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%subject', '%{ticket.subject}');

-- %name
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%name', '%{ticket.name}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%name', '%{ticket.name}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%name', '%{ticket.name}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%name', '%{ticket.name}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%name', '%{ticket.name}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%name', '%{ticket.name}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%name', '%{ticket.name}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%name', '%{ticket.name}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%name', '%{ticket.name}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%name', '%{ticket.name}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%name', '%{ticket.name}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%name', '%{ticket.name}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%name', '%{ticket.name}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%name', '%{ticket.name}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%name', '%{ticket.name}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%name', '%{ticket.name}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%name', '%{ticket.name}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%name', '%{ticket.name}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%name', '%{ticket.name}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%name', '%{ticket.name}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%name', '%{ticket.name}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%name', '%{ticket.name}');

-- %email
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%email', '%{ticket.email}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%email', '%{ticket.email}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%email', '%{ticket.email}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%email', '%{ticket.email}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%email', '%{ticket.email}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%email', '%{ticket.email}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%email', '%{ticket.email}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%email', '%{ticket.email}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%email', '%{ticket.email}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%email', '%{ticket.email}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%email', '%{ticket.email}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%email', '%{ticket.email}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%email', '%{ticket.email}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%email', '%{ticket.email}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%email', '%{ticket.email}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%email', '%{ticket.email}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%email', '%{ticket.email}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%email', '%{ticket.email}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%email', '%{ticket.email}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%email', '%{ticket.email}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%email', '%{ticket.email}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%email', '%{ticket.email}');

-- %status
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%status', '%{ticket.status}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%status', '%{ticket.status}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%status', '%{ticket.status}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%status', '%{ticket.status}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%status', '%{ticket.status}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%status', '%{ticket.status}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%status', '%{ticket.status}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%status', '%{ticket.status}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%status', '%{ticket.status}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%status', '%{ticket.status}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%status', '%{ticket.status}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%status', '%{ticket.status}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%status', '%{ticket.status}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%status', '%{ticket.status}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%status', '%{ticket.status}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%status', '%{ticket.status}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%status', '%{ticket.status}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%status', '%{ticket.status}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%status', '%{ticket.status}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%status', '%{ticket.status}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%status', '%{ticket.status}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%status', '%{ticket.status}');

-- %priority
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_subj` = REPLACE(`ticket_autoresp_subj`, '%priority', '%{ticket.priority}'),
        `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%priority', '%{ticket.priority}'),
        `message_autoresp_subj` = REPLACE(`message_autoresp_subj`, '%priority', '%{ticket.priority}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%priority', '%{ticket.priority}'),
        `ticket_notice_subj` = REPLACE(`ticket_notice_subj`, '%priority', '%{ticket.priority}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%priority', '%{ticket.priority}'),
        `ticket_overlimit_subj` = REPLACE(`ticket_overlimit_subj`, '%priority', '%{ticket.priority}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%priority', '%{ticket.priority}'),
        `ticket_reply_subj` = REPLACE(`ticket_reply_subj`, '%priority', '%{ticket.priority}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%priority', '%{ticket.priority}'),
        `ticket_alert_subj` = REPLACE(`ticket_alert_subj`, '%priority', '%{ticket.priority}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%priority', '%{ticket.priority}'),
        `message_alert_subj` = REPLACE(`message_alert_subj`, '%priority', '%{ticket.priority}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%priority', '%{ticket.priority}'),
        `note_alert_subj` = REPLACE(`note_alert_subj`, '%priority', '%{ticket.priority}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%priority', '%{ticket.priority}'),
        `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%priority', '%{ticket.priority}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%priority', '%{ticket.priority}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%priority', '%{ticket.priority}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%priority', '%{ticket.priority}'),
        `ticket_overdue_subj` = REPLACE(`ticket_overdue_subj`, '%priority', '%{ticket.priority}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%priority', '%{ticket.priority}');

-- %auth
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%auth', '%{ticket.auth_code}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%auth', '%{ticket.auth_code}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%auth', '%{ticket.auth_code}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%auth', '%{ticket.auth_code}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%auth', '%{ticket.auth_code}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%auth', '%{ticket.auth_code}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%auth', '%{ticket.auth_code}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%auth', '%{ticket.auth_code}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%auth', '%{ticket.auth_code}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%auth', '%{ticket.auth_code}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%auth', '%{ticket.auth_code}');

-- %phone
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%phone', '%{ticket.phone_number}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%phone', '%{ticket.phone_number}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%phone', '%{ticket.phone_number}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%phone', '%{ticket.phone_number}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%phone', '%{ticket.phone_number}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%phone', '%{ticket.phone_number}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%phone', '%{ticket.phone_number}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%phone', '%{ticket.phone_number}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%phone', '%{ticket.phone_number}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%phone', '%{ticket.phone_number}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%phone', '%{ticket.phone_number}');

-- %createdate
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%createdate', '%{ticket.create_date}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%createdate', '%{ticket.create_date}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%createdate', '%{ticket.create_date}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%createdate', '%{ticket.create_date}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%createdate', '%{ticket.create_date}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%createdate', '%{ticket.create_date}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%createdate', '%{ticket.create_date}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%createdate', '%{ticket.create_date}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%createdate', '%{ticket.create_date}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%createdate', '%{ticket.create_date}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%createdate', '%{ticket.create_date}');

-- %duedate
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%duedate', '%{ticket.due_date}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%duedate', '%{ticket.due_date}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%duedate', '%{ticket.due_date}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%duedate', '%{ticket.due_date}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%duedate', '%{ticket.due_date}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%duedate', '%{ticket.due_date}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%duedate', '%{ticket.due_date}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%duedate', '%{ticket.due_date}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%duedate', '%{ticket.due_date}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%duedate', '%{ticket.due_date}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%duedate', '%{ticket.due_date}');

-- %closedate
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%closedate', '%{ticket.close_date}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%closedate', '%{ticket.close_date}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%closedate', '%{ticket.close_date}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%closedate', '%{ticket.close_date}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%closedate', '%{ticket.close_date}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%closedate', '%{ticket.close_date}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%closedate', '%{ticket.close_date}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%closedate', '%{ticket.close_date}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%closedate', '%{ticket.close_date}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%closedate', '%{ticket.close_date}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%closedate', '%{ticket.close_date}');

-- %topic
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%topic', '%{ticket.topic.name}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%topic', '%{ticket.topic.name}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%topic', '%{ticket.topic.name}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%topic', '%{ticket.topic.name}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%topic', '%{ticket.topic.name}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%topic', '%{ticket.topic.name}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%topic', '%{ticket.topic.name}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%topic', '%{ticket.topic.name}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%topic', '%{ticket.topic.name}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%topic', '%{ticket.topic.name}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%topic', '%{ticket.topic.name}');

-- %dept
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%dept', '%{ticket.dept.name}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%dept', '%{ticket.dept.name}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%dept', '%{ticket.dept.name}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%dept', '%{ticket.dept.name}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%dept', '%{ticket.dept.name}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%dept', '%{ticket.dept.name}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%dept', '%{ticket.dept.name}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%dept', '%{ticket.dept.name}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%dept', '%{ticket.dept.name}'),
        `transfer_alert_subj` = REPLACE(`transfer_alert_subj`, '%dept', '%{ticket.dept.name}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%dept', '%{ticket.dept.name}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%dept', '%{ticket.dept.name}');

-- %team
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%team', '%{ticket.team.name}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%team', '%{ticket.team.name}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%team', '%{ticket.team.name}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%team', '%{ticket.team.name}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%team', '%{ticket.team.name}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%team', '%{ticket.team.name}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%team', '%{ticket.team.name}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%team', '%{ticket.team.name}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%team', '%{ticket.team.name}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%team', '%{ticket.team.name}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%team', '%{ticket.team.name}');

-- %clientlink
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%clientlink', '%{ticket.client_link}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%clientlink', '%{ticket.client_link}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%clientlink', '%{ticket.client_link}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%clientlink', '%{ticket.client_link}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%clientlink', '%{ticket.client_link}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%clientlink', '%{ticket.client_link}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%clientlink', '%{ticket.client_link}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%clientlink', '%{ticket.client_link}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%clientlink', '%{ticket.client_link}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%clientlink', '%{ticket.client_link}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%clientlink', '%{ticket.client_link}');

-- %staff (recipient of the alert)
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%staff', '%{recipient}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%staff', '%{recipient}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%staff', '%{recipient}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%staff', '%{recipient}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%staff', '%{recipient}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%staff', '%{recipient}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%staff', '%{recipient}');

-- %message 
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%message', '%{message}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%message', '%{message}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%message', '%{message}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%message', '%{message}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%message', '%{message}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%message', '%{message}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%message', '%{message}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%message', '%{message}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%message', '%{message}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%message', '%{message}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%message', '%{message}');

-- %response
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%response', '%{response}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%response', '%{response}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%response', '%{response}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%response', '%{response}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%response', '%{response}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%response', '%{response}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%response', '%{response}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%response', '%{response}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%response', '%{response}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%response', '%{response}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%response', '%{response}');

-- %note 
UPDATE `%TABLE_PREFIX%email_template`
    SET `note_alert_body` = REPLACE(`note_alert_body`, '%note', '* %{note.title} *\r\n\r\n%{note.message}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%note', '%{comments}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%note', '%{comments}');

-- %{note} (dev branch installations)
UPDATE `%TABLE_PREFIX%email_template`
    SET `note_alert_body` = REPLACE(`note_alert_body`, '%{note}', '%{note.message}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%{note}', '%{comments}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%{note}', '%{comments}');

-- %{title} (dev branch installations)
UPDATE `%TABLE_PREFIX%email_template`
    SET `note_alert_body` = REPLACE(`note_alert_body`, '%{title}', '* %{note.title} *\r\n');

-- %url
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%url', '%{url}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%url', '%{url}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%url', '%{url}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%url', '%{url}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%url', '%{url}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%url', '%{url}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%url', '%{url}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%url', '%{url}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%url', '%{url}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%url', '%{url}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%url', '%{url}');

-- %signature
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%signature', '%{signature}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%signature', '%{signature}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%signature', '%{signature}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%signature', '%{signature}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%signature', '%{signature}'),
        `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%signature', '%{signature}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%signature', '%{signature}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%signature', '%{signature}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%signature', '%{signature}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%signature', '%{signature}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%signature', '%{signature}');

-- %assignee
UPDATE `%TABLE_PREFIX%email_template`
    SET `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%assignee', '%{assignee}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%assignee', '%{assignee}');

-- %assigner
UPDATE `%TABLE_PREFIX%email_template`
    SET `assigned_alert_subj` = REPLACE(`assigned_alert_subj`, '%assigner', '%{assigner}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%assigner', '%{assigner}');

/* Change links */

-- Client URL -> %{url}/view.php?e=%{ticket.email}&t=%{ticket.number}
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_autoresp_body` = REPLACE(`ticket_autoresp_body`, '%{url}/view.php?e=%{ticket.email}&t=%{ticket.number}', '%{ticket.client_link}'),
        `message_autoresp_body` = REPLACE(`message_autoresp_body`, '%{url}/view.php?e=%{ticket.email}&t=%{ticket.number}', '%{ticket.client_link}'),
        `ticket_notice_body` = REPLACE(`ticket_notice_body`, '%{url}/view.php?e=%{ticket.email}&t=%{ticket.number}', '%{ticket.client_link}'),
        `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%{url}/view.php?e=%{ticket.email}&t=%{ticket.number}', '%{ticket.client_link}'),
        `ticket_reply_body` = REPLACE(`ticket_reply_body`, '%{url}/view.php?e=%{ticket.email}&t=%{ticket.number}', '%{ticket.client_link}');

-- Client URL -> %{url}/view.php?e=%{ticket.email} (overlimit template)
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_overlimit_body` = REPLACE(`ticket_overlimit_body`, '%{url}/view.php?e=%{ticket.email}', '%{url}/tickets.php?e=%{ticket.email}');

-- Staff URL -> %{url}/scp/ticket.php?id=%{ticket.id} (should be tickets.php)
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%{url}/scp/ticket.php?id=%{ticket.id}', '%{ticket.staff_link}');

-- Staff URL 2 -> %{url}/scp/tickets.php?id=%{ticket.id}
UPDATE `%TABLE_PREFIX%email_template`
    SET `ticket_alert_body` = REPLACE(`ticket_alert_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `message_alert_body` = REPLACE(`message_alert_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `note_alert_body` = REPLACE(`note_alert_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `assigned_alert_body` = REPLACE(`assigned_alert_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `transfer_alert_body` = REPLACE(`transfer_alert_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}'),
        `ticket_overdue_body` = REPLACE(`ticket_overdue_body`, '%{url}/scp/tickets.php?id=%{ticket.id}', '%{ticket.staff_link}');

-- update schema signature
UPDATE `%TABLE_PREFIX%config`
    SET `schema_signature`='f4da0c9befa257b5a20a923d4e9c0e91';

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