app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-0.7.60-0.7.61.php File Reference

Go to the source code of this file.

Packages
package	Mage_Catalog
Variables
	$installer = $this
	$tableCatalogProduct = $this->getTable('catalog/product')
	$types = array('datetime', 'decimal', 'int', 'text', 'varchar')
foreach($types as $type)	$tableName = $tableCatalogProduct . '_gallery'
	$select
	$query = $installer->getConnection()->query($select)
while($row=$query->fetch()) $installer getConnection()-> addKey("	_gallery
while($row=$query->fetch()) $installer getConnection()-> addKey("	array ('entity_type_id','entity_id','attribute_id','store_id')

---

Variable Documentation

$installer = $this

Definition at line 27 of file mysql4-upgrade-0.7.60-0.7.61.php.

$query = $installer->getConnection()->query($select)

Definition at line 74 of file mysql4-upgrade-0.7.60-0.7.61.php.

$select

Initial value:

 $installer->getConnection()->select()
    ->from($tableName, array(
        'entity_type_id'    => 'entity_type_id',
        'entity_id'         => 'entity_id',
        'attribute_id'      => 'attribute_id',
        'store_id'          => 'store_id',
        'rows_count'        => 'COUNT(*)'))
    ->group(array('entity_id', 'attribute_id', 'store_id'))
    ->having('rows_count > 1')

Definition at line 65 of file mysql4-upgrade-0.7.60-0.7.61.php.

$tableCatalogProduct = $this->getTable('catalog/product')

Definition at line 30 of file mysql4-upgrade-0.7.60-0.7.61.php.

foreach ($types as $type) $tableName = $tableCatalogProduct . '_gallery'

Definition at line 63 of file mysql4-upgrade-0.7.60-0.7.61.php.

$types = array('datetime', 'decimal', 'int', 'text', 'varchar')

Definition at line 32 of file mysql4-upgrade-0.7.60-0.7.61.php.

while ($row=$query->fetch()) $installer getConnection ()->addKey(" _gallery

Definition at line 88 of file mysql4-upgrade-0.7.60-0.7.61.php.

while ($row=$query->fetch()) $installer getConnection ()->addKey(" array('entity_type_id','entity_id','attribute_id','store_id')

Definition at line 88 of file mysql4-upgrade-0.7.60-0.7.61.php.