00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028 $installer = $this;
00029
00030
00031 $installer->startSetup();
00032
00033 $installer->getConnection()->changeTableEngine($installer->getTable('productalert/stock'), 'INNODB');
00034 $installer->getConnection()->dropKey($installer->getTable('productalert/stock'), 'FK_PRODUCT_ALERT_PRICE_CUSTOMER');
00035 $installer->getConnection()->dropKey($installer->getTable('productalert/stock'), 'FK_PRODUCT_ALERT_PRICE_PRODUCT');
00036 $installer->getConnection()->dropKey($installer->getTable('productalert/stock'), 'FK_PRODUCT_ALERT_PRICE_WEBSITE');
00037 $installer->getConnection()->addConstraint('FK_PRODUCT_ALERT_STOCK_CUSTOMER',
00038 $installer->getTable('productalert/stock'), 'customer_id',
00039 $installer->getTable('customer/entity'), 'entity_id',
00040 'CASCADE', 'CASCADE', true);
00041 $installer->getConnection()->addConstraint('FK_PRODUCT_ALERT_STOCK_PRODUCT',
00042 $installer->getTable('productalert/stock'), 'product_id',
00043 $installer->getTable('catalog/product'), 'entity_id',
00044 'CASCADE', 'CASCADE', true);
00045 $installer->getConnection()->addConstraint('FK_PRODUCT_ALERT_STOCK_WEBSITE',
00046 $installer->getTable('productalert/stock'), 'website_id',
00047 $installer->getTable('core/website'), 'website_id',
00048 'CASCADE', 'CASCADE', true);
00049 $installer->endSetup();