/** * Clear all index data */ protected function _clearTmpData() { $this->_connection->dropTemporaryTable($this->_getMainTmpTable()); }
/** * Create temporary table */ protected function _createTemporaryTable() { $this->_connection->dropTemporaryTable($this->_getTemporaryTable()); $table = $this->_connection->newTable($this->_getTemporaryTable())->addColumn('grouped_id', Varien_Db_Ddl_Table::TYPE_VARCHAR, 80, array(), 'Grouped ID')->addColumn('product_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true), 'Product ID')->addColumn('customer_group_id', Varien_Db_Ddl_Table::TYPE_SMALLINT, 5, array('unsigned' => true), 'Customer Group ID')->addColumn('from_date', Varien_Db_Ddl_Table::TYPE_DATE, null, array(), 'From Date')->addColumn('to_date', Varien_Db_Ddl_Table::TYPE_DATE, null, array(), 'To Date')->addColumn('action_amount', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Action Amount')->addColumn('action_operator', Varien_Db_Ddl_Table::TYPE_VARCHAR, 10, array(), 'Action Operator')->addColumn('action_stop', Varien_Db_Ddl_Table::TYPE_SMALLINT, 6, array(), 'Action Stop')->addColumn('sort_order', Varien_Db_Ddl_Table::TYPE_INTEGER, 10, array('unsigned' => true), 'Sort Order')->addColumn('price', Varien_Db_Ddl_Table::TYPE_DECIMAL, '12,4', array(), 'Product Price')->addColumn('rule_product_id', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true), 'Rule Product ID')->addColumn('from_time', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true, 'nullable' => true, 'default' => 0), 'From Time')->addColumn('to_time', Varien_Db_Ddl_Table::TYPE_INTEGER, null, array('unsigned' => true, 'nullable' => true, 'default' => 0), 'To Time')->addIndex($this->_connection->getIndexName($this->_getTemporaryTable(), 'grouped_id'), array('grouped_id'))->setComment('CatalogRule Price Temporary Table'); $this->_connection->createTemporaryTable($table); }
/** * Create redirects temporary table * * @return void */ protected function _createRedirectTemporaryTable() { $temporaryTable = $this->_connection->newTable(self::TMP_TABLE_NAME); $this->_connection->dropTemporaryTable(self::TMP_TABLE_NAME); $temporaryTable->addColumn('identifier', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255)->addColumn('target_path', Varien_Db_Ddl_Table::TYPE_VARCHAR, 255)->addIndex('UNQ_ENTERPRISE_URL_REWRITE_TMP_IDENTIFIER_STORE_ID', array('identifier'), array('type' => Varien_Db_Adapter_Interface::INDEX_TYPE_UNIQUE)); $this->_connection->createTemporaryTable($temporaryTable); }