getConnection(); /* @var $conn Varien_Db_Adapter_Pdo_Mysql */ $conn->addColumn($installer->getTable('sales_quote'), 'customer_prefix', 'varchar(40) after customer_email'); $conn->addColumn($installer->getTable('sales_quote'), 'customer_middlename', 'varchar(40) after customer_firstname'); $conn->addColumn($installer->getTable('sales_quote'), 'customer_suffix', 'varchar(40) after customer_lastname'); $conn->addColumn($installer->getTable('sales_quote_address'), 'prefix', 'varchar(40) after email'); $conn->addColumn($installer->getTable('sales_quote_address'), 'middlename', 'varchar(40) after firstname'); $conn->addColumn($installer->getTable('sales_quote_address'), 'suffix', 'varchar(40) after lastname'); $installer->addAttribute('order', 'customer_prefix', array('type'=>'varchar', 'visible'=>false)); $installer->addAttribute('order', 'customer_middlename', array('type'=>'varchar', 'visible'=>false)); $installer->addAttribute('order', 'customer_suffix', array('type'=>'varchar', 'visible'=>false)); $installer->addAttribute('order_address', 'prefix', array()); $installer->addAttribute('order_address', 'middlename', array()); $installer->addAttribute('order_address', 'suffix', array());