<?php

use Framework\Database\Connection\Connection;

class CreateStockMovementsTable
{
    public function migrate(Connection $connection)
    {
        $table = $connection->createTable('stock_movements');
        $table->id('id');
        $table->int('item_id');
        $table->int('location_id');
        $table->string('type');
        $table->int('quantity_change');
        $table->int('quantity_after');
        $table->text('notes');
        $table->int('user_id');
        $table->dateTime('created_at')->default('CURRENT_TIMESTAMP');
        $table->execute();
    }
}