Skip to content
Snippets Groups Projects
60fcbee1-f8856d56.patch.sql 443 B
Newer Older
  • Learn to ignore specific revisions
  • ALTER TABLE `%TABLE_PREFIX%history`
        ADD `staff_id` int(11) unsigned NOT NULL AFTER `ticket_id`,
        ADD `team_id` int(11) unsigned NOT NULL AFTER `staff_id`,
        ADD `dept_id` int(11) unsigned NOT NULL AFTER `team_id`,
        ADD `topic_id` int(11) unsigned NOT NULL AFTER `dept_id`;
    
    RENAME TABLE `%TABLE_PREFIX%history` TO `%TABLE_PREFIX%event`;
    
    UPDATE `%TABLE_PREFIX%config`
        SET `schema_signature`='f8856d56e51c5cc3416389de78b54515';