Version20140220123416_AddMalItemTable::up()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 10
Code Lines 4

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 2
Bugs 0 Features 1
Metric Value
c 2
b 0
f 1
dl 0
loc 10
ccs 0
cts 10
cp 0
rs 9.4285
cc 1
eloc 4
nc 1
nop 1
crap 2
1
<?php
2
/**
3
 * AnimeDb package
4
 *
5
 * @package   AnimeDb
6
 * @author    Peter Gribanov <[email protected]>
7
 * @copyright Copyright (c) 2011, Peter Gribanov
8
 * @license   http://opensource.org/licenses/GPL-3.0 GPL v3
9
 */
10
11
namespace AnimeDb\Bundle\MyAnimeListSyncBundle\DoctrineMigrations;
12
13
use Doctrine\DBAL\Migrations\AbstractMigration;
14
use Doctrine\DBAL\Schema\Schema;
15
16
/**
17
 * Auto-generated Migration: Please modify to your needs!
18
 */
19
class Version20140220123416_AddMalItemTable extends AbstractMigration
20
{
21
    public function up(Schema $schema)
22
    {
23
        $this->addSql('CREATE TABLE my_anime_list_item (
24
            mal_item_id INTEGER NOT NULL,
25
            item_id INTEGER NOT NULL,
26
            PRIMARY KEY(mal_item_id)
27
        )');
28
        $this->addSql('CREATE UNIQUE INDEX my_anime_list_item_item_idx ON my_anime_list_item (item_id)');
29
        $this->addSql('CREATE UNIQUE INDEX my_anime_list_item_idx ON my_anime_list_item (mal_item_id, item_id)');
30
    }
31
32
    public function down(Schema $schema)
33
    {
34
        $schema->dropTable('my_anime_list_item');
35
    }
36
}
37