title: add new column to install script in magento CMS Page
body: <p>So i am down to the last bit of my module and it's really annoying i can't get it to add a new column to the CMS_PAGE table.</p>
  
  <p>This is what i have so far:</p>
  
  <p>/app/code/local/Damian/CMS/etc/config.xml</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;config&gt;
       &lt;modules&gt;
          &lt;damian_cms&gt;
              &lt;version&gt;0.1.0&lt;/version&gt;    &lt;!-- Version of module --&gt;
          &lt;/damian_cms&gt;
      &lt;/modules&gt;
      &lt;global&gt;
  
          &lt;models&gt;
              &lt;damian_cms&gt;
                  &lt;class&gt;Damian_CMS_Model&lt;/class&gt;
                  &lt;resourceModel&gt;cms_mysql4&lt;/resourceModel&gt;
              &lt;/damian_cms&gt;
          &lt;/models&gt;
  
  
  
          &lt;events&gt;
              &lt;adminhtml_cms_page_edit_tab_content_prepare_form&gt;
                  &lt;observers&gt;
                      &lt;damian_page_edit_tab_content&gt;
                          &lt;type&gt;singleton&lt;/type&gt;
                          &lt;class&gt;Damian_CMS_Model_Observer&lt;/class&gt;
                          &lt;method&gt;cmsField&lt;/method&gt;
                      &lt;/damian_page_edit_tab_content&gt;
                  &lt;/observers&gt;
              &lt;/adminhtml_cms_page_edit_tab_content_prepare_form&gt;
  
  
  &lt;cms_page_prepare_save&gt;
      &lt;observers&gt;
          &lt;damian_cms_save_page&gt;
              &lt;type&gt;singleton&lt;/type&gt;
              &lt;class&gt;Damian_CMS_Model_Observer&lt;/class&gt;
              &lt;method&gt;savePage&lt;/method&gt;
          &lt;/damian_cms_save_page&gt;
      &lt;/observers&gt;
  &lt;/cms_page_prepare_save&gt;
      &lt;/events&gt;
  
  
         &lt;resources&gt;
                  &lt;damian_cms_setup&gt;
                       &lt;setup&gt;
                      &lt;module&gt;damian_cms&lt;/module&gt;
                      &lt;class&gt;Damian_CMS_Model_Resource_Setup&lt;/class&gt;
  
                       &lt;/setup&gt;
                      &lt;connection&gt;
          &lt;use&gt;core_setup&lt;/use&gt;
          &lt;/connection&gt;
                  &lt;/damian_cms_setup&gt;
  &lt;cms_write&gt; &lt;!-- It gives the write permission to db --&gt;
              &lt;connection&gt;
                  &lt;use&gt;core_write&lt;/use&gt;
              &lt;/connection&gt;
          &lt;/cms_write&gt;
          &lt;cms_read&gt; &lt;!-- It gives the read permission from db --&gt;
              &lt;connection&gt;
                  &lt;use&gt;core_read&lt;/use&gt;
              &lt;/connection&gt;
          &lt;/cms_read&gt;
          &lt;/resources&gt; 
  
      &lt;/global&gt;
  &lt;/config&gt;
  </code></pre>
  
  <p>/app/code/local/Damian/CMS/Model/Resource/Setup.php</p>
  
  <pre><code>&lt;?php
  class Damian_CMS_Model_Resource_Setup extends Mage_Core_Model_Resource_Setup {
  }
  </code></pre>
  
  <p>/app/code/local/Damian/CMS/sql/cms_setup/mysql-install-0.1.0.php</p>
  
  <pre><code>&lt;?php
  
  
  $installer = $this;
  /* @var $installer Mage_Core_Model_Resource_Setup */
  
  echo 'Running This Upgrade:';
  die("Exit for now");
  
  
  
  $installer-&gt;startSetup();
  
  $tableName = $installer-&gt;getTable('cms_page');
  $installer-&gt;getConnection()-&gt;addColumn($tableName, 'cms_sitemap', array(
      'nullable' =&gt; true,
      'length' =&gt; 255,
      'default' =&gt; 1,
      'type' =&gt; Varien_Db_Ddl_Table::TYPE_TEXT,
      'comment' =&gt; 'added from extension Damian CMS'
  ));
  
  
  
  $installer-&gt;endSetup();
  </code></pre>
  
  <p>I haven't added the rest becuase it all seems to work, but i neeed this install script to work so i can put it into production on the live server, this is local and i have access to my own MYSQL database, But on the live servers i won't have access to the MYSQL database so i have to get this script to work.</p>
  
  <p>Thanks for your help :)</p>