Magento: app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-0.8.17-0.8.18.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 $this->startSetup();
00029 $this->run("
00030 ALTER TABLE `{$installer->getTable('sales_quote')}`
00031     change `is_active` `is_active` tinyint (1)UNSIGNED  DEFAULT '1' NULL ,
00032     change `is_virtual` `is_virtual` tinyint (1)UNSIGNED  DEFAULT '0' NULL ,
00033     change `is_multi_shipping` `is_multi_shipping` tinyint (1)UNSIGNED  DEFAULT '0' NULL ,
00034     change `is_multi_payment` `is_multi_payment` tinyint (1)UNSIGNED  DEFAULT '0' NULL ,
00035     change `customer_note_notify` `customer_note_notify` tinyint (1)UNSIGNED  DEFAULT '1' NULL ,
00036     change `customer_is_guest` `customer_is_guest` tinyint (1)UNSIGNED  DEFAULT '0' NULL ,
00037     change `quote_status_id` `quote_status_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00038     change `billing_address_id` `billing_address_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00039     change `orig_order_id` `orig_order_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00040     change `customer_id` `customer_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00041     change `customer_tax_class_id` `customer_tax_class_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00042     change `customer_group_id` `customer_group_id` int (10)UNSIGNED  DEFAULT '0' NULL ,
00043     change `items_count` `items_count` int (10)UNSIGNED  DEFAULT '0' NULL ,
00044     change `items_qty` `items_qty` decimal (12,4) DEFAULT '0.0000' NULL ,
00045     change `store_to_base_rate` `store_to_base_rate` decimal (12,4) DEFAULT '0.0000' NULL ,
00046     change `store_to_quote_rate` `store_to_quote_rate` decimal (12,4) DEFAULT '0.0000' NULL ,
00047     change `grand_total` `grand_total` decimal (12,4) DEFAULT '0.0000' NULL ,
00048     change `base_grand_total` `base_grand_total` decimal (12,4) DEFAULT '0.0000' NULL ,
00049     change `custbalance_amount` `custbalance_amount` decimal (12,4) DEFAULT '0.0000' NULL ,
00050     change `checkout_method` `checkout_method` varchar (255)  NULL  COLLATE utf8_general_ci ,
00051     change `password_hash` `password_hash` varchar (255)  NULL  COLLATE utf8_general_ci ,
00052     change `coupon_code` `coupon_code` varchar (255)  NULL  COLLATE utf8_general_ci ,
00053     change `giftcert_code` `giftcert_code` varchar (255)  NULL  COLLATE utf8_general_ci ,
00054     change `base_currency_code` `base_currency_code` varchar (255)  NULL  COLLATE utf8_general_ci ,
00055     change `store_currency_code` `store_currency_code` varchar (255)  NULL  COLLATE utf8_general_ci ,
00056     change `quote_currency_code` `quote_currency_code` varchar (255)  NULL  COLLATE utf8_general_ci ,
00057     change `customer_email` `customer_email` varchar (255)  NULL  COLLATE utf8_general_ci ,
00058     change `customer_firstname` `customer_firstname` varchar (255)  NULL  COLLATE utf8_general_ci ,
00059     change `customer_lastname` `customer_lastname` varchar (255)  NULL  COLLATE utf8_general_ci ,
00060     change `customer_note` `customer_note` varchar (255)  NULL  COLLATE utf8_general_ci ,
00061     change `remote_ip` `remote_ip` varchar (255)  NULL  COLLATE utf8_general_ci ,
00062     change `applied_rule_ids` `applied_rule_ids` varchar (255)  NULL  COLLATE utf8_general_ci
00063 ");
00064 $this->endSetup();
00065 $this->installEntities();