title: Creating two new database tables for Magento
body: <p>I'm trying to add two tables to magento but it still dosen't work! I don't get the tables in MySQL. 
  There's no error message, just nothing happens.
  I can't find where the mistake is;
  I already checked all my pages. </p>
  
  <p>This is my XML code in config.xml: </p>
  
  <pre><code>    &lt;models&gt;
          &lt;interactivebanner&gt;
              &lt;class&gt;Kiwi_InteractiveBanner_Model&lt;/class&gt;
              &lt;resourceModel&gt;InteractiveBanner_resource&lt;/resourceModel&gt;
          &lt;/interactivebanner&gt;
          &lt;interactivebanner_resource&gt;
              &lt;class&gt;Kiwi_InteractiveBanner_Model_Resource&lt;/class&gt;
              &lt;entities&gt;
                  &lt;interactivebanner&gt;
                      &lt;table&gt;interactivebanner&lt;/table&gt;
                  &lt;/interactivebanner&gt;
                  &lt;interactivebanner2&gt;
                      &lt;table&gt;interactivebanner_prod&lt;/table&gt;
                  &lt;/interactivebanner2&gt;
              &lt;/entities&gt;
          &lt;/interactivebanner_resource&gt;
      &lt;/models&gt;
  </code></pre>
  
  <p>and this is the setup page  :</p>
  
  <pre><code>&lt;?php 
  
  $installer = $this;
    $installer-&gt;startSetup();
  
    $installer-&gt;run("
  DROP TABLE IF EXISTS `{$this-&gt;getTable('interactivebanner/interactivebanner')}`;
  create table `{$this-&gt;getTable('interactivebanner/interactivebanner')}`
  (
     ENTITY_ID            int not null,
     NAME                 varchar(100),
     LINK                 varchar(100),
     STATUS               int,
     primary key (ENTITY_ID)
  );
  
  DROP TABLE IF EXISTS `{$this-&gt;getTable('interactivebanner/interactivebanner_prod')}`;
  create table `{$this-&gt;getTable('interactivebanner/interactivebanner_prod')}`
  (
     PROD_ID              int not null,
     ENTITY_ID            int,
     POSI_V               float,
     POSI_H               float,
     primary key (PROD_ID)
  );
  
  alter table banner_pro add constraint FK_RELATION_1 foreign key (ENTITY_ID)
        references banner (ENTITY_ID) on delete restrict on update restrict;
  
  ");
  
    $installer-&gt;endSetup();
  </code></pre>