<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Migrations\Schema\V200;

use Chamilo\CoreBundle\Migrations\AbstractMigrationChamilo;
use Doctrine\DBAL\Schema\Schema;

final class Version20201206111706 extends AbstractMigrationChamilo
{
    public function getDescription(): string
    {
        return 'Change title format';
    }

    public function up(Schema $schema): void
    {
        // From configuration.dist.php 1.11.x
        $this->addSql('ALTER TABLE c_dropbox_file CHANGE filename filename VARCHAR(190) NOT NULL');
        $this->addSql('ALTER TABLE course_category CHANGE title title LONGTEXT NOT NULL;');
        $this->addSql('ALTER TABLE c_course_description CHANGE title title LONGTEXT DEFAULT NULL');
        $this->addSql('ALTER TABLE c_thematic CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE c_quiz CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE c_lp_category CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE c_glossary CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE c_tool CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE portfolio CHANGE title title LONGTEXT NOT NULL');
        $this->addSql('ALTER TABLE block CHANGE path path VARCHAR(190) NOT NULL');
    }

    public function down(Schema $schema): void {}
}
