00001 <?php 00002 /** 00003 * Magento 00004 * 00005 * NOTICE OF LICENSE 00006 * 00007 * This source file is subject to the Open Software License (OSL 3.0) 00008 * that is bundled with this package in the file LICENSE.txt. 00009 * It is also available through the world-wide-web at this URL: 00010 * http://opensource.org/licenses/osl-3.0.php 00011 * If you did not receive a copy of the license and are unable to 00012 * obtain it through the world-wide-web, please send an email 00013 * to license@magentocommerce.com so we can send you a copy immediately. 00014 * 00015 * DISCLAIMER 00016 * 00017 * Do not edit or add to this file if you wish to upgrade Magento to newer 00018 * versions in the future. If you wish to customize Magento for your 00019 * needs please refer to http://www.magentocommerce.com for more information. 00020 * 00021 * @category Mage 00022 * @package Mage_Core 00023 * @copyright Copyright (c) 2008 Irubin Consulting Inc. DBA Varien (http://www.varien.com) 00024 * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) 00025 */ 00026 00027 00028 /** 00029 * Core Install 00030 * 00031 * @category Mage 00032 * @package Mage_Core 00033 * @author Magento Core Team <core@magentocommerce.com> 00034 */ 00035 $installer = $this; 00036 /* @var $installer Mage_Core_Model_Resource_Setup */ 00037 00038 $installer->startSetup(); 00039 $installer->run(" 00040 ALTER TABLE `{$installer->getTable('core_url_rewrite')}` 00041 DROP `entity_id`, 00042 DROP `type`, 00043 ADD `is_system` tinyint(1) unsigned default '1' AFTER `target_path`, 00044 DROP INDEX `store_id`, 00045 ADD INDEX `FK_CORE_URL_REWRITE_STORE` (`store_id`), 00046 DROP INDEX `id_path`, 00047 ADD UNIQUE `UNQ_PATH` (`store_id`, `id_path`, `is_system`), 00048 DROP INDEX `request_path`, 00049 ADD UNIQUE `UNQ_REQUEST_PATH` (`store_id`, `request_path`), 00050 DROP INDEX `target_path`, 00051 ADD INDEX `IDX_TARGET_PATH` (`store_id`, `target_path`); 00052 DROP TABLE IF EXISTS `{$installer->getTable('core_url_rewrite_tag')}`; 00053 "); 00054 $installer->endSetup();