migrations/Version20210715095436.php line 1
<?php
namespace DoctrineMigrations;
use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;
/**
* Auto-generated Migration: Please modify to your needs!
*/
class Version20210715095436 extends AbstractMigration
{
/**
* @param Schema $schema
*/
public function up(Schema $schema) : void
{
// this up() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE media ADD COLUMN media_flag SMALLINT DEFAULT NULL');
$this->addSql('UPDATE media SET media_flag = 1 WHERE scenario_id IS NOT NULL');
$this->addSql('INSERT INTO media (id, scenario_id, category, filename, media_order, active, is_deleted, media_name, description, users_id, preview_filename, use_prview_image, media_flag) SELECT nextval(\'seq_media_id\'), scenario_id, category, filename, media_order, active, is_deleted, CONCAT(media_name, \'_2\'), description, users_id, preview_filename, use_prview_image, 2 FROM media WHERE scenario_id IS NOT NULL AND media_flag != 2 ');
}
/**
* @param Schema $schema
*/
public function down(Schema $schema) : void
{
$this->addSql('DELETE FROM media WHERE media_flag = 2');
$this->addSql('UPDATE media SET media_flag = NULL WHERE media_flag IS NOT NULL');
// this down() migration is auto-generated, please modify it to your needs
}
}