-
Jared Hancock authored
When the `ostversion` column is removed from the %config table, the system will immediately switch to database-backed sessions. Because the administrator upgrading the system originally logged in with a file-based session, it must be migrated to the database before removing the column.
Jared Hancock authoredWhen the `ostversion` column is removed from the %config table, the system will immediately switch to database-backed sessions. Because the administrator upgrading the system originally logged in with a file-based session, it must be migrated to the database before removing the column.
c00511c7-7be60a84.cleanup.sql 820 B
-- Drop columns we nolonger need - (must be at the very bottom or after session table is created)
ALTER TABLE `%TABLE_PREFIX%config`
DROP COLUMN `ostversion`,
DROP COLUMN `timezone_offset`,
DROP COLUMN `api_passphrase`;
-- 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 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`;