Go to the source code of this file.
Packages | |
| package | Mage_Catalog |
Variables | |
| $installer = $this | |
| $select | |
| $query = $installer->getConnection()->query($select) | |
| while($row=$query->fetch()) $installer | getConnection ()->dropKey($installer->getTable('catalog/category_product_index') |
| $installer | array ('category_id', 'product_id', 'is_parent', 'store_id') |
| $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.
| $select |
Initial value:
$installer->getConnection()->select() ->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...
Tabs
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)
protected
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.
1.5.8