title: How To Recreate A Table In Magento
body: <p>I dropped a table manually in magento. Now I want my code to recreate the same table.. I Have written the create statement in <code>app/code/local/namespace/my_module/sql</code> folder like this</p>
  
  <pre><code>DROP TABLE IF EXISTS {$this-&gt;getTable('cod')};
  CREATE TABLE {$this-&gt;getTable('cod')} (
      `cod_id` int(11) unsigned NOT NULL auto_increment,
      `status` smallint(6) NOT NULL default '0',
      'amount' int(11) unsigned NOT NULL,
      `created_time` datetime NULL,
      `update_time` datetime NULL,
      PRIMARY KEY (`cod_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>How will this query execute so that it can recreate the table...  </p>