bedezign\yii2\audit\migrations\m150626_000006_create_audit_mail

Complexity

Total Complexity

5

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	22	3
A	down()	0	7	2

<?php

namespace bedezign\yii2\audit\migrations;

use bedezign\yii2\audit\components\Migration;
use yii\db\Schema;

class m150626_000006_create_audit_mail extends Migration
{
    const TABLE = '{{%audit_mail}}';

    public function up()
    {
        $this->createTable(self::TABLE, [
            'id'         => Schema::TYPE_PK,
            'entry_id'   => Schema::TYPE_INTEGER . ' NOT NULL',
            'created'    => Schema::TYPE_DATETIME . ' NOT NULL',
            'successful' => Schema::TYPE_INTEGER . ' NOT NULL',
            'from'       => Schema::TYPE_STRING,
            'to'         => Schema::TYPE_STRING,
            'reply'      => Schema::TYPE_STRING,
            'cc'         => Schema::TYPE_STRING,
            'bcc'        => Schema::TYPE_STRING,
            'subject'    => Schema::TYPE_STRING,
            'text'       => Schema::TYPE_BINARY,
            'html'       => Schema::TYPE_BINARY,
            'data'       => Schema::TYPE_BINARY,
        ], $this->db->driverName === 'mysql' ? 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB' : null);

        if ($this->db->driverName != 'sqlite') {
            $this->addForeignKey('fk_audit_mail_entry_id', self::TABLE, ['entry_id'], '{{%audit_entry}}', 'id');
        }
    }

    public function down()
    {
        if ($this->db->driverName != 'sqlite') {
            $this->dropForeignKey('fk_audit_mail_entry_id', self::TABLE);
        }
        $this->dropTable(self::TABLE);
    }
}