vendor/pimcore/pimcore/bundles/CoreBundle/Migrations/Version22020614115124.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. /**
  6.  * Pimcore
  7.  *
  8.  * This source file is available under two different licenses:
  9.  * - GNU General Public License version 3 (GPLv3)
  10.  * - Pimcore Commercial License (PCL)
  11.  * Full copyright and license information is available in
  12.  * LICENSE.md which is distributed with this source code.
  13.  *
  14.  *  @copyright  Copyright (c) Pimcore GmbH (http://www.pimcore.org)
  15.  *  @license    http://www.pimcore.org/license     GPLv3 and PCL
  16.  */
  18. namespace Pimcore\Bundle\CoreBundle\Migrations;
  20. use Doctrine\DBAL\Schema\Schema;
  21. use Doctrine\Migrations\AbstractMigration;
  23. final class Version22020614115124 extends AbstractMigration
  24. {
  25.     public function getDescription(): string
  26.     {
  27.         return 'Add filesize, width and height to assets_image_thumbnail_cache';
  28.     }
  30.     public function up(Schema $schema): void
  31.     {
  32.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('filesize')) {
  33.             $this->addSql(
  34.                 'ALTER TABLE `assets_image_thumbnail_cache`
  35.                 ADD COLUMN `filesize` INT UNSIGNED
  36.             ;'
  37.             );
  38.         }
  39.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('width')) {
  40.             $this->addSql(
  41.                 'ALTER TABLE `assets_image_thumbnail_cache`
  42.                 ADD COLUMN `width` SMALLINT UNSIGNED
  43.             ;'
  44.             );
  45.         }
  46.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('height')) {
  47.             $this->addSql(
  48.                 'ALTER TABLE `assets_image_thumbnail_cache`
  49.                 ADD COLUMN `height` SMALLINT UNSIGNED
  50.             ;'
  51.             );
  52.         }
  53.     }
  55.     public function down(Schema $schema): void
  56.     {
  57.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('filesize')) {
  58.             $this->addSql(
  59.                 'ALTER TABLE `assets_image_thumbnail_cache`
  60.                 DROP COLUMN `filesize`
  61.             ;'
  62.             );
  63.         }
  64.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('width')) {
  65.             $this->addSql(
  66.                 'ALTER TABLE `assets_image_thumbnail_cache`
  67.                 DROP COLUMN `width`
  68.             ;'
  69.             );
  70.         }
  71.         if (!$schema->getTable('assets_image_thumbnail_cache')->hasColumn('height')) {
  72.             $this->addSql(
  73.                 'ALTER TABLE `assets_image_thumbnail_cache`
  74.                 DROP COLUMN `height`
  75.             ;'
  76.             );
  77.         }
  78.     }
  79. }