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/