text: SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND column_name = 'RemoteId'
      ) > 0,
      'ALTER TABLE FileInfo DROP COLUMN RemoteId;',
      'SELECT 1'
  ));
  
  PREPARE alterIfExists FROM @preparedStatement;
  EXECUTE alterIfExists;
  DEALLOCATE PREPARE alterIfExists;
  
  SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND index_name = 'idx_fileinfo_content_txt'
      ) > 0,
      'DROP INDEX idx_fileinfo_content_txt ON FileInfo;',
      'SELECT 1'
  ));
  
  PREPARE removeIndexIfExists FROM @preparedStatement;
  EXECUTE removeIndexIfExists;
  DEALLOCATE PREPARE removeIndexIfExists;
  
  SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND column_name = 'Content'
      ) > 0,
      'ALTER TABLE FileInfo DROP COLUMN Content;',
      'SELECT 1'
  ));
  
  PREPARE alterIfExists FROM @preparedStatement;
  EXECUTE alterIfExists;
  DEALLOCATE PREPARE alterIfExists;
  
  SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND column_name = 'MiniPreview'
      ) > 0,
      'ALTER TABLE FileInfo DROP COLUMN MiniPreview;',
      'SELECT 1'
  ));
  
  PREPARE alterIfExists FROM @preparedStatement;
  EXECUTE alterIfExists;
  DEALLOCATE PREPARE alterIfExists;
  
  SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND index_name = 'idx_fileinfo_name_txt'
      ) > 0,
      'DROP INDEX idx_fileinfo_name_txt ON FileInfo;',
      'SELECT 1'
  ));
  
  PREPARE removeIndexIfExists FROM @preparedStatement;
  EXECUTE removeIndexIfExists;
  DEALLOCATE PREPARE removeIndexIfExists;
  
  SET @preparedStatement = (SELECT IF(
      (
          SELECT COUNT(*) FROM INFORMATION_SCHEMA.STATISTICS
          WHERE table_name = 'FileInfo'
          AND table_schema = DATABASE()
          AND index_name = 'idx_fileinfo_extension_at'
      ) > 0,
      'DROP INDEX idx_fileinfo_extension_at ON FileInfo;',
      'SELECT 1'
  ));
  
  PREPARE removeIndexIfExists FROM @preparedStatement;
  EXECUTE removeIndexIfExists;
  DEALLOCATE PREPARE removeIndexIfExists;
  
  DROP TABLE IF EXISTS FileInfo;
  