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_Sales 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 $installer = $this; 00028 /* @var $installer Mage_Sales_Model_Mysql4_Setup */ 00029 00030 $installer->run(" 00031 ALTER TABLE `{$installer->getTable('sales_flat_quote_address')}` CHANGE `applied_taxes` `applied_taxes` TEXT; 00032 00033 CREATE TABLE `{$installer->getTable('sales_order_tax')}` ( 00034 `tax_id` int(10) unsigned NOT NULL auto_increment, 00035 `order_id` int(10) unsigned NOT NULL, 00036 `code` varchar(255) NOT NULL, 00037 `title` varchar(255) NOT NULL, 00038 `percent` decimal(12,4) NOT NULL, 00039 `priority` int(11) NOT NULL, 00040 `position` int(11) NOT NULL, 00041 PRIMARY KEY (`tax_id`), 00042 KEY `IDX_ORDER_TAX` (`order_id`,`priority`,`position`) 00043 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 00044 00045 ALTER TABLE `{$installer->getTable('sales_order_tax')}` ADD `amount` DECIMAL( 12, 4 ) NOT NULL AFTER `percent`; 00046 ");
1.5.8