how to re-install custom module in local with sql script

in your custom module's sql folder their is a folder with yourmodule_setup,you have to delete yourmodule_setup record from the core_resource table and just refresh the browser your script will run again.