00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027 $installer = $this;
00028
00029
00030 $installer->startSetup();
00031
00032 $installer->run("
00033 -- DROP TABLE IF EXISTS `{$installer->getTable('catalogindex_eav')}`;
00034 CREATE TABLE `{$installer->getTable('catalogindex_eav')}` (
00035 `index_id` int(10) unsigned NOT NULL auto_increment,
00036 `store_id` smallint(5) unsigned NOT NULL default '0',
00037 `entity_id` int(10) unsigned NOT NULL default '0',
00038 `attribute_id` smallint(5) unsigned NOT NULL default '0',
00039 `value` int(11) NOT NULL default '0',
00040 PRIMARY KEY (`index_id`),
00041 KEY `IDX_VALUE` (`value`),
00042 CONSTRAINT `FK_CATALOGINDEX_EAV_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `{$installer->getTable('catalog_product_entity')}` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00043 CONSTRAINT `FK_CATALOGINDEX_EAV_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `{$installer->getTable('eav_attribute')}` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00044 CONSTRAINT `FK_CATALOGINDEX_EAV_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
00045 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00046
00047 -- DROP TABLE IF EXISTS `{$installer->getTable('catalogindex_price')}`;
00048 CREATE TABLE `{$installer->getTable('catalogindex_price')}` (
00049 `index_id` int(10) unsigned NOT NULL auto_increment,
00050 `store_id` smallint(5) unsigned NOT NULL default '0',
00051 `entity_id` int(10) unsigned NOT NULL default '0',
00052 `attribute_id` smallint(5) unsigned NOT NULL default '0',
00053 `customer_group_id` smallint(3) unsigned NOT NULL default '0',
00054 `qty` decimal(12,4) unsigned NOT NULL default '0.0000',
00055 `value` decimal(12,4) NOT NULL default '0.0000',
00056 PRIMARY KEY (`index_id`),
00057 KEY `IDX_VALUE` (`value`),
00058 KEY `IDX_QTY` (`qty`),
00059 CONSTRAINT `FK_CATALOGINDEX_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `{$installer->getTable('catalog_product_entity')}` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00060 CONSTRAINT `FK_CATALOGINDEX_PRICE_ATTRIBUTE` FOREIGN KEY (`attribute_id`) REFERENCES `{$installer->getTable('eav_attribute')}` (`attribute_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00061 CONSTRAINT `FK_CATALOGINDEX_PRICE_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00062 CONSTRAINT `FK_CATALOGINDEX_PRICE_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `{$installer->getTable('customer_group')}` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE
00063 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00064 ");
00065
00066 $installer->endSetup();