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

Complexity

Conditions	1
Paths	1

Size

Total Lines	24
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

0

<?php
    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)');
    }