I want to edit some tables of magento and I've made a module to do that. For example I want to edit table "catalog_product_bundle_price_index".
Here is the global section of my config.xml :
<global>
<resources>
<mymodule_setup>
<setup>
<module>Mynamespace_Mymodule</module>
</setup>
<connection>
<use>core_setup</use>
</connection>
</mymodule_setup>
<mymodule_read>
<connection>
<use>core_read</use>
</connection>
</mymodule_read>
<mymodule_write>
<connection>
<use>core_write</use>
</connection>
</mymodule_write>
</resources>
</global>
And here is the code in mysql4-install-1.0.0.php :
$installer = $this;
$installer->startSetup();
$tables = array(
$installer->getTable('bundle/price_index') => array(
'columns' => array(
'min_price' => array(
'type' => Varien_Db_Ddl_Table::TYPE_DECIMAL,
'scale' => 4,
'precision' => 16,
'nullable' => false,
'comment' => 'Min Price'
),
'max_price' => array(
'type' => Varien_Db_Ddl_Table::TYPE_DECIMAL,
'scale' => 4,
'precision' => 16,
'nullable' => false,
'comment' => 'Max Price'
)
),
'comment' => 'Catalog Product Bundle Price Index'
)
);
$installer->getConnection()->modifyTables($tables);
$installer->endSetup();
but it does not work, What am I doing wrong?