vendor/pimcore/pimcore/bundles/CoreBundle/Migrations/Version20210324152822.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;
  22. use Pimcore\Db;
  24. /**
  25.  * @internal
  26.  */
  27. final class Version20210324152822 extends AbstractMigration
  28. {
  29.     /**
  30.      * @param Schema $schema
  31.      */
  32.     public function up(Schema $schema): void
  33.     {
  34.         $db = Db::get();
  36.         $translationsTables = $db->fetchAllAssociative("SHOW FULL TABLES WHERE `Tables_in_{$db->getDatabase()}` LIKE 'translations\_%' AND Table_type = 'BASE TABLE'");
  37.         foreach ($translationsTables as $table) {
  38.             $translationsTable = current($table);
  40.             $translationsTableSchema = $schema->getTable($translationsTable);
  42.             if ($translationsTableSchema->hasColumn('key')
  43.                 && $translationsTableSchema->hasColumn('language')
  44.                 && $translationsTableSchema->hasColumn('text')
  45.                 && !$translationsTableSchema->hasColumn('type')) {
  46.                 $this->addSql('ALTER TABLE `'.$translationsTable.'` ADD COLUMN `type` varchar(10) DEFAULT NULL AFTER `key`');
  47.             }
  48.         }
  49.     }
  51.     /**
  52.      * @param Schema $schema
  53.      */
  54.     public function down(Schema $schema): void
  55.     {
  56.         $db = Db::get();
  58.         $translationsTables = $db->fetchAllAssociative("SHOW FULL TABLES WHERE `Tables_in_{$db->getDatabase()}` LIKE 'translations\_%' AND Table_type = 'BASE TABLE'");
  59.         foreach ($translationsTables as $table) {
  60.             $translationsTable = current($table);
  62.             $translationsTableSchema = $schema->getTable($translationsTable);
  64.             if ($translationsTableSchema->hasColumn('key')
  65.                 && $translationsTableSchema->hasColumn('language')
  66.                 && $translationsTableSchema->hasColumn('text')
  67.                 && $translationsTableSchema->hasColumn('type')) {
  68.                 $this->addSql('ALTER TABLE `'.$translationsTable.'` DROP COLUMN `type`');
  69.             }
  70.         }
  71.     }
  72. }