AnimeDb\Bundle\AppBundle\DoctrineMigrations\Version20130930180820_Init

Complexity

Total Complexity

2

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	6	1
B	up()	0	24	1

<?php
/**
 * AnimeDb package.
 *
 * @author    Peter Gribanov <info@peter-gribanov.ru>
 * @copyright Copyright (c) 2011, Peter Gribanov
 * @license   http://opensource.org/licenses/GPL-3.0 GPL v3
 */
namespace AnimeDb\Bundle\AppBundle\DoctrineMigrations;

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

class Version20130930180820_Init extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // create tables
        $this->addSql('CREATE TABLE `task` (
            `id` INTEGER NOT NULL,
            `command` VARCHAR(128) NOT NULL,
            `last_run` DATETIME DEFAULT NULL,
            `next_run` DATETIME NOT NULL,
            `modify` VARCHAR(128) DEFAULT NULL,
            `status` INTEGER NOT NULL,
            PRIMARY KEY(`id`)
        )');
        $this->addSql('CREATE TABLE notice (
            id INTEGER NOT NULL,
            message TEXT NOT NULL,
            date_closed DATETIME DEFAULT NULL,
            date_created DATETIME NOT NULL,
            lifetime INTEGER NOT NULL,
            status INTEGER NOT NULL,
            PRIMARY KEY(id)
        )');
        // add index
        $this->addSql('CREATE INDEX notice_show_idx ON notice (date_closed, date_created)');
    }

    public function down(Schema $schema)
    {
        // drop tables
        $schema->dropTable('task');
        $schema->dropTable('notice');
    }
}