<?php
namespace Leadlion\AutogedalWarehouses\Setup;

use Magento\Framework\Setup\UpgradeSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;

class UpgradeSchema implements UpgradeSchemaInterface
{
    public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
        $installer = $setup;
        $installer->startSetup();
        //Quote table 
        $installer->getConnection()
        ->addColumn(
            $setup->getTable('quote'),
            'autogedal_allocated_warehouse',
            [
                'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
                'length' => '250',
                'nullable' => true,
                'comment' => 'Autogedal warehosue allocation'
            ]
        );   
        $installer->getConnection()
            ->addColumn(
                $setup->getTable('quote'),
                'autogedal_allocated_carrier',
                [
                    'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
                    'length' => '250',
                    'nullable' => true,
                    'comment' => 'Autogedal carrier allocation'
                ]
            );
        //Order table
        $installer->getConnection()
            ->addColumn(
                $setup->getTable('sales_order'),
                'autogedal_allocated_carrier',
                [
                    'type' => \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
                    'length' => '250',
                    'nullable' => true,
                    'comment' => 'Autogedal carrier allocation'
                ]
            );
        $installer->endSetup();
    }
}