<?php

use app\migrations\BaseMigration;
use app\models\core\UserFile;

/**
 * Class m180719_144344_405UserAvatar
 */
class m180719_144344_405UserAvatar extends BaseMigration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $schema = $this->db->schema->getTableSchema(UserFile::tableName());

        if ($schema !== null) {
            $this->endCommand($this->beginCommand(UserFile::tableName() . ' table exists, skipping'));
            return;
        }

        $this->createTable(UserFile::tableName(), [
            'id' => $this->primaryKey(),
            'user_id' => $this->integer()->notNull(),
            'filetype_id' => $this->integer()->notNull(),
            'filename' => $this->string()->notNull(),
            'type' => $this->string()->notNull(),
            'size' => $this->integer()->notNull(),
            'content' => $this->binary()->notNull(),
        ], self::OPT_ADD_MODIFIERS);

        $this->alterColumn(UserFile::tableName(), 'content', 'longblob');
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        $schema = $this->db->schema->getTableSchema(UserFile::tableName());

        if ($schema === null) {
            return;
        }

        $this->dropTable(UserFile::tableName());
    }
}