v1.7-cleanup-mysql.sql

-- Drop fields we no longer need in the reference table.
ALTER TABLE `%TABLE_PREFIX%ticket_attachment`
    DROP `file_size`,
    DROP `file_name`,
    DROP `file_key`,
    DROP `updated`,
    DROP `isdeleted`;

-- Drop fields we no longer need in config table.
ALTER TABLE `%TABLE_PREFIX%config`
    DROP `api_passphrase`;

-- Drop fields we no longer need in staff table.
ALTER TABLE `%TABLE_PREFIX%staff`
    DROP `append_signature`,
    DROP `timezone_offset`;

-- Drop fields we no longer need in department table.
ALTER TABLE `%TABLE_PREFIX%department`
    DROP `can_append_signature`;

-- Banlist table has been migrated to the email_filter_rule table
DROP TABLE `%TABLE_PREFIX%email_banlist`;