common/migrations/db/m160624_232040_add_warranty_table.php
<?php
use yii\db\Migration;
class m160624_232040_add_warranty_table extends Migration
{
public function up()
{
$tableOptions = null;
if ($this->db->driverName === 'mysql') {
$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
}
$this->createTable('{{%warranty}}', [
'id' => $this->primaryKey(),
'receipt_product_id' => $this->integer(11)->notNull(),
'started' => $this->date()->notNull(),
'ended' => $this->date()->notNull(),
'created_at' => $this->dateTime()->notNull(),
'updated_at' => $this->dateTime(),
], $tableOptions);
$this->addForeignKey('warranty_receipt_product', '{{%warranty}}', 'receipt_product_id', '{{%receipt_product}}', 'id', 'CASCADE', 'CASCADE');
}
public function down()
{
$this->dropForeignKey('warranty_receipt_product', '{{%warranty}}');
$this->dropTable('{{%warranty}}');
}
}