title: Create a new table from magento module
body: <p>I am trying to have an admin module I am working on create a new table in the database.  What I have setup in</p>
  
  <p>app/code/local/Foo/BAR/sql/mysql4-install-0.1.0.php</p>
  
  <pre><code>&lt;?php
    $installer = $this;
    $installer-&gt;startSetup();
  
    $installer-&gt;run("
      DROP TABLE IF EXISTS {$this-&gt;getTable('notes')};
  
      CREATE TABLE {$this-&gt;getTable('notes')} (
        `ppr_id` int(11) NOT NULL AUTO_INCREMENT,
        `notesku` bigint(20) NOT NULL,
        `notestatus`  smallint(16),
        PRIMARY KEY (`notes`)
      ) ENGINE=MyISAM  DEFAULT CHARSET=utf8
    ");
  
    $installer-&gt;endSetup();
  </code></pre>
  
  <p>and this in app/code/local/Foo/BAR/etc/config.xml</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;config&gt;
      &lt;modules&gt;
          &lt;Foo_BAR&gt;
              &lt;version&gt;0.1.0&lt;/version&gt;
          &lt;/Foo_BAR&gt;
      &lt;/modules&gt;    
  
      &lt;global&gt;
              &lt;models&gt;
                  &lt;BAR&gt;
                      &lt;class&gt;Foo_BAR_Model&lt;/class&gt;
                      &lt;resourceModel&gt;BAR_mysql4&lt;/resourceModel&gt;
                  &lt;/BAR&gt;
  
                  &lt;BAR_myslq4&gt;
                      &lt;class&gt;Foo_BAR_Model_Mysql4&lt;/class&gt;
                      &lt;entities&gt;
                          &lt;BAR&gt;
                              &lt;table&gt;notes&lt;/table&gt;
                          &lt;/BAR&gt;
                      &lt;/entities&gt;
                  &lt;/BAR_myslq4&gt;           
              &lt;/models&gt;
  
              &lt;resources&gt;
                  &lt;BAR_setup&gt;
                      &lt;setup&gt;
                          &lt;module&gt;Foo_BAR&lt;/module&gt;
                      &lt;/setup&gt;
                      &lt;connection&gt;
                          &lt;use&gt;core_setup&lt;/use&gt;
                      &lt;/connection&gt;
                  &lt;/BAR_setup&gt;
                  &lt;BAR_write&gt;
                      &lt;connection&gt;
                          &lt;use&gt;core_write&lt;/use&gt;
                      &lt;/connection&gt;
                  &lt;/BAR_write&gt;
                  &lt;BAR_read&gt;
                      &lt;connection&gt;
                          &lt;use&gt;core_read&lt;/use&gt;
                      &lt;/connection&gt;
                  &lt;/BAR_read&gt;
              &lt;/resources&gt;
      &lt;/global&gt;    
  
      &lt;admin&gt;
          &lt;routers&gt;
              &lt;BAR&gt;
                  &lt;use&gt;admin&lt;/use&gt;
                  &lt;args&gt;
                      &lt;module&gt;Foo_BAR&lt;/module&gt;
                      &lt;frontName&gt;bar&lt;/frontName&gt;
                  &lt;/args&gt;
              &lt;/BAR&gt;      
          &lt;/routers&gt;
      &lt;/admin&gt;
  
  
  
        &lt;adminhtml&gt;
          &lt;menu&gt;
              &lt;catalog&gt;
                  &lt;children&gt;
                       &lt;BAR_menu translate="title" module="BAR"&gt;
                          &lt;title&gt;BAR&lt;/title&gt;
                          &lt;children&gt;
                              &lt;list translate="title" module="BAR"&gt;
                                  &lt;title&gt;Bar&lt;/title&gt;
                                  &lt;action&gt;bar/index/index&lt;/action&gt;
                              &lt;/list&gt;                       
                          &lt;/children&gt;
                      &lt;/BAR_menu&gt;
                  &lt;/children&gt;
              &lt;/catalog&gt;
          &lt;/menu&gt;
      &lt;/adminhtml&gt;       
  &lt;/config&gt;
  </code></pre>
  
  <p>The case I am using matches this example where my company is capitalized and the module name is all uppercase.  I am thinking maybe that is tripping me up?  My understanding is that once I run the page that hits that module it will trigger that mysql to create the table.  Is that correct?  Is there something else I should be doing?</p>
  
  <p>I greatly appreciate any help with this.</p>