Also Issue in inheriatge class of
in Model/Mysql4/Modulename.php
Mage_Core_Model_Mysql4_Collection_Abstract
to
Mage_Core_Model_Mysql4_Abstract
How to create database module:http://www.amitbera.com/create-an-magento-extension-with-custom-database-table/