I have try to add new column in magento database. but its not working using mysql4-upgrade-0.1.0-0.1.1 : C:\xampp\htdocs\Surabhi\app\code\local\Surabhi\Employee\sql\employee_setup\mysql4-install-0.1.0-0.1.1.php
<?php
$installer = $this;
$installer->startSetup();
$installer->getConnection()->addColumn(
$this->getTable('employee/employee'),//table name
'address', //column name
'varchar(255) NOT NULL' //datatype definition
);
$installer->endSetup();
config.xml : C:\xampp\htdocs\Surabhi\app\code\local\Surabhi\Employee\etc\config.xml
<?xml version="1.0"?>
<config>
<modules>
<Surabhi_Employee>
<version>0.1.2</version>
</Surabhi_Employee>
</modules>
<global>
<helpers>
<employee>
<class>Surabhi_Employee_Helper</class>
</employee>
</helpers>
<blocks>
<employee>
<class>Surabhi_Employee_Block</class>
</employee>
</blocks>
<models>
<employee>
<class>Surabhi_Employee_Model</class>
<resourceModel>employee_mysql4</resourceModel>
</employee>
<employee_mysql4>
<class>Surabhi_Employee_Model_Mysql4</class>
<entities>
<employeedetail>
<table>employee</table>
</employeedetail>
</entities>
</employee_mysql4>
</models>
<resources>
<employee_setup>
<setup>
<module>Surabhi_Employee</module>
</setup>
<connection>
<use>core_setup</use>
</connection>
</employee_setup>
<employee_write>
<connection>
<use>core_write</use>
</connection>
</employee_write>
<employee_read>
<connection>
<use>core_read</use>
</connection>
</employee_read>
</resources>
</global>
<admin>
<routers>
<employee>
<use>admin</use>
<args>
<module>Surabhi_Employee</module>
<frontName>admin_employee</frontName>
</args>
</employee>
</routers>
</admin>
<adminhtml>
<menu>
<employee module="employee">
<title>Employee</title>
<sort_order>100</sort_order>
<children>
<employeedetail module="employee">
<title>Manage Employeedetail</title>
<sort_order>0</sort_order>
<action>admin_employee/adminhtml_employeedetail</action>
</employeedetail>
</children>
</employee>
</menu>
<acl>
<resources>
<all>
<title>Allow Everything</title>
</all>
<admin>
<children>
<employee translate="title" module="employee">
<title>Employee</title>
<sort_order>1000</sort_order>
<children>
<employeedetail translate="title">
<title>Manage Employeedetail</title>
<sort_order>0</sort_order>
</employeedetail>
</children>
</employee>
</children>
</admin>
</resources>
</acl>
<layout>
<updates>
<employee>
<file>employee.xml</file>
</employee>
</updates>
</layout>
</adminhtml>
</config>
I have used above code but not working.
