<?php

use bff\db\migrations\Migration;

class MpV3x0x7 extends Migration
{
    public function init()
    {
        parent::init();

        $this->setSteps([
            'categories-depth-5' => ['t' => 'Extend listings categories depth from 4 to 5 levels'],
        ]);
    }

    public function migrate()
    {
        if ($this->startStep('categories-depth-5')) {
            $this->categoriesDepth5();
        }
    }

    protected function categoriesDepth5()
    {
        $table = $this->table(Listings::TABLE_ITEMS);
        if (! $table->hasColumn('cat_id5')) {
            $table->addColumn('cat_id5', 'integer', ['signed' => false, 'null' => false, 'default' => '0', 'after' => 'cat_id4'])
                ->update();
        }
    }

    public function rollback()
    {
        //
    }
}