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
00028 $installer = $this;
00029
00030
00031 $installer->startSetup();
00032
00033 $installer->run("
00034 CREATE TABLE `{$installer->getTable('catalogindex_aggregation')}` (
00035 `aggregation_id` int(10) unsigned NOT NULL auto_increment,
00036 `store_id` smallint(5) unsigned NOT NULL,
00037 `created_at` datetime NOT NULL,
00038 `key` varchar(255) default NULL,
00039 `data` mediumtext,
00040 PRIMARY KEY (`aggregation_id`),
00041 UNIQUE KEY `IDX_STORE_KEY` (`store_id`,`key`),
00042 CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_STORE` FOREIGN KEY (`store_id`)
00043 REFERENCES `{$installer->getTable('core_store')}` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE
00044 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00045
00046 CREATE TABLE `{$installer->getTable('catalogindex_aggregation_tag')}` (
00047 `tag_id` int(10) unsigned NOT NULL auto_increment,
00048 `tag_code` varchar(255) NOT NULL,
00049 PRIMARY KEY (`tag_id`),
00050 UNIQUE KEY `IDX_CODE` (`tag_code`)
00051 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00052
00053 CREATE TABLE `{$installer->getTable('catalogindex_aggregation_to_tag')}` (
00054 `aggregation_id` int(10) unsigned NOT NULL,
00055 `tag_id` int(10) unsigned NOT NULL,
00056 UNIQUE KEY `IDX_AGGREGATION_TAG` (`aggregation_id`,`tag_id`),
00057 KEY `FK_CATALOGINDEX_AGGREGATION_TO_TAG_TAG` (`tag_id`),
00058 CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_TO_TAG_AGGREGATION` FOREIGN KEY (`aggregation_id`)
00059 REFERENCES `{$installer->getTable('catalogindex_aggregation')}` (`aggregation_id`)
00060 ON DELETE CASCADE ON UPDATE CASCADE,
00061 CONSTRAINT `FK_CATALOGINDEX_AGGREGATION_TO_TAG_TAG` FOREIGN KEY (`tag_id`)
00062 REFERENCES `{$installer->getTable('catalogindex_aggregation_tag')}` (`tag_id`)
00063 ON DELETE CASCADE ON UPDATE CASCADE
00064 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
00065
00066 ");
00067
00068 $installer->endSetup();