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

Go to the source code of this file.


package  Mage_Catalog


 $installer = $this
 $query = $installer->getConnection()->query($select)
getConnection ()->dropKey($installer->getTable('catalog/category_product_index')
$installer array ('category_id', 'product_id', 'is_parent', 'store_id')

Variable Documentation

$installer = $this

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

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

Definition at line 41 of file mysql4-upgrade-0.7.56-0.7.57.php.


Initial value:

    ->from($installer->getTable('catalog/category_product_index'), array(
        'category_id' => 'category_id',
        'product_id'  => 'product_id',
        'is_parent'   => 'is_parent',
        'store_id'    => 'store_id',
        'rows_count'  => 'COUNT(*)'))
    ->group(array('category_id' , 'product_id' , 'is_parent' , 'store_id'))
    ->having('rows_count > 1')

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

Additional buttons on category page

Renderers with render type key block => the block name template => the template file renderer => the block object

Renderers for other column with column name key block => the block name template => the template file renderer => the block object

Grid columns

Enter description here...


List of available modes from source model key => label

breadcrumbs links

Array of buttons

Massaction items

Columns array

array( 'header' => string, 'width' => int, 'sortable' => bool, 'index' => string, //'renderer' => Mage_Adminhtml_Block_Widget_Grid_Column_Renderer_Interface, 'format' => string 'total' => string (sum, avg) )

Grid export types

tabs structure

Array of actions which can be processed without secret key validation

Array of products that not available in selected store

Excluded from batch update attribute codes

Helper collection

Parameters for helper

Country region collections

array( [$countryId] => Varien_Data_Collection_Db )

Cache tags to clean

Website collection websiteId => Mage_Core_Model_Website

Group collection groupId => Mage_Core_Model_Store_Group

Store collection storeId => Mage_Core_Model_Store

count of unread notes by type

tables Foreign key data array [tbl_name] = array(create foreign key strings)

EAV attributes cache

Websites cache

Customer Groups cache

Compare Products comparable attributes cache

List of available order fields

Product amount per row in grid display mode depending on custom page layout of category

Action list where need check enabled cookie

Store categories cache

Cache for category rewrite suffix

Array of existing handlers

Symbol convert table

Cache for product rewrite suffix

Attribute default values

This array contain default values for attributes which was redefine value for store

Locked attributes

Default ignored attribute codes

Default ignored attribute types

Category design attributes

Array of attributes codes needed for product load

Product Attributes used in product listing

Product Attributes For Sort By

product types collection array

Product Type Instances singletons

product attribute set collection array

Inventory Fields array

Inventory Fields by product Types

Product collections per store

Product Type Instances object cache

Product Type cache

Array of filter items

Product collections array

Website currency codes and rates

Allowed mime types for image



Product object customization (not stored in DB)

Array with labels

Inactive categories ids

Catalog Product Flat is enabled cache per store

Cache for all ids

Product limitation filters

Allowed filters store_id category_id category_is_anchor visibility website_ids

Comparable attributes cache

Attribute codes for flat

Attribute objects for flat cache

Required system attributes for preload

Flat table columns cache

Flat table indexes cache

Product Type Instances cache

Product atrribute cache

Stores configuration array

Category attribute properties cache

Product attribute properties cache

Categories cache for products

Rewrite cache

Set of available indexers Each indexer type is responsable for index data storage

Predefined set of indexer types which are related with product price

Predefined sets of indexer types which are related with product filterable attributes

Tproduct types sorted by index priority

Attribute id by code cache

Retreiver model names cache

All product types registry in scope of quantity availability

Product qty's checked data is valid if you check quote item qty and use singleton instance

Note messages

User friendly search criteria list

Searchable attributes cache

Allow steps array

Contains references to child block objects

Sorted children list

Children blocks HTML cache array

Assigned variables for view

Action flags

for example used to disable rendering default layout

Available routers array

Array of senteces of JS translations

Array of area loaded parts

Application loaded areas array

Helpers array

Use Cache

Groups cache

Stores cache

Events cache

Flag cache for existing or already created directories

Instructions for spitting config cache array( $sectionName => $recursionLevel ) Recursion level provide availability cache subnodes separatly

Loaded Configuration by cached sections

Storage for generated class names

Storage of validated secure urls

System environment server variables

Array which is using for replace placeholders of server variables

Configuration for events by area

Property used during cache save process

Cumulative array of update XML strings

Handles used in this update

Substitution values in structure array('from'=>array(), 'to'=>array())

Blocks registry

Cache of block callbacks to output during rendering

Helper blocks cache for this layout

Emulated locales stack

All messages by type array

Connections cache for this resource model

Tables used in this resource model

Main table unique keys field names

could array( array('field' => 'db_field_name1', 'title' => 'Field 1 should be unique') array('field' => 'db_field_name2', 'title' => 'Field 2 should be unique') array( 'field' => array('db_field_name3', 'db_field_name3'), 'title' => 'Field 3 and Field 4 combination should be unique' ) )

or string 'my_field_name' - will be autoconverted to array( array( 'field' => 'my_field_name', 'title' => 'my_field_name' ) )

Store joined tables here

Instances of classes for connection types

Instances of actual connections

Registry of resource entities

URL host cache

Group Store collection array

Group store ids array

Group store codes array

Translator configuration array

Translation data

Translation data for data scope (per module)

Reserved Route parametr keys

Cache configuration array

Website Group Coleection array

Website group ids array

Website Store collection array

Website store ids array

Website store codes array

Directory country models

Directory region models

Website collection array

Field list collection array

Action parameters

Hold information about action container

Field list

Currency Rates

Currency rate cache array

Remote server headers

Entity types data

Attributes data

Information about preloaded attributes

Information about entity types with initialized attributes

Attribute codes cache array

Initialized objects

array ($objectId => $object)

References between codes and identifiers

array ( 'attributes'=> array ($attributeId => $attributeCode), 'entities' => array ($entityId => $entityCode) )

Array of attributes objects used in collections

Attributes array by attribute id

2-dimentional array by table name and attribute name

Attributes that are static fields in entity table

Describe data for tables

Attribute id cache

Options array

Default values for option cache

Array of items with item id key

Entity static fields

Entity types to be fetched for objects in collection

Attributes to be fetched for objects in collection

Attributes to be filtered order sorted by

Joined entities

Joined attributes

Joined fields data

Inner cache

Allowed types of entities for using of gift messages

Available options

Script arguments

Errors array

Wizard configuration

Error messages

Params for filename generation

Array of breadcrumbs

array( [$index] => array( ['label'] ['title'] ['link'] ['first'] ['last'] ) )

Array of toplinks

array( [$index] => array( ['liParams'] ['aParams'] ['innerText'] ['beforeText'] ['afterText'] ['first'] ['last'] ) )

All links

Available page layouts

Page layout options

Fields that should be replaced in debug with '***'

Product collection array

Products collection where changed price

Product collection which of back in stock

Warning (exception) errors array

Store Ids

Default ignored attribute codes per entity type

Product Ids array

Item renderers with render type key

model => the model name renderer => the renderer model

Array of action flags for canUnhold, canEdit, etc.

Total models array

Total data as array

Item options array

Item options by code cache

Not Represent options

Default shipping orig for requests

Attribute cache

Join Flags

Shared store ids (website stores)

All collection data array Used for getData method

Fields map for corellation names & real selected fields

Collection items

Order configuration

Filters configuration

Additional collection flags

Elements storage

form elements index

Tables DDL cache

SQL bind params

Array of additional tables

array( [$tableName] => array( ['joinCondition'] ['fields'] ) )

Array of events in the collection

Array of observers

Uploaded file handle (copy of $_FILES[] element)


Assigned template variables

Parameters array

Connection config

SPL object hashes

SPL hashes by object

References to objects

Debug data such as backtrace per class

Object attributes

Original data that was loaded

Setter/Getter underscore transformation cache

Timers for code profiling

Registry collection

Definition at line 62 of file mysql4-upgrade-0.7.56-0.7.57.php.

$installer getConnection()->addKey($installer->getTable('catalog/category_product_index')

Definition at line 55 of file mysql4-upgrade-0.7.56-0.7.57.php.

Generated on Sat Jul 4 17:22:26 2009 for Magento by  doxygen 1.5.8