app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-0.7.55-0.7.56.php File Reference

Go to the source code of this file.

Packages
package	Mage_Catalog
Variables
	$installer = $this
	$categoryIndexTable = $installer->getTable('catalog/category_product_index')
$installer	getConnection ()->addColumn($categoryIndexTable
	$storesData
$installer getConnection()-> addConstraint( 'FK_CATEGORY_PRODUCT_INDEX_STORE'$installer	getTable ('core/store')

---

Variable Documentation

$installer getConnection ()->addConstraint( 'FK_CATEGORY_PRODUCT_INDEX_STORE' $categoryIndexTable = $installer->getTable('catalog/category_product_index')

Definition at line 32 of file mysql4-upgrade-0.7.55-0.7.56.php.

$installer = $this

Definition at line 27 of file mysql4-upgrade-0.7.55-0.7.56.php.

$storesData

Initial value:

 $installer->getConnection()->fetchAll("
    SELECT
        s.store_id, s.website_id, c.path AS root_path
    FROM
        {$installer->getTable('core/store')} AS s,
        {$installer->getTable('core/store_group')} AS sg,
        {$installer->getTable('catalog/category')} AS c
    WHERE
        sg.group_id=s.group_id
        AND c.entity_id=sg.root_category_id
")

Definition at line 59 of file mysql4-upgrade-0.7.55-0.7.56.php.

$installer getConnection()->addKey($categoryIndexTable

Definition at line 34 of file mysql4-upgrade-0.7.55-0.7.56.php.

$installer getConnection ()->addConstraint( 'FK_CATEGORY_PRODUCT_INDEX_STORE' $installer getTable('core/store')

Definition at line 123 of file mysql4-upgrade-0.7.55-0.7.56.php.