MokoSuiteBackup/source/packages/com_mokosuitebackup/sql/updates/mysql/02.52.25.sql

-- Remove legacy single-remote storage columns (superseded by #__mokosuitebackup_remotes).
-- Plain DROP COLUMN (no IF EXISTS): all columns are created by install.mysql.sql and
-- earlier updates, so they always exist here. `DROP COLUMN IF EXISTS` is a MariaDB-only
-- extension and errors on Oracle MySQL 8.x, which Joomla also supports.
ALTER TABLE `#__mokosuitebackup_profiles`
  DROP COLUMN `remote_storage`,
  DROP COLUMN `ftp_host`,
  DROP COLUMN `ftp_port`,
  DROP COLUMN `ftp_username`,
  DROP COLUMN `ftp_password`,
  DROP COLUMN `ftp_path`,
  DROP COLUMN `ftp_passive`,
  DROP COLUMN `ftp_ssl`,
  DROP COLUMN `sftp_host`,
  DROP COLUMN `sftp_port`,
  DROP COLUMN `sftp_username`,
  DROP COLUMN `sftp_auth_type`,
  DROP COLUMN `sftp_password`,
  DROP COLUMN `sftp_key_data`,
  DROP COLUMN `sftp_passphrase`,
  DROP COLUMN `sftp_path`,
  DROP COLUMN `gdrive_client_id`,
  DROP COLUMN `gdrive_client_secret`,
  DROP COLUMN `gdrive_refresh_token`,
  DROP COLUMN `gdrive_folder_id`,
  DROP COLUMN `s3_endpoint`,
  DROP COLUMN `s3_region`,
  DROP COLUMN `s3_access_key`,
  DROP COLUMN `s3_secret_key`,
  DROP COLUMN `s3_bucket`,
  DROP COLUMN `s3_path`;