I'm adding Custom field/Column to Customer table. but it's not showing in table as well as customer grid from admin panel.
my code is:
C:\xampp\htdocs\magento\app\code\core\Mage\Customer\etc\config.xml
<?xml version="1.0"?>
<config>
<modules>
<Mage_Customer>
<version>1.6.2.0.2</version>
</Mage_Customer>
</modules>
<admin>
<fieldsets>
<customer_dataflow>
<mobile>
<billing>1</billing>
<shipping>1</shipping>
<mapped>1</mapped>
</mobile>
</customer_dataflow>
</fieldsets>
</admin>
<global>
<fieldsets>
<customer_account>
<Mobile>
<create>1</create>
<update>1</update>
</Mobile>
</customer_account>
</fieldsets>
.....
</config>
C:\xampp\htdocs\magento\app\code\core\Mage\Customer\Model\Resource\Setup.php
<?php
class Mage_Customer_Model_Resource_Setup extends Mage_Eav_Model_Entity_Setup
{
...
public function getDefaultEntities()
{
$entities = array(
'customer' => array(
'entity_model' => 'customer/customer',
'attribute_model' => 'customer/attribute',
'table' => 'customer/entity',
'increment_model' => 'eav/entity_increment_numeric',
'additional_attribute_table' => 'customer/eav_attribute',
'entity_attribute_collection' => 'customer/attribute_collection',
'attributes' => array(
'mobile' => array(
'type' => 'int',
'label' => 'mobile',
'input' => 'text',
'required' => false,
'sort_order' => 111,
'position' => 111,
'visible' => true,
),
)
),
);
return $entities;
}
...
}
C:\xampp\htdocs\magento\app\code\core\Mage\Customer\sql\customer_setup\upgrade-1.6.2.0-1.6.2.0.2.php
<?php
$installer = $this;
$installer->startSetup();
$this->addAttribute('customer', 'mobile', array(
'type' => 'varchar',
'input' => 'text',
'label' => 'mobile',
'global' => 1,
'visible' => 1,
'required' => 0,
'user_defined' => 1,
'visible_on_front' => 1
));
Mage::log('Working');
$installer->endSetup();
$customerattribute = Mage::getModel('customer/attribute')->loadByCode('customer','mobile');
$forms = array('customer_register_address',
'customer_address_edit',
'adminhtml_customer_address');
$customerattribute->setData('used_in_forms',$forms);
$customerattribute->save();
Could you please tell me where I went wrong?
thanks in advance.
customer_entity_varchar
but this Column is Where will create?