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 $installer->run("
00032 CREATE TABLE `{$installer->getTable('catalogindex_minimal_price')}` (
00033 `index_id` int(10) unsigned NOT NULL auto_increment,
00034 `store_id` smallint(5) unsigned NOT NULL default '0',
00035 `entity_id` int(10) unsigned NOT NULL default '0',
00036 `customer_group_id` smallint(3) unsigned NOT NULL default '0',
00037 `qty` decimal(12,4) unsigned NOT NULL default '0.0000',
00038 `value` decimal(12,4) NOT NULL default '0.0000',
00039 PRIMARY KEY (`index_id`),
00040 KEY `IDX_VALUE` (`value`),
00041 KEY `IDX_QTY` (`qty`),
00042 CONSTRAINT `FK_CATALOGINDEX_MINIMAL_PRICE_ENTITY` FOREIGN KEY (`entity_id`) REFERENCES `{$installer->getTable('catalog_product_entity')}` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00043 CONSTRAINT `FK_CATALOGINDEX_MINIMAL_PRICE_STORE` FOREIGN KEY (`store_id`) REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE,
00044 CONSTRAINT `FK_CATALOGINDEX_MINIMAL_PRICE_CUSTOMER_GROUP` FOREIGN KEY (`customer_group_id`) REFERENCES `{$installer->getTable('customer_group')}` (`customer_group_id`) ON DELETE CASCADE ON UPDATE CASCADE
00045 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00046 ");
00047
00048 $installer->endSetup();