AnimeDb\Bundle\CatalogBundle\DoctrineMigrations\Version20140415172522_AddItemLabel::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	18
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up(Schema $schema)
    {
        $this->addSql('CREATE TABLE label (
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
            name VARCHAR(16) NOT NULL
        )');
        // add index
        $this->addSql('CREATE INDEX label_name_idx ON label (name)');

        $this->addSql('CREATE TABLE items_labels (
            item_id INTEGER NOT NULL,
            label_id INTEGER NOT NULL,
            PRIMARY KEY(item_id, label_id)
        )');
        // add index
        $this->addSql('CREATE INDEX item_labels_item_id_idx ON items_labels (item_id)');
        $this->addSql('CREATE INDEX item_labels_label_id_idx ON items_labels (label_id)');
    }