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
00029
00030
00031
00032
00033
00034
00035 $installer = $this;
00036
00037
00038 $installer->startSetup();
00039
00040 $installer->run("
00041 ALTER TABLE {$this->getTable('report_event_types')} DROP INDEX `event_type_id`;
00042 ALTER TABLE {$this->getTable('report_event_types')} CHANGE `event_name` `event_name` varchar(64) NOT NULL;
00043 UPDATE {$this->getTable('report_event_types')} SET `event_name`='catalog_product_compare_add_product' WHERE `event_type_id`=3;
00044 ALTER TABLE {$this->getTable('report_event')} ADD `sybtype` tinyint(3) unsigned NOT NULL default '0' AFTER `subject_id`;
00045 ALTER TABLE {$this->getTable('report_event')} ADD INDEX (`event_type_id`);
00046 ALTER TABLE {$this->getTable('report_event')} ADD INDEX (`sybtype`);
00047 ALTER TABLE {$this->getTable('report_event')} ADD INDEX (`store_id`);
00048 ALTER TABLE {$this->getTable('report_event_types')} ADD `customer_login` TINYINT UNSIGNED NOT NULL DEFAULT '0';
00049 UPDATE {$this->getTable('report_event_types')} SET `customer_login`=1;
00050 ");
00051
00052 $installer->endSetup();