getConnection()->newTable($setup->getTable(CustomerLink::TABLE_NAME)); $table ->addColumn( 'entity_id', Table::TYPE_INTEGER, null, [ 'identity' => true, 'unsigned' => true, 'primary' => true, 'nullable' => false ] ) ->addColumn( 'customer_id', Table::TYPE_INTEGER, null, [ 'unsigned' => true, 'nullable' => false ] ) ->addColumn( 'amazon_id', Table::TYPE_TEXT, 255, [ 'nullable' => false ] ) ->addIndex( $setup->getIdxName( CustomerLink::TABLE_NAME, ['customer_id', 'amazon_id'], AdapterInterface::INDEX_TYPE_UNIQUE ), ['customer_id', 'amazon_id'], ['type' => AdapterInterface::INDEX_TYPE_UNIQUE] ); $setup->getConnection()->createTable($table); } }