DoctrineMigrations\Version20251113204347

Complexity

Total Complexity

3

Size/Duplication

Total Lines	43
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	16	1
A	up()	0	16	1
A	getDescription()	0	3	1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20251113204347 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql(<<<'SQL'
            CREATE TEMPORARY TABLE __temp__texts AS SELECT id, target, header, text, source, text2 FROM texts
        SQL);
        $this->addSql(<<<'SQL'
            DROP TABLE texts
        SQL);
        $this->addSql(<<<'SQL'
            CREATE TABLE texts (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, target VARCHAR(255) NOT NULL, header VARCHAR(255) NOT NULL, text VARCHAR(255) NOT NULL, source VARCHAR(255) NOT NULL, text2 VARCHAR(255) NOT NULL)
        SQL);
        $this->addSql(<<<'SQL'
            INSERT INTO texts (id, target, header, text, source, text2) SELECT id, target, header, text, source, text2 FROM __temp__texts
        SQL);
        $this->addSql(<<<'SQL'
            DROP TABLE __temp__texts
        SQL);
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql(<<<'SQL'
            CREATE TEMPORARY TABLE __temp__texts AS SELECT id, target, header, text, source, text2 FROM texts
        SQL);
        $this->addSql(<<<'SQL'
            DROP TABLE texts
        SQL);
        $this->addSql(<<<'SQL'
            CREATE TABLE texts (id INTEGER PRIMARY KEY AUTOINCREMENT DEFAULT NULL, target CLOB DEFAULT NULL, header CLOB DEFAULT NULL, text CLOB DEFAULT NULL, source CLOB DEFAULT NULL, text2 CLOB DEFAULT NULL)
        SQL);
        $this->addSql(<<<'SQL'
            INSERT INTO texts (id, target, header, text, source, text2) SELECT id, target, header, text, source, text2 FROM __temp__texts
        SQL);
        $this->addSql(<<<'SQL'
            DROP TABLE __temp__texts
        SQL);
    }
}