<?php

use yii\db\Migration;

class m160331_132149_slider extends Migration
{
    public function up()
    {
        $this->createTable('{{%slider}}', [
            'slider_id' => $this->primaryKey(),
            'template_location_id' => $this->integer(4)->notNull(),
            'speed' => $this->integer(4),
            'duration' => $this->integer(4),
            'title' => $this->string(200),
            'status' => $this->smallInteger(1),
        ]);
        $this->addForeignKey('template_location_slider_fk', 'template_location', 'template_location_id', 'slider', 'template_location_id', 'CASCADE', 'CASCADE');
    }

    public function down()
    {
        //$this->dropForeignKey('template_location_slider_fk', '{{%template_location}}');
        $this->dropTable('{{%slider}}');
    }


}