What are the steps to be undertaken while writing a .install file for drupal 7 module?
as Clive says you should use hook_schema for creating your custom tables and then 
hook_update_N
https://api.drupal.org/api/drupal/modules!system!system.api.php/function/hook_update_N/7
for the updates of your tables module.