flipbox\organizations\migrations\m180507_121214_user_association_sort

Complexity

Total Complexity

4

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	safeUp()	0	22	3
A	safeDown()	0	5	1

<?php

/**
 * @copyright  Copyright (c) Flipbox Digital Limited
 * @license    https://flipboxfactory.com/software/organization/license
 * @link       https://www.flipboxfactory.com/software/organization/
 */

namespace flipbox\organizations\migrations;

use craft\db\Migration;
use flipbox\organizations\records\UserAssociation;

/**
 * This migration adds a new column to support multiple user association sort types.
 */
class m180507_121214_user_association_sort extends Migration
{
    /**
     * @inheritdoc
     * @throws \yii\base\NotSupportedException
     */
    public function safeUp()
    {
        $table = $this->getDb()->getSchema()->getTableSchema(
            UserAssociation::tableName()
        );

        if (isset($table->columns['sortOrder'])) {
            $this->renameColumn(
                UserAssociation::tableName(),
                'sortOrder',
                'organizationOrder'
            );
        }

        if (!isset($table->columns['userOrder'])) {
            $this->addColumn(
                UserAssociation::tableName(),
                'userOrder',
                $this->smallInteger()->unsigned()->after('organizationid')
            );
        }
    }

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