studioespresso/craft-seo-fields

<?php

namespace studioespresso\seofields\migrations;

use Craft;
use craft\db\Migration;
use studioespresso\seofields\records\NotFoundRecord;
use studioespresso\seofields\records\RedirectRecord;

/**
 * m191114_201532_addRedirectsTable migration.
 */
class m191114_201532_addRedirectsTable extends Migration
{
    /**
     * @inheritdoc
     */
    public function safeUp()
    {
        $tablesCreated = false;
        $tableSchema = Craft::$app->db->schema->getTableSchema(RedirectRecord::tableName());
        if ($tableSchema === null) {
            $tablesCreated = true;
            $this->createTable(
                RedirectRecord::tableName(),
                [
                    'id' => $this->primaryKey(),
                    'siteId' => $this->integer(11)->defaultValue(null),
                    'pattern' => $this->string(255)->notNull(),
                    'sourceMatch' => $this->string(),
                    'redirect' => $this->string(255)->notNull(),
                    'matchType' => $this->string(),
                    'counter' => $this->bigInteger(),
                    'method' => $this->integer(3)->notNull(),
                    'dateLastHit' => $this->dateTime(),
                    'dateCreated' => $this->dateTime()->notNull(),
                    'dateUpdated' => $this->dateTime()->notNull(),
                    'uid' => $this->uid(),
                ]
            );
        }

        if ($tablesCreated) {
            $this->addForeignKey(
                $this->db->getForeignKeyName(RedirectRecord::tableName(), 'siteId'),
                RedirectRecord::tableName(),
                'siteId',
                '{{%sites}}',
                'id',
                'CASCADE'
            );
            $this->addForeignKey(
                $this->db->getForeignKeyName(NotFoundRecord::tableName(), 'redirect'),
                NotFoundRecord::tableName(),
                'redirect',
                '{{%seofields_redirects}}',
                'id',
                'SET NULL'
            );
        }
    }

    /**
     * @inheritdoc
     */
    public function safeDown()
    {
        echo "m191114_201532_addRedirectsTable cannot be reverted.\n";
        return false;
    }
}