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_Catalog 00023 * @copyright Copyright (c) 2009 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 $installer = $this; 00029 /* @var $installer Mage_Catalog_Model_Resource_Eav_Mysql4_Setup */ 00030 00031 $installer->startSetup(); 00032 $installer->getConnection()->addColumn($installer->getTable('catalog/product'), 'required_options', 'tinyint(1) unsigned NOT NULL default 0'); 00033 00034 $entityTypeId = 'catalog_product'; 00035 $attributeId = $installer->getAttributeId($entityTypeId, 'required_options'); 00036 $attributeTable = $installer->getAttributeTable($entityTypeId, $attributeId); 00037 00038 if ($attributeTable != $installer->getTable('catalog/product')) { 00039 $installer->run(" 00040 UPDATE `{$installer->getTable('catalog/product')}` AS `p` 00041 INNER JOIN `{$attributeTable}` AS `a` ON `p`.`entity_id`=`a`.`entity_id` 00042 AND `a`.`attribute_id`={$attributeId} AND `a`.`store_id`=0 00043 SET `p`.`required_options` = `a`.`value`; 00044 "); 00045 00046 $installer->updateAttribute($entityTypeId, $attributeId, 'backend_type', 'static'); 00047 00048 $installer->run(" 00049 DELETE FROM `{$attributeTable}` WHERE `attribute_id`={$attributeId}; 00050 "); 00051 } 00052 00053 $installer->endSetup();
1.5.8