<?php

use bff\db\migrations\Migration;

class MpV3x0x9 extends Migration
{
    public function migrate()
    {
        $this->users();
        $this->listings();
    }

    public function rollback()
    {
    }

    protected function users()
    {
        $table = $this->table(Users::TABLE_USERS);

        # firstname
        if (! $table->hasColumn('firstname')) {
            $table
                ->addColumn('firstname', 'string', ['limit' => 100, 'null' => false, 'default' => ''])
                ->update();

            $this->db->exec('UPDATE ' . Users::TABLE_USERS . ' SET firstname = name');
        }
    }

    protected function listings()
    {
        $this->table(Listings::TABLE_ITEMS_IMAGES)
            ->addIndex(['user_id'], ['name' => 'user_id'])
            ->update();
    }
}