I am trying to create a script to create a table in my custom module. I tried many method but i thing there is a minor issue in my script. I want sure what is mistake.

Config file

Path – app\code\community\Amit\Custommodule\etc\config.xml

<?xml version="1.0" ?> <config>    <modules>       <Amit_Custommodule>          <version>1.1.0</version>       </Amit_Custommodule>    </modules>  <global> <models>     <custommodule>         <class>Amit_Custommodule_Model</class>         <resourceModel>custommodule_resource</resourceModel>     </custommodule>     <custommodule_resource>         <entities>             <custommodule>                 <table>custommodule</table>             </custommodule>             <custommodule>                 <table>custommodule2</table>             </custommodule>                          <custommodule>                 <table>custommodule3</table>             </custommodule>         </entities>     </custommodule_resource> </models> <resources>     <custommodule_setup>         <setup>             <module>Amit_Custommodule</module>             <class>Mage_Customer_Model_Entity_Setup</class>         </setup>         <connection>             <use>core_setup</use>         </connection>     </custommodule_setup>     <custommodule_read>         <connection>             <use>core_read</use>         </connection>     </custommodule_read>     <custommodule_write>         <connection>             <use>core_write</use>         </connection>     </custommodule_write> </resources> <!-- start of block --> <blocks>     <custommodule>         <class>Amit_Custommodule_Block</class>     </custommodule> </blocks> 

standard Amit_Custommodule custommodule custommodule.xml Sql Query

Path – app\code\community\Amit\Custommodule\sql\custommodule_setup/upgrade-1.0.0-1.1.0.php

<?php $  installer=$  this; $  installer->startSetup();  $  installer->run(" -- DROP TABLE IF EXISTS {$  this->getTable('custommodule3')}; CREATE TABLE {$  this->getTable('custommodule3')} (   `custommodule_id` int(11) unsigned NOT NULL auto_increment COMMENT 'Q&A ID',   `product_id` int(11) NOT NULL  COMMENT 'Product Id' ,   `customer_name` varchar(255) NOT NULL COMMENT 'Customer Name',   `customer_email` varchar(255) NOT NULL  COMMENT 'Customer Email',   `question` text NOT NULL  COMMENT 'Question',   `answer` text NOT NULL  COMMENT 'Answer',   `status` smallint(6) NOT NULL default '0' COMMENT 'Status',   `created_time` datetime NULL,   `update_time` datetime NULL,   PRIMARY KEY (`custommodule_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;      "); $  installer->endSetup(); ?>