Magento: app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-0.8.19-0.8.20.php Source File

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 
00029 /* @var $installer Mage_Sales_Model_Entity_Setup */
00030 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'subtotal_refunded', 'decimal(12,4) NULL');
00031 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'subtotal_canceled', 'decimal(12,4) NULL');
00032 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'tax_refunded', 'decimal(12,4) NULL');
00033 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'tax_canceled', 'decimal(12,4) NULL');
00034 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'shipping_refunded', 'decimal(12,4) NULL');
00035 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'shipping_canceled', 'decimal(12,4) NULL');
00036 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_subtotal_refunded', 'decimal(12,4) NULL');
00037 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_subtotal_canceled', 'decimal(12,4) NULL');
00038 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_tax_refunded', 'decimal(12,4) NULL');
00039 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_tax_canceled', 'decimal(12,4) NULL');
00040 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_shipping_refunded', 'decimal(12,4) NULL');
00041 $installer->getConnection()->addColumn($this->getTable('sales_order'), 'base_shipping_canceled', 'decimal(12,4) NULL');
00042 
00043 $installer->addAttribute('order', 'subtotal_refunded', array('type'=>'static'));
00044 $installer->addAttribute('order', 'subtotal_canceled', array('type'=>'static'));
00045 $installer->addAttribute('order', 'tax_refunded', array('type'=>'static'));
00046 $installer->addAttribute('order', 'tax_canceled', array('type'=>'static'));
00047 $installer->addAttribute('order', 'shipping_refunded', array('type'=>'static'));
00048 $installer->addAttribute('order', 'shipping_canceled', array('type'=>'static'));
00049 $installer->addAttribute('order', 'base_subtotal_refunded', array('type'=>'static'));
00050 $installer->addAttribute('order', 'base_subtotal_canceled', array('type'=>'static'));
00051 $installer->addAttribute('order', 'base_tax_refunded', array('type'=>'static'));
00052 $installer->addAttribute('order', 'base_tax_canceled', array('type'=>'static'));
00053 $installer->addAttribute('order', 'base_shipping_refunded', array('type'=>'static'));
00054 $installer->addAttribute('order', 'base_shipping_canceled', array('type'=>'static'));