AnimeDb\Bundle\AppBundle\DoctrineMigrations\Version20131223134044_AddNoticeDateStart::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	29
Code Lines	7

Duplication

Lines	29
Ratio	100 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

<?php
    public function up(Schema $schema)
    {
        // create temp table from new structure
        $this->addSql('CREATE TABLE "_new" (
            id INTEGER NOT NULL,
            message TEXT NOT NULL,
            date_closed DATETIME DEFAULT NULL,
            date_created DATETIME NOT NULL,
            date_start DATETIME NOT NULL,
            lifetime INTEGER NOT NULL,
            status INTEGER NOT NULL,
            PRIMARY KEY(id)
        )');

        $this->addSql('
            INSERT INTO
                "_new"
            SELECT
                id, message, date_closed, date_created, date_created, lifetime, status
            FROM
                "notice"
        ');
        // rename new to origin and drop origin
        $this->addSql('ALTER TABLE notice RENAME TO _origin');
        $this->addSql('ALTER TABLE _new RENAME TO notice');
        $this->addSql('DROP TABLE _origin');

        $this->addSql('CREATE INDEX notice_show_idx ON notice (date_closed, date_start)');
    }