public function down(Schema $schema)
{
$this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
$this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail ADD maximumwidth INT DEFAULT NULL, ADD maximumheight INT DEFAULT NULL, ADD ratiomode VARCHAR(255) NOT NULL COLLATE utf8_unicode_ci, ADD allowupscaling TINYINT(1) DEFAULT NULL");
$thumbnailResult = $this->connection->executeQuery('SELECT * FROM typo3_media_domain_model_thumbnail');
while ($thumbnailInfo = $thumbnailResult->fetch(\PDO::FETCH_ASSOC)) {
$configuration = json_decode($thumbnailInfo['configuration'], true);
$maximumWidth = isset($configuration['maximumWidth']) ? (int) $configuration['maximumWidth'] : null;
$maximumWidth = $maximumWidth === 0 ? null : $maximumWidth;
$maximumHeight = isset($configuration['maximumHeight']) ? (int) $configuration['maximumHeight'] : null;
$maximumHeight = $maximumHeight === 0 ? null : $maximumHeight;
$ratioMode = isset($configuration['ratioMode']) ? $configuration['ratioMode'] : null;
$allowUpScaling = isset($configuration['allowUpScaling']) ? $configuration['allowUpScaling'] : null;
$allowUpScaling = $allowUpScaling ? 1 : 0;
$types = [\PDO::PARAM_NULL];
$this->addSql("UPDATE typo3_media_domain_model_thumbnail SET maximumwidth = ?, maximumheight = ?, ratiomode = ?, allowupscaling = ? WHERE persistence_object_identifier = ?", [$maximumWidth, $maximumHeight, $ratioMode, $allowUpScaling, $thumbnailInfo['persistence_object_identifier']], $types);
}
$this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail DROP INDEX originalasset_configurationhash");
$this->addSql("ALTER TABLE typo3_media_domain_model_thumbnail DROP configuration, DROP configurationhash");
}