<?php
namespace InsyncAddtoCartSetup;

use MagentoFrameworkSetupUpgradeSchemaInterface;
use MagentoFrameworkSetupModuleContextInterface;
use MagentoFrameworkSetupSchemaSetupInterface;
use MagentoFrameworkDBDdlTable;

class UpgradeSchema implements UpgradeSchemaInterface
{
  public function upgrade(SchemaSetupInterface $setup,
  ModuleContextInterface $context)
{
    $setup->startSetup();
    $this->newTable($setup, $context);
    $setup->endSetup();
}
public function newTable($setup, $context)
{
    if (version_compare($context->getVersion(), '1.2.3') < 0)
    {
        $tableName = $setup->getTable('insync_addtocart_upgrade');
        if ($setup->getConnection()->isTableExists($tableName) == true)
        {
            $connection = $setup->getConnection();
            $connection->dropTable($connection->getTableName($tableName));
        }
        if ($setup->getConnection()->isTableExists($tableName) != true)
        {
            $table = $setup->getConnection()
                ->newTable($tableName)
                ->addColumn('id', Table::TYPE_INTEGER, null, [
                    'identity' => true,
                    'unsigned' => true,
                    'nullable' => false,
                    'primary' => true,
                    'auto_increment' => true
                     ], 'id')
                ->addColumn('name',Table::TYPE_TEXT,255,
                    ['nullable => false'],
                    'Name')
                ->addColumn('type', Table::TYPE_TEXT, 255, [
                    'nullable' => false
                     ], 'Type')
                ->addColumn('created_at',
                    MagentoFrameworkDBDdlTable::TYPE_TIMESTAMP,
                    null,
                    ['nullable' => false, 'default' => MagentoFrameworkDBDdlTable::TIMESTAMP_INIT],
                    'Created At');


            $setup->getConnection()->createTable($table);
        }
    }
}