Zend_Db_Statement_Exception Object
(
    [_previous:Zend_Exception:private] => 
    [message:protected] => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes, query was: CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
    [string:Exception:private] => 
    [code:protected] => 8
    [file:protected] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 235
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php
                    [line] => 110
                    [function] => _execute
                    [class] => Zend_Db_Statement_Pdo
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Zend/Db/Statement.php
                    [line] => 291
                    [function] => _execute
                    [class] => Varien_Db_Statement_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Adapter/Abstract.php
                    [line] => 480
                    [function] => execute
                    [class] => Zend_Db_Statement
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

            [3] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 428
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 2117
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                        )

                )

            [6] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
                    [line] => 350
                    [function] => createTable
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Varien_Db_Ddl_Table Object
                                (
                                    [_tableName:protected] => sales_flat_order
                                    [_schemaName:protected] => 
                                    [_tableComment:protected] => Sales Flat Order
                                    [_columns:protected] => Array
                                        (
                                            [ENTITY_ID] => Array
                                                (
                                                    [COLUMN_NAME] => entity_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 0
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 1
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 1
                                                    [COMMENT] => Entity Id
                                                )

                                            [STATE] => Array
                                                (
                                                    [COLUMN_NAME] => state
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 1
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => State
                                                )

                                            [STATUS] => Array
                                                (
                                                    [COLUMN_NAME] => status
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 2
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Status
                                                )

                                            [COUPON_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => coupon_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 3
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Coupon Code
                                                )

                                            [PROTECT_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => protect_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 4
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Protect Code
                                                )

                                            [SHIPPING_DESCRIPTION] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_description
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 5
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Description
                                                )

                                            [IS_VIRTUAL] => Array
                                                (
                                                    [COLUMN_NAME] => is_virtual
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 6
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Is Virtual
                                                )

                                            [STORE_ID] => Array
                                                (
                                                    [COLUMN_NAME] => store_id
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 7
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store Id
                                                )

                                            [CUSTOMER_ID] => Array
                                                (
                                                    [COLUMN_NAME] => customer_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 8
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Id
                                                )

                                            [BASE_DISCOUNT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_discount_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 9
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Discount Amount
                                                )

                                            [BASE_DISCOUNT_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => base_discount_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 10
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Discount Canceled
                                                )

                                            [BASE_DISCOUNT_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_discount_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 11
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Discount Invoiced
                                                )

                                            [BASE_DISCOUNT_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_discount_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 12
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Discount Refunded
                                                )

                                            [BASE_GRAND_TOTAL] => Array
                                                (
                                                    [COLUMN_NAME] => base_grand_total
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 13
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Grand Total
                                                )

                                            [BASE_SHIPPING_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 14
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Amount
                                                )

                                            [BASE_SHIPPING_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 15
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Canceled
                                                )

                                            [BASE_SHIPPING_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 16
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Invoiced
                                                )

                                            [BASE_SHIPPING_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 17
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Refunded
                                                )

                                            [BASE_SHIPPING_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 18
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Tax Amount
                                                )

                                            [BASE_SHIPPING_TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 19
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Tax Refunded
                                                )

                                            [BASE_SUBTOTAL] => Array
                                                (
                                                    [COLUMN_NAME] => base_subtotal
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 20
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Subtotal
                                                )

                                            [BASE_SUBTOTAL_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => base_subtotal_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 21
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Subtotal Canceled
                                                )

                                            [BASE_SUBTOTAL_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_subtotal_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 22
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Subtotal Invoiced
                                                )

                                            [BASE_SUBTOTAL_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_subtotal_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 23
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Subtotal Refunded
                                                )

                                            [BASE_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 24
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Tax Amount
                                                )

                                            [BASE_TAX_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => base_tax_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 25
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Tax Canceled
                                                )

                                            [BASE_TAX_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_tax_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 26
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Tax Invoiced
                                                )

                                            [BASE_TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 27
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Tax Refunded
                                                )

                                            [BASE_TO_GLOBAL_RATE] => Array
                                                (
                                                    [COLUMN_NAME] => base_to_global_rate
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 28
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base To Global Rate
                                                )

                                            [BASE_TO_ORDER_RATE] => Array
                                                (
                                                    [COLUMN_NAME] => base_to_order_rate
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 29
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base To Order Rate
                                                )

                                            [BASE_TOTAL_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 30
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Canceled
                                                )

                                            [BASE_TOTAL_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 31
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Invoiced
                                                )

                                            [BASE_TOTAL_INVOICED_COST] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_invoiced_cost
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 32
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Invoiced Cost
                                                )

                                            [BASE_TOTAL_OFFLINE_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_offline_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 33
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Offline Refunded
                                                )

                                            [BASE_TOTAL_ONLINE_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_online_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 34
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Online Refunded
                                                )

                                            [BASE_TOTAL_PAID] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_paid
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 35
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Paid
                                                )

                                            [BASE_TOTAL_QTY_ORDERED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_qty_ordered
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 36
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Qty Ordered
                                                )

                                            [BASE_TOTAL_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 37
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Refunded
                                                )

                                            [DISCOUNT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => discount_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 38
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Discount Amount
                                                )

                                            [DISCOUNT_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => discount_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 39
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Discount Canceled
                                                )

                                            [DISCOUNT_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => discount_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 40
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Discount Invoiced
                                                )

                                            [DISCOUNT_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => discount_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 41
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Discount Refunded
                                                )

                                            [GRAND_TOTAL] => Array
                                                (
                                                    [COLUMN_NAME] => grand_total
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 42
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Grand Total
                                                )

                                            [SHIPPING_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 43
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Amount
                                                )

                                            [SHIPPING_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 44
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Canceled
                                                )

                                            [SHIPPING_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 45
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Invoiced
                                                )

                                            [SHIPPING_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 46
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Refunded
                                                )

                                            [SHIPPING_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 47
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Tax Amount
                                                )

                                            [SHIPPING_TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 48
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Tax Refunded
                                                )

                                            [STORE_TO_BASE_RATE] => Array
                                                (
                                                    [COLUMN_NAME] => store_to_base_rate
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 49
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store To Base Rate
                                                )

                                            [STORE_TO_ORDER_RATE] => Array
                                                (
                                                    [COLUMN_NAME] => store_to_order_rate
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 50
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store To Order Rate
                                                )

                                            [SUBTOTAL] => Array
                                                (
                                                    [COLUMN_NAME] => subtotal
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 51
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Subtotal
                                                )

                                            [SUBTOTAL_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => subtotal_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 52
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Subtotal Canceled
                                                )

                                            [SUBTOTAL_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => subtotal_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 53
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Subtotal Invoiced
                                                )

                                            [SUBTOTAL_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => subtotal_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 54
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Subtotal Refunded
                                                )

                                            [TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 55
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Tax Amount
                                                )

                                            [TAX_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => tax_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 56
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Tax Canceled
                                                )

                                            [TAX_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => tax_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 57
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Tax Invoiced
                                                )

                                            [TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 58
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Tax Refunded
                                                )

                                            [TOTAL_CANCELED] => Array
                                                (
                                                    [COLUMN_NAME] => total_canceled
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 59
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Canceled
                                                )

                                            [TOTAL_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => total_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 60
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Invoiced
                                                )

                                            [TOTAL_OFFLINE_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => total_offline_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 61
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Offline Refunded
                                                )

                                            [TOTAL_ONLINE_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => total_online_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 62
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Online Refunded
                                                )

                                            [TOTAL_PAID] => Array
                                                (
                                                    [COLUMN_NAME] => total_paid
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 63
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Paid
                                                )

                                            [TOTAL_QTY_ORDERED] => Array
                                                (
                                                    [COLUMN_NAME] => total_qty_ordered
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 64
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Qty Ordered
                                                )

                                            [TOTAL_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => total_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 65
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Refunded
                                                )

                                            [CAN_SHIP_PARTIALLY] => Array
                                                (
                                                    [COLUMN_NAME] => can_ship_partially
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 66
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Can Ship Partially
                                                )

                                            [CAN_SHIP_PARTIALLY_ITEM] => Array
                                                (
                                                    [COLUMN_NAME] => can_ship_partially_item
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 67
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Can Ship Partially Item
                                                )

                                            [CUSTOMER_IS_GUEST] => Array
                                                (
                                                    [COLUMN_NAME] => customer_is_guest
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 68
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Is Guest
                                                )

                                            [CUSTOMER_NOTE_NOTIFY] => Array
                                                (
                                                    [COLUMN_NAME] => customer_note_notify
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 69
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Note Notify
                                                )

                                            [BILLING_ADDRESS_ID] => Array
                                                (
                                                    [COLUMN_NAME] => billing_address_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 70
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Billing Address Id
                                                )

                                            [CUSTOMER_GROUP_ID] => Array
                                                (
                                                    [COLUMN_NAME] => customer_group_id
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 71
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Group Id
                                                )

                                            [EDIT_INCREMENT] => Array
                                                (
                                                    [COLUMN_NAME] => edit_increment
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 72
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Edit Increment
                                                )

                                            [EMAIL_SENT] => Array
                                                (
                                                    [COLUMN_NAME] => email_sent
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 73
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Email Sent
                                                )

                                            [FORCED_SHIPMENT_WITH_INVOICE] => Array
                                                (
                                                    [COLUMN_NAME] => forced_shipment_with_invoice
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 74
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Forced Do Shipment With Invoice
                                                )

                                            [PAYMENT_AUTH_EXPIRATION] => Array
                                                (
                                                    [COLUMN_NAME] => payment_auth_expiration
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 75
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Payment Authorization Expiration
                                                )

                                            [QUOTE_ADDRESS_ID] => Array
                                                (
                                                    [COLUMN_NAME] => quote_address_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 76
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Quote Address Id
                                                )

                                            [QUOTE_ID] => Array
                                                (
                                                    [COLUMN_NAME] => quote_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 77
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Quote Id
                                                )

                                            [SHIPPING_ADDRESS_ID] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_address_id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 78
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Address Id
                                                )

                                            [ADJUSTMENT_NEGATIVE] => Array
                                                (
                                                    [COLUMN_NAME] => adjustment_negative
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 79
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Adjustment Negative
                                                )

                                            [ADJUSTMENT_POSITIVE] => Array
                                                (
                                                    [COLUMN_NAME] => adjustment_positive
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 80
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Adjustment Positive
                                                )

                                            [BASE_ADJUSTMENT_NEGATIVE] => Array
                                                (
                                                    [COLUMN_NAME] => base_adjustment_negative
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 81
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Adjustment Negative
                                                )

                                            [BASE_ADJUSTMENT_POSITIVE] => Array
                                                (
                                                    [COLUMN_NAME] => base_adjustment_positive
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 82
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Adjustment Positive
                                                )

                                            [BASE_SHIPPING_DISCOUNT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_discount_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 83
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Discount Amount
                                                )

                                            [BASE_SUBTOTAL_INCL_TAX] => Array
                                                (
                                                    [COLUMN_NAME] => base_subtotal_incl_tax
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 84
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Subtotal Incl Tax
                                                )

                                            [BASE_TOTAL_DUE] => Array
                                                (
                                                    [COLUMN_NAME] => base_total_due
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 85
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Total Due
                                                )

                                            [PAYMENT_AUTHORIZATION_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => payment_authorization_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 86
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Payment Authorization Amount
                                                )

                                            [SHIPPING_DISCOUNT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_discount_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 87
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Discount Amount
                                                )

                                            [SUBTOTAL_INCL_TAX] => Array
                                                (
                                                    [COLUMN_NAME] => subtotal_incl_tax
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 88
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Subtotal Incl Tax
                                                )

                                            [TOTAL_DUE] => Array
                                                (
                                                    [COLUMN_NAME] => total_due
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 89
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Due
                                                )

                                            [WEIGHT] => Array
                                                (
                                                    [COLUMN_NAME] => weight
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 90
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Weight
                                                )

                                            [CUSTOMER_DOB] => Array
                                                (
                                                    [COLUMN_NAME] => customer_dob
                                                    [COLUMN_TYPE] => datetime
                                                    [COLUMN_POSITION] => 91
                                                    [DATA_TYPE] => datetime
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Dob
                                                )

                                            [INCREMENT_ID] => Array
                                                (
                                                    [COLUMN_NAME] => increment_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 92
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 50
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Increment Id
                                                )

                                            [APPLIED_RULE_IDS] => Array
                                                (
                                                    [COLUMN_NAME] => applied_rule_ids
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 93
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Applied Rule Ids
                                                )

                                            [BASE_CURRENCY_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => base_currency_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 94
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 3
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Currency Code
                                                )

                                            [CUSTOMER_EMAIL] => Array
                                                (
                                                    [COLUMN_NAME] => customer_email
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 95
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Email
                                                )

                                            [CUSTOMER_FIRSTNAME] => Array
                                                (
                                                    [COLUMN_NAME] => customer_firstname
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 96
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Firstname
                                                )

                                            [CUSTOMER_LASTNAME] => Array
                                                (
                                                    [COLUMN_NAME] => customer_lastname
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 97
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Lastname
                                                )

                                            [CUSTOMER_MIDDLENAME] => Array
                                                (
                                                    [COLUMN_NAME] => customer_middlename
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 98
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Middlename
                                                )

                                            [CUSTOMER_PREFIX] => Array
                                                (
                                                    [COLUMN_NAME] => customer_prefix
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 99
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Prefix
                                                )

                                            [CUSTOMER_SUFFIX] => Array
                                                (
                                                    [COLUMN_NAME] => customer_suffix
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 100
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Suffix
                                                )

                                            [CUSTOMER_TAXVAT] => Array
                                                (
                                                    [COLUMN_NAME] => customer_taxvat
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 101
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Taxvat
                                                )

                                            [DISCOUNT_DESCRIPTION] => Array
                                                (
                                                    [COLUMN_NAME] => discount_description
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 102
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Discount Description
                                                )

                                            [EXT_CUSTOMER_ID] => Array
                                                (
                                                    [COLUMN_NAME] => ext_customer_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 103
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Ext Customer Id
                                                )

                                            [EXT_ORDER_ID] => Array
                                                (
                                                    [COLUMN_NAME] => ext_order_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 104
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Ext Order Id
                                                )

                                            [GLOBAL_CURRENCY_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => global_currency_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 105
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 3
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Global Currency Code
                                                )

                                            [HOLD_BEFORE_STATE] => Array
                                                (
                                                    [COLUMN_NAME] => hold_before_state
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 106
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Hold Before State
                                                )

                                            [HOLD_BEFORE_STATUS] => Array
                                                (
                                                    [COLUMN_NAME] => hold_before_status
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 107
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Hold Before Status
                                                )

                                            [ORDER_CURRENCY_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => order_currency_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 108
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Order Currency Code
                                                )

                                            [ORIGINAL_INCREMENT_ID] => Array
                                                (
                                                    [COLUMN_NAME] => original_increment_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 109
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 50
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Original Increment Id
                                                )

                                            [RELATION_CHILD_ID] => Array
                                                (
                                                    [COLUMN_NAME] => relation_child_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 110
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Relation Child Id
                                                )

                                            [RELATION_CHILD_REAL_ID] => Array
                                                (
                                                    [COLUMN_NAME] => relation_child_real_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 111
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Relation Child Real Id
                                                )

                                            [RELATION_PARENT_ID] => Array
                                                (
                                                    [COLUMN_NAME] => relation_parent_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 112
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Relation Parent Id
                                                )

                                            [RELATION_PARENT_REAL_ID] => Array
                                                (
                                                    [COLUMN_NAME] => relation_parent_real_id
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 113
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 32
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Relation Parent Real Id
                                                )

                                            [REMOTE_IP] => Array
                                                (
                                                    [COLUMN_NAME] => remote_ip
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 114
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Remote Ip
                                                )

                                            [SHIPPING_METHOD] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_method
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 115
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Method
                                                )

                                            [STORE_CURRENCY_CODE] => Array
                                                (
                                                    [COLUMN_NAME] => store_currency_code
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 116
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 3
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store Currency Code
                                                )

                                            [STORE_NAME] => Array
                                                (
                                                    [COLUMN_NAME] => store_name
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 117
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Store Name
                                                )

                                            [X_FORWARDED_FOR] => Array
                                                (
                                                    [COLUMN_NAME] => x_forwarded_for
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 118
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 255
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => X Forwarded For
                                                )

                                            [CUSTOMER_NOTE] => Array
                                                (
                                                    [COLUMN_NAME] => customer_note
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 119
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 64k
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Note
                                                )

                                            [CREATED_AT] => Array
                                                (
                                                    [COLUMN_NAME] => created_at
                                                    [COLUMN_TYPE] => timestamp
                                                    [COLUMN_POSITION] => 120
                                                    [DATA_TYPE] => timestamp
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Created At
                                                )

                                            [UPDATED_AT] => Array
                                                (
                                                    [COLUMN_NAME] => updated_at
                                                    [COLUMN_TYPE] => timestamp
                                                    [COLUMN_POSITION] => 121
                                                    [DATA_TYPE] => timestamp
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Updated At
                                                )

                                            [TOTAL_ITEM_COUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_item_count
                                                    [COLUMN_TYPE] => smallint
                                                    [COLUMN_POSITION] => 122
                                                    [DATA_TYPE] => smallint
                                                    [DEFAULT] => 0
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Item Count
                                                )

                                            [CUSTOMER_GENDER] => Array
                                                (
                                                    [COLUMN_NAME] => customer_gender
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 123
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Customer Gender
                                                )

                                            [HIDDEN_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => hidden_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 124
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Hidden Tax Amount
                                                )

                                            [BASE_HIDDEN_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_hidden_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 125
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Hidden Tax Amount
                                                )

                                            [SHIPPING_HIDDEN_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_hidden_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 126
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Hidden Tax Amount
                                                )

                                            [BASE_SHIPPING_HIDDEN_TAX_AMNT] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_hidden_tax_amnt
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 127
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Hidden Tax Amount
                                                )

                                            [HIDDEN_TAX_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => hidden_tax_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 128
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Hidden Tax Invoiced
                                                )

                                            [BASE_HIDDEN_TAX_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => base_hidden_tax_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 129
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Hidden Tax Invoiced
                                                )

                                            [HIDDEN_TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => hidden_tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 130
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Hidden Tax Refunded
                                                )

                                            [BASE_HIDDEN_TAX_REFUNDED] => Array
                                                (
                                                    [COLUMN_NAME] => base_hidden_tax_refunded
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 131
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Hidden Tax Refunded
                                                )

                                            [SHIPPING_INCL_TAX] => Array
                                                (
                                                    [COLUMN_NAME] => shipping_incl_tax
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 132
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Shipping Incl Tax
                                                )

                                            [BASE_SHIPPING_INCL_TAX] => Array
                                                (
                                                    [COLUMN_NAME] => base_shipping_incl_tax
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 133
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Base Shipping Incl Tax
                                                )

                                        )

                                    [_indexes:protected] => Array
                                        (
                                            [IDX_SALES_FLAT_ORDER_STATUS] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STATUS
                                                    [COLUMNS] => Array
                                                        (
                                                            [STATUS] => Array
                                                                (
                                                                    [NAME] => status
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_STATE] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STATE
                                                    [COLUMNS] => Array
                                                        (
                                                            [STATE] => Array
                                                                (
                                                                    [NAME] => state
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_STORE_ID] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STORE_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [STORE_ID] => Array
                                                                (
                                                                    [NAME] => store_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [UNQ_SALES_FLAT_ORDER_INCREMENT_ID] => Array
                                                (
                                                    [INDEX_NAME] => UNQ_SALES_FLAT_ORDER_INCREMENT_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [INCREMENT_ID] => Array
                                                                (
                                                                    [NAME] => increment_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => unique
                                                )

                                            [IDX_SALES_FLAT_ORDER_CREATED_AT] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_CREATED_AT
                                                    [COLUMNS] => Array
                                                        (
                                                            [CREATED_AT] => Array
                                                                (
                                                                    [NAME] => created_at
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_CUSTOMER_ID] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_CUSTOMER_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [CUSTOMER_ID] => Array
                                                                (
                                                                    [NAME] => customer_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_EXT_ORDER_ID] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_EXT_ORDER_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [EXT_ORDER_ID] => Array
                                                                (
                                                                    [NAME] => ext_order_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_QUOTE_ID] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_QUOTE_ID
                                                    [COLUMNS] => Array
                                                        (
                                                            [QUOTE_ID] => Array
                                                                (
                                                                    [NAME] => quote_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                            [IDX_SALES_FLAT_ORDER_UPDATED_AT] => Array
                                                (
                                                    [INDEX_NAME] => IDX_SALES_FLAT_ORDER_UPDATED_AT
                                                    [COLUMNS] => Array
                                                        (
                                                            [UPDATED_AT] => Array
                                                                (
                                                                    [NAME] => updated_at
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                        )

                                                    [TYPE] => index
                                                )

                                        )

                                    [_foreignKeys:protected] => Array
                                        (
                                            [FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID] => Array
                                                (
                                                    [FK_NAME] => FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID
                                                    [COLUMN_NAME] => customer_id
                                                    [REF_TABLE_NAME] => customer_entity
                                                    [REF_COLUMN_NAME] => entity_id
                                                    [ON_DELETE] => SET NULL
                                                    [ON_UPDATE] => CASCADE
                                                )

                                            [FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                (
                                                    [FK_NAME] => FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID
                                                    [COLUMN_NAME] => store_id
                                                    [REF_TABLE_NAME] => core_store
                                                    [REF_COLUMN_NAME] => store_id
                                                    [ON_DELETE] => SET NULL
                                                    [ON_UPDATE] => CASCADE
                                                )

                                        )

                                    [_options:protected] => Array
                                        (
                                            [type] => INNODB
                                            [charset] => utf8
                                            [collate] => utf8_general_ci
                                        )

                                )

                        )

                )

            [7] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
                        )

                    [function] => include
                )

            [8] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 421
                    [function] => _modifyResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => install
                            [1] => 
                            [2] => 1.6.0.8
                        )

                )

            [9] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 327
                    [function] => _installResourceDb
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 1.6.0.8
                        )

                )

            [10] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 235
                    [function] => applyUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [11] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/App.php
                    [line] => 417
                    [function] => applyAllUpdates
                    [class] => Mage_Core_Model_Resource_Setup
                    [type] => ::
                    [args] => Array
                        (
                        )

                )

            [12] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/App.php
                    [line] => 343
                    [function] => _initModules
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [13] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/app/Mage.php
                    [line] => 684
                    [function] => run
                    [class] => Mage_Core_Model_App
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [scope_code] => 
                                    [scope_type] => store
                                    [options] => Array
                                        (
                                        )

                                )

                        )

                )

            [14] => Array
                (
                    [file] => /home/web/adidasshoesale.ca/htdocs/index.php
                    [line] => 87
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => store
                        )

                )

        )

    [previous:Exception:private] => PDOException Object
        (
            [message:protected] => SQLSTATE[08S01]: Communication link failure: 1153 Got a packet bigger than 'max_allowed_packet' bytes
            [string:Exception:private] => 
            [code:protected] => 08S01
            [file:protected] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Statement/Pdo.php
            [line:protected] => 228
            [trace:Exception:private] => Array
                (
                    [0] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Statement/Pdo.php
                            [line] => 228
                            [function] => execute
                            [class] => PDOStatement
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Statement/Pdo/Mysql.php
                            [line] => 110
                            [function] => _execute
                            [class] => Zend_Db_Statement_Pdo
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

                    [2] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Zend/Db/Statement.php
                            [line] => 291
                            [function] => _execute
                            [class] => Varien_Db_Statement_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

                    [3] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Adapter/Abstract.php
                            [line] => 480
                            [function] => execute
                            [class] => Zend_Db_Statement
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

                    [4] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Zend/Db/Adapter/Pdo/Abstract.php
                            [line] => 238
                            [function] => query
                            [class] => Zend_Db_Adapter_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [5] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 428
                            [function] => query
                            [class] => Zend_Db_Adapter_Pdo_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [6] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 2117
                            [function] => query
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_flat_order` (
  `entity_id` int UNSIGNED NOT NULL auto_increment COMMENT 'Entity Id' ,
  `state` varchar(32) NULL COMMENT 'State' ,
  `status` varchar(32) NULL COMMENT 'Status' ,
  `coupon_code` varchar(255) NULL COMMENT 'Coupon Code' ,
  `protect_code` varchar(255) NULL COMMENT 'Protect Code' ,
  `shipping_description` varchar(255) NULL COMMENT 'Shipping Description' ,
  `is_virtual` smallint UNSIGNED NULL COMMENT 'Is Virtual' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
  `base_discount_amount` decimal(12,4) NULL COMMENT 'Base Discount Amount' ,
  `base_discount_canceled` decimal(12,4) NULL COMMENT 'Base Discount Canceled' ,
  `base_discount_invoiced` decimal(12,4) NULL COMMENT 'Base Discount Invoiced' ,
  `base_discount_refunded` decimal(12,4) NULL COMMENT 'Base Discount Refunded' ,
  `base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
  `base_shipping_amount` decimal(12,4) NULL COMMENT 'Base Shipping Amount' ,
  `base_shipping_canceled` decimal(12,4) NULL COMMENT 'Base Shipping Canceled' ,
  `base_shipping_invoiced` decimal(12,4) NULL COMMENT 'Base Shipping Invoiced' ,
  `base_shipping_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Refunded' ,
  `base_shipping_tax_amount` decimal(12,4) NULL COMMENT 'Base Shipping Tax Amount' ,
  `base_shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Base Shipping Tax Refunded' ,
  `base_subtotal` decimal(12,4) NULL COMMENT 'Base Subtotal' ,
  `base_subtotal_canceled` decimal(12,4) NULL COMMENT 'Base Subtotal Canceled' ,
  `base_subtotal_invoiced` decimal(12,4) NULL COMMENT 'Base Subtotal Invoiced' ,
  `base_subtotal_refunded` decimal(12,4) NULL COMMENT 'Base Subtotal Refunded' ,
  `base_tax_amount` decimal(12,4) NULL COMMENT 'Base Tax Amount' ,
  `base_tax_canceled` decimal(12,4) NULL COMMENT 'Base Tax Canceled' ,
  `base_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Tax Invoiced' ,
  `base_tax_refunded` decimal(12,4) NULL COMMENT 'Base Tax Refunded' ,
  `base_to_global_rate` decimal(12,4) NULL COMMENT 'Base To Global Rate' ,
  `base_to_order_rate` decimal(12,4) NULL COMMENT 'Base To Order Rate' ,
  `base_total_canceled` decimal(12,4) NULL COMMENT 'Base Total Canceled' ,
  `base_total_invoiced` decimal(12,4) NULL COMMENT 'Base Total Invoiced' ,
  `base_total_invoiced_cost` decimal(12,4) NULL COMMENT 'Base Total Invoiced Cost' ,
  `base_total_offline_refunded` decimal(12,4) NULL COMMENT 'Base Total Offline Refunded' ,
  `base_total_online_refunded` decimal(12,4) NULL COMMENT 'Base Total Online Refunded' ,
  `base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
  `base_total_qty_ordered` decimal(12,4) NULL COMMENT 'Base Total Qty Ordered' ,
  `base_total_refunded` decimal(12,4) NULL COMMENT 'Base Total Refunded' ,
  `discount_amount` decimal(12,4) NULL COMMENT 'Discount Amount' ,
  `discount_canceled` decimal(12,4) NULL COMMENT 'Discount Canceled' ,
  `discount_invoiced` decimal(12,4) NULL COMMENT 'Discount Invoiced' ,
  `discount_refunded` decimal(12,4) NULL COMMENT 'Discount Refunded' ,
  `grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
  `shipping_amount` decimal(12,4) NULL COMMENT 'Shipping Amount' ,
  `shipping_canceled` decimal(12,4) NULL COMMENT 'Shipping Canceled' ,
  `shipping_invoiced` decimal(12,4) NULL COMMENT 'Shipping Invoiced' ,
  `shipping_refunded` decimal(12,4) NULL COMMENT 'Shipping Refunded' ,
  `shipping_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Tax Amount' ,
  `shipping_tax_refunded` decimal(12,4) NULL COMMENT 'Shipping Tax Refunded' ,
  `store_to_base_rate` decimal(12,4) NULL COMMENT 'Store To Base Rate' ,
  `store_to_order_rate` decimal(12,4) NULL COMMENT 'Store To Order Rate' ,
  `subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
  `subtotal_canceled` decimal(12,4) NULL COMMENT 'Subtotal Canceled' ,
  `subtotal_invoiced` decimal(12,4) NULL COMMENT 'Subtotal Invoiced' ,
  `subtotal_refunded` decimal(12,4) NULL COMMENT 'Subtotal Refunded' ,
  `tax_amount` decimal(12,4) NULL COMMENT 'Tax Amount' ,
  `tax_canceled` decimal(12,4) NULL COMMENT 'Tax Canceled' ,
  `tax_invoiced` decimal(12,4) NULL COMMENT 'Tax Invoiced' ,
  `tax_refunded` decimal(12,4) NULL COMMENT 'Tax Refunded' ,
  `total_canceled` decimal(12,4) NULL COMMENT 'Total Canceled' ,
  `total_invoiced` decimal(12,4) NULL COMMENT 'Total Invoiced' ,
  `total_offline_refunded` decimal(12,4) NULL COMMENT 'Total Offline Refunded' ,
  `total_online_refunded` decimal(12,4) NULL COMMENT 'Total Online Refunded' ,
  `total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
  `total_qty_ordered` decimal(12,4) NULL COMMENT 'Total Qty Ordered' ,
  `total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
  `can_ship_partially` smallint UNSIGNED NULL COMMENT 'Can Ship Partially' ,
  `can_ship_partially_item` smallint UNSIGNED NULL COMMENT 'Can Ship Partially Item' ,
  `customer_is_guest` smallint UNSIGNED NULL COMMENT 'Customer Is Guest' ,
  `customer_note_notify` smallint UNSIGNED NULL COMMENT 'Customer Note Notify' ,
  `billing_address_id` int NULL COMMENT 'Billing Address Id' ,
  `customer_group_id` smallint NULL COMMENT 'Customer Group Id' ,
  `edit_increment` int NULL COMMENT 'Edit Increment' ,
  `email_sent` smallint UNSIGNED NULL COMMENT 'Email Sent' ,
  `forced_shipment_with_invoice` smallint UNSIGNED NULL COMMENT 'Forced Do Shipment With Invoice' ,
  `payment_auth_expiration` int NULL COMMENT 'Payment Authorization Expiration' ,
  `quote_address_id` int NULL COMMENT 'Quote Address Id' ,
  `quote_id` int NULL COMMENT 'Quote Id' ,
  `shipping_address_id` int NULL COMMENT 'Shipping Address Id' ,
  `adjustment_negative` decimal(12,4) NULL COMMENT 'Adjustment Negative' ,
  `adjustment_positive` decimal(12,4) NULL COMMENT 'Adjustment Positive' ,
  `base_adjustment_negative` decimal(12,4) NULL COMMENT 'Base Adjustment Negative' ,
  `base_adjustment_positive` decimal(12,4) NULL COMMENT 'Base Adjustment Positive' ,
  `base_shipping_discount_amount` decimal(12,4) NULL COMMENT 'Base Shipping Discount Amount' ,
  `base_subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Base Subtotal Incl Tax' ,
  `base_total_due` decimal(12,4) NULL COMMENT 'Base Total Due' ,
  `payment_authorization_amount` decimal(12,4) NULL COMMENT 'Payment Authorization Amount' ,
  `shipping_discount_amount` decimal(12,4) NULL COMMENT 'Shipping Discount Amount' ,
  `subtotal_incl_tax` decimal(12,4) NULL COMMENT 'Subtotal Incl Tax' ,
  `total_due` decimal(12,4) NULL COMMENT 'Total Due' ,
  `weight` decimal(12,4) NULL COMMENT 'Weight' ,
  `customer_dob` datetime NULL COMMENT 'Customer Dob' ,
  `increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
  `applied_rule_ids` varchar(255) NULL COMMENT 'Applied Rule Ids' ,
  `base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
  `customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
  `customer_firstname` varchar(255) NULL COMMENT 'Customer Firstname' ,
  `customer_lastname` varchar(255) NULL COMMENT 'Customer Lastname' ,
  `customer_middlename` varchar(255) NULL COMMENT 'Customer Middlename' ,
  `customer_prefix` varchar(255) NULL COMMENT 'Customer Prefix' ,
  `customer_suffix` varchar(255) NULL COMMENT 'Customer Suffix' ,
  `customer_taxvat` varchar(255) NULL COMMENT 'Customer Taxvat' ,
  `discount_description` varchar(255) NULL COMMENT 'Discount Description' ,
  `ext_customer_id` varchar(255) NULL COMMENT 'Ext Customer Id' ,
  `ext_order_id` varchar(255) NULL COMMENT 'Ext Order Id' ,
  `global_currency_code` varchar(3) NULL COMMENT 'Global Currency Code' ,
  `hold_before_state` varchar(255) NULL COMMENT 'Hold Before State' ,
  `hold_before_status` varchar(255) NULL COMMENT 'Hold Before Status' ,
  `order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
  `original_increment_id` varchar(50) NULL COMMENT 'Original Increment Id' ,
  `relation_child_id` varchar(32) NULL COMMENT 'Relation Child Id' ,
  `relation_child_real_id` varchar(32) NULL COMMENT 'Relation Child Real Id' ,
  `relation_parent_id` varchar(32) NULL COMMENT 'Relation Parent Id' ,
  `relation_parent_real_id` varchar(32) NULL COMMENT 'Relation Parent Real Id' ,
  `remote_ip` varchar(255) NULL COMMENT 'Remote Ip' ,
  `shipping_method` varchar(255) NULL COMMENT 'Shipping Method' ,
  `store_currency_code` varchar(3) NULL COMMENT 'Store Currency Code' ,
  `store_name` varchar(255) NULL COMMENT 'Store Name' ,
  `x_forwarded_for` varchar(255) NULL COMMENT 'X Forwarded For' ,
  `customer_note` text NULL COMMENT 'Customer Note' ,
  `created_at` timestamp NULL default NULL COMMENT 'Created At' ,
  `updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
  `total_item_count` smallint UNSIGNED NOT NULL default '0' COMMENT 'Total Item Count' ,
  `customer_gender` int NULL COMMENT 'Customer Gender' ,
  `hidden_tax_amount` decimal(12,4) NULL COMMENT 'Hidden Tax Amount' ,
  `base_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Base Hidden Tax Amount' ,
  `shipping_hidden_tax_amount` decimal(12,4) NULL COMMENT 'Shipping Hidden Tax Amount' ,
  `base_shipping_hidden_tax_amnt` decimal(12,4) NULL COMMENT 'Base Shipping Hidden Tax Amount' ,
  `hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Hidden Tax Invoiced' ,
  `base_hidden_tax_invoiced` decimal(12,4) NULL COMMENT 'Base Hidden Tax Invoiced' ,
  `hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Hidden Tax Refunded' ,
  `base_hidden_tax_refunded` decimal(12,4) NULL COMMENT 'Base Hidden Tax Refunded' ,
  `shipping_incl_tax` decimal(12,4) NULL COMMENT 'Shipping Incl Tax' ,
  `base_shipping_incl_tax` decimal(12,4) NULL COMMENT 'Base Shipping Incl Tax' ,
  PRIMARY KEY (`entity_id`),
  INDEX `IDX_SALES_FLAT_ORDER_STATUS` (`status`),
  INDEX `IDX_SALES_FLAT_ORDER_STATE` (`state`),
  INDEX `IDX_SALES_FLAT_ORDER_STORE_ID` (`store_id`),
  UNIQUE `UNQ_SALES_FLAT_ORDER_INCREMENT_ID` (`increment_id`),
  INDEX `IDX_SALES_FLAT_ORDER_CREATED_AT` (`created_at`),
  INDEX `IDX_SALES_FLAT_ORDER_CUSTOMER_ID` (`customer_id`),
  INDEX `IDX_SALES_FLAT_ORDER_EXT_ORDER_ID` (`ext_order_id`),
  INDEX `IDX_SALES_FLAT_ORDER_QUOTE_ID` (`quote_id`),
  INDEX `IDX_SALES_FLAT_ORDER_UPDATED_AT` (`updated_at`),
  CONSTRAINT `FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Flat Order' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci
                                )

                        )

                    [7] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
                            [line] => 350
                            [function] => createTable
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Varien_Db_Ddl_Table Object
                                        (
                                            [_tableName:protected] => sales_flat_order
                                            [_schemaName:protected] => 
                                            [_tableComment:protected] => Sales Flat Order
                                            [_columns:protected] => Array
                                                (
                                                    [ENTITY_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => entity_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 0
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 1
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 1
                                                            [COMMENT] => Entity Id
                                                        )

                                                    [STATE] => Array
                                                        (
                                                            [COLUMN_NAME] => state
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 1
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => State
                                                        )

                                                    [STATUS] => Array
                                                        (
                                                            [COLUMN_NAME] => status
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 2
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Status
                                                        )

                                                    [COUPON_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => coupon_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 3
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Coupon Code
                                                        )

                                                    [PROTECT_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => protect_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 4
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Protect Code
                                                        )

                                                    [SHIPPING_DESCRIPTION] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_description
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 5
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Description
                                                        )

                                                    [IS_VIRTUAL] => Array
                                                        (
                                                            [COLUMN_NAME] => is_virtual
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 6
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Is Virtual
                                                        )

                                                    [STORE_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => store_id
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 7
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store Id
                                                        )

                                                    [CUSTOMER_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 8
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Id
                                                        )

                                                    [BASE_DISCOUNT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_discount_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 9
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Discount Amount
                                                        )

                                                    [BASE_DISCOUNT_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_discount_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 10
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Discount Canceled
                                                        )

                                                    [BASE_DISCOUNT_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_discount_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 11
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Discount Invoiced
                                                        )

                                                    [BASE_DISCOUNT_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_discount_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 12
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Discount Refunded
                                                        )

                                                    [BASE_GRAND_TOTAL] => Array
                                                        (
                                                            [COLUMN_NAME] => base_grand_total
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 13
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Grand Total
                                                        )

                                                    [BASE_SHIPPING_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 14
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Amount
                                                        )

                                                    [BASE_SHIPPING_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 15
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Canceled
                                                        )

                                                    [BASE_SHIPPING_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 16
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Invoiced
                                                        )

                                                    [BASE_SHIPPING_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 17
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Refunded
                                                        )

                                                    [BASE_SHIPPING_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 18
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Tax Amount
                                                        )

                                                    [BASE_SHIPPING_TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 19
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Tax Refunded
                                                        )

                                                    [BASE_SUBTOTAL] => Array
                                                        (
                                                            [COLUMN_NAME] => base_subtotal
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 20
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Subtotal
                                                        )

                                                    [BASE_SUBTOTAL_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_subtotal_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 21
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Subtotal Canceled
                                                        )

                                                    [BASE_SUBTOTAL_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_subtotal_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 22
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Subtotal Invoiced
                                                        )

                                                    [BASE_SUBTOTAL_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_subtotal_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 23
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Subtotal Refunded
                                                        )

                                                    [BASE_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 24
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Tax Amount
                                                        )

                                                    [BASE_TAX_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_tax_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 25
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Tax Canceled
                                                        )

                                                    [BASE_TAX_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_tax_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 26
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Tax Invoiced
                                                        )

                                                    [BASE_TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 27
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Tax Refunded
                                                        )

                                                    [BASE_TO_GLOBAL_RATE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_to_global_rate
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 28
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base To Global Rate
                                                        )

                                                    [BASE_TO_ORDER_RATE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_to_order_rate
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 29
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base To Order Rate
                                                        )

                                                    [BASE_TOTAL_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 30
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Canceled
                                                        )

                                                    [BASE_TOTAL_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 31
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Invoiced
                                                        )

                                                    [BASE_TOTAL_INVOICED_COST] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_invoiced_cost
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 32
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Invoiced Cost
                                                        )

                                                    [BASE_TOTAL_OFFLINE_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_offline_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 33
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Offline Refunded
                                                        )

                                                    [BASE_TOTAL_ONLINE_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_online_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 34
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Online Refunded
                                                        )

                                                    [BASE_TOTAL_PAID] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_paid
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 35
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Paid
                                                        )

                                                    [BASE_TOTAL_QTY_ORDERED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_qty_ordered
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 36
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Qty Ordered
                                                        )

                                                    [BASE_TOTAL_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 37
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Refunded
                                                        )

                                                    [DISCOUNT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => discount_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 38
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Discount Amount
                                                        )

                                                    [DISCOUNT_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => discount_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 39
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Discount Canceled
                                                        )

                                                    [DISCOUNT_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => discount_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 40
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Discount Invoiced
                                                        )

                                                    [DISCOUNT_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => discount_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 41
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Discount Refunded
                                                        )

                                                    [GRAND_TOTAL] => Array
                                                        (
                                                            [COLUMN_NAME] => grand_total
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 42
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Grand Total
                                                        )

                                                    [SHIPPING_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 43
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Amount
                                                        )

                                                    [SHIPPING_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 44
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Canceled
                                                        )

                                                    [SHIPPING_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 45
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Invoiced
                                                        )

                                                    [SHIPPING_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 46
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Refunded
                                                        )

                                                    [SHIPPING_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 47
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Tax Amount
                                                        )

                                                    [SHIPPING_TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 48
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Tax Refunded
                                                        )

                                                    [STORE_TO_BASE_RATE] => Array
                                                        (
                                                            [COLUMN_NAME] => store_to_base_rate
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 49
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store To Base Rate
                                                        )

                                                    [STORE_TO_ORDER_RATE] => Array
                                                        (
                                                            [COLUMN_NAME] => store_to_order_rate
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 50
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store To Order Rate
                                                        )

                                                    [SUBTOTAL] => Array
                                                        (
                                                            [COLUMN_NAME] => subtotal
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 51
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Subtotal
                                                        )

                                                    [SUBTOTAL_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => subtotal_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 52
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Subtotal Canceled
                                                        )

                                                    [SUBTOTAL_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => subtotal_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 53
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Subtotal Invoiced
                                                        )

                                                    [SUBTOTAL_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => subtotal_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 54
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Subtotal Refunded
                                                        )

                                                    [TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 55
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Tax Amount
                                                        )

                                                    [TAX_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => tax_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 56
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Tax Canceled
                                                        )

                                                    [TAX_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => tax_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 57
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Tax Invoiced
                                                        )

                                                    [TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 58
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Tax Refunded
                                                        )

                                                    [TOTAL_CANCELED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_canceled
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 59
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Canceled
                                                        )

                                                    [TOTAL_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 60
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Invoiced
                                                        )

                                                    [TOTAL_OFFLINE_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_offline_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 61
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Offline Refunded
                                                        )

                                                    [TOTAL_ONLINE_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_online_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 62
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Online Refunded
                                                        )

                                                    [TOTAL_PAID] => Array
                                                        (
                                                            [COLUMN_NAME] => total_paid
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 63
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Paid
                                                        )

                                                    [TOTAL_QTY_ORDERED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_qty_ordered
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 64
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Qty Ordered
                                                        )

                                                    [TOTAL_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 65
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Refunded
                                                        )

                                                    [CAN_SHIP_PARTIALLY] => Array
                                                        (
                                                            [COLUMN_NAME] => can_ship_partially
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 66
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Can Ship Partially
                                                        )

                                                    [CAN_SHIP_PARTIALLY_ITEM] => Array
                                                        (
                                                            [COLUMN_NAME] => can_ship_partially_item
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 67
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Can Ship Partially Item
                                                        )

                                                    [CUSTOMER_IS_GUEST] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_is_guest
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 68
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Is Guest
                                                        )

                                                    [CUSTOMER_NOTE_NOTIFY] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_note_notify
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 69
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Note Notify
                                                        )

                                                    [BILLING_ADDRESS_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => billing_address_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 70
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Billing Address Id
                                                        )

                                                    [CUSTOMER_GROUP_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_group_id
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 71
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Group Id
                                                        )

                                                    [EDIT_INCREMENT] => Array
                                                        (
                                                            [COLUMN_NAME] => edit_increment
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 72
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Edit Increment
                                                        )

                                                    [EMAIL_SENT] => Array
                                                        (
                                                            [COLUMN_NAME] => email_sent
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 73
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Email Sent
                                                        )

                                                    [FORCED_SHIPMENT_WITH_INVOICE] => Array
                                                        (
                                                            [COLUMN_NAME] => forced_shipment_with_invoice
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 74
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Forced Do Shipment With Invoice
                                                        )

                                                    [PAYMENT_AUTH_EXPIRATION] => Array
                                                        (
                                                            [COLUMN_NAME] => payment_auth_expiration
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 75
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Payment Authorization Expiration
                                                        )

                                                    [QUOTE_ADDRESS_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => quote_address_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 76
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Quote Address Id
                                                        )

                                                    [QUOTE_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => quote_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 77
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Quote Id
                                                        )

                                                    [SHIPPING_ADDRESS_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_address_id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 78
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Address Id
                                                        )

                                                    [ADJUSTMENT_NEGATIVE] => Array
                                                        (
                                                            [COLUMN_NAME] => adjustment_negative
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 79
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Adjustment Negative
                                                        )

                                                    [ADJUSTMENT_POSITIVE] => Array
                                                        (
                                                            [COLUMN_NAME] => adjustment_positive
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 80
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Adjustment Positive
                                                        )

                                                    [BASE_ADJUSTMENT_NEGATIVE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_adjustment_negative
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 81
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Adjustment Negative
                                                        )

                                                    [BASE_ADJUSTMENT_POSITIVE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_adjustment_positive
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 82
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Adjustment Positive
                                                        )

                                                    [BASE_SHIPPING_DISCOUNT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_discount_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 83
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Discount Amount
                                                        )

                                                    [BASE_SUBTOTAL_INCL_TAX] => Array
                                                        (
                                                            [COLUMN_NAME] => base_subtotal_incl_tax
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 84
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Subtotal Incl Tax
                                                        )

                                                    [BASE_TOTAL_DUE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_total_due
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 85
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Total Due
                                                        )

                                                    [PAYMENT_AUTHORIZATION_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => payment_authorization_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 86
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Payment Authorization Amount
                                                        )

                                                    [SHIPPING_DISCOUNT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_discount_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 87
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Discount Amount
                                                        )

                                                    [SUBTOTAL_INCL_TAX] => Array
                                                        (
                                                            [COLUMN_NAME] => subtotal_incl_tax
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 88
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Subtotal Incl Tax
                                                        )

                                                    [TOTAL_DUE] => Array
                                                        (
                                                            [COLUMN_NAME] => total_due
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 89
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Due
                                                        )

                                                    [WEIGHT] => Array
                                                        (
                                                            [COLUMN_NAME] => weight
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 90
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Weight
                                                        )

                                                    [CUSTOMER_DOB] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_dob
                                                            [COLUMN_TYPE] => datetime
                                                            [COLUMN_POSITION] => 91
                                                            [DATA_TYPE] => datetime
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Dob
                                                        )

                                                    [INCREMENT_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => increment_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 92
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 50
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Increment Id
                                                        )

                                                    [APPLIED_RULE_IDS] => Array
                                                        (
                                                            [COLUMN_NAME] => applied_rule_ids
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 93
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Applied Rule Ids
                                                        )

                                                    [BASE_CURRENCY_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => base_currency_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 94
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 3
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Currency Code
                                                        )

                                                    [CUSTOMER_EMAIL] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_email
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 95
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Email
                                                        )

                                                    [CUSTOMER_FIRSTNAME] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_firstname
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 96
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Firstname
                                                        )

                                                    [CUSTOMER_LASTNAME] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_lastname
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 97
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Lastname
                                                        )

                                                    [CUSTOMER_MIDDLENAME] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_middlename
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 98
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Middlename
                                                        )

                                                    [CUSTOMER_PREFIX] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_prefix
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 99
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Prefix
                                                        )

                                                    [CUSTOMER_SUFFIX] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_suffix
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 100
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Suffix
                                                        )

                                                    [CUSTOMER_TAXVAT] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_taxvat
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 101
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Taxvat
                                                        )

                                                    [DISCOUNT_DESCRIPTION] => Array
                                                        (
                                                            [COLUMN_NAME] => discount_description
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 102
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Discount Description
                                                        )

                                                    [EXT_CUSTOMER_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => ext_customer_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 103
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Ext Customer Id
                                                        )

                                                    [EXT_ORDER_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => ext_order_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 104
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Ext Order Id
                                                        )

                                                    [GLOBAL_CURRENCY_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => global_currency_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 105
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 3
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Global Currency Code
                                                        )

                                                    [HOLD_BEFORE_STATE] => Array
                                                        (
                                                            [COLUMN_NAME] => hold_before_state
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 106
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Hold Before State
                                                        )

                                                    [HOLD_BEFORE_STATUS] => Array
                                                        (
                                                            [COLUMN_NAME] => hold_before_status
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 107
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Hold Before Status
                                                        )

                                                    [ORDER_CURRENCY_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => order_currency_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 108
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Order Currency Code
                                                        )

                                                    [ORIGINAL_INCREMENT_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => original_increment_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 109
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 50
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Original Increment Id
                                                        )

                                                    [RELATION_CHILD_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => relation_child_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 110
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Relation Child Id
                                                        )

                                                    [RELATION_CHILD_REAL_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => relation_child_real_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 111
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Relation Child Real Id
                                                        )

                                                    [RELATION_PARENT_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => relation_parent_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 112
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Relation Parent Id
                                                        )

                                                    [RELATION_PARENT_REAL_ID] => Array
                                                        (
                                                            [COLUMN_NAME] => relation_parent_real_id
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 113
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 32
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Relation Parent Real Id
                                                        )

                                                    [REMOTE_IP] => Array
                                                        (
                                                            [COLUMN_NAME] => remote_ip
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 114
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Remote Ip
                                                        )

                                                    [SHIPPING_METHOD] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_method
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 115
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Method
                                                        )

                                                    [STORE_CURRENCY_CODE] => Array
                                                        (
                                                            [COLUMN_NAME] => store_currency_code
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 116
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 3
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store Currency Code
                                                        )

                                                    [STORE_NAME] => Array
                                                        (
                                                            [COLUMN_NAME] => store_name
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 117
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Store Name
                                                        )

                                                    [X_FORWARDED_FOR] => Array
                                                        (
                                                            [COLUMN_NAME] => x_forwarded_for
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 118
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 255
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => X Forwarded For
                                                        )

                                                    [CUSTOMER_NOTE] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_note
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 119
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 64k
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Note
                                                        )

                                                    [CREATED_AT] => Array
                                                        (
                                                            [COLUMN_NAME] => created_at
                                                            [COLUMN_TYPE] => timestamp
                                                            [COLUMN_POSITION] => 120
                                                            [DATA_TYPE] => timestamp
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Created At
                                                        )

                                                    [UPDATED_AT] => Array
                                                        (
                                                            [COLUMN_NAME] => updated_at
                                                            [COLUMN_TYPE] => timestamp
                                                            [COLUMN_POSITION] => 121
                                                            [DATA_TYPE] => timestamp
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Updated At
                                                        )

                                                    [TOTAL_ITEM_COUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_item_count
                                                            [COLUMN_TYPE] => smallint
                                                            [COLUMN_POSITION] => 122
                                                            [DATA_TYPE] => smallint
                                                            [DEFAULT] => 0
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Item Count
                                                        )

                                                    [CUSTOMER_GENDER] => Array
                                                        (
                                                            [COLUMN_NAME] => customer_gender
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 123
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Customer Gender
                                                        )

                                                    [HIDDEN_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => hidden_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 124
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Hidden Tax Amount
                                                        )

                                                    [BASE_HIDDEN_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_hidden_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 125
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Hidden Tax Amount
                                                        )

                                                    [SHIPPING_HIDDEN_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_hidden_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 126
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Hidden Tax Amount
                                                        )

                                                    [BASE_SHIPPING_HIDDEN_TAX_AMNT] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_hidden_tax_amnt
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 127
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Hidden Tax Amount
                                                        )

                                                    [HIDDEN_TAX_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => hidden_tax_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 128
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Hidden Tax Invoiced
                                                        )

                                                    [BASE_HIDDEN_TAX_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_hidden_tax_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 129
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Hidden Tax Invoiced
                                                        )

                                                    [HIDDEN_TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => hidden_tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 130
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Hidden Tax Refunded
                                                        )

                                                    [BASE_HIDDEN_TAX_REFUNDED] => Array
                                                        (
                                                            [COLUMN_NAME] => base_hidden_tax_refunded
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 131
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Hidden Tax Refunded
                                                        )

                                                    [SHIPPING_INCL_TAX] => Array
                                                        (
                                                            [COLUMN_NAME] => shipping_incl_tax
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 132
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Shipping Incl Tax
                                                        )

                                                    [BASE_SHIPPING_INCL_TAX] => Array
                                                        (
                                                            [COLUMN_NAME] => base_shipping_incl_tax
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 133
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Base Shipping Incl Tax
                                                        )

                                                )

                                            [_indexes:protected] => Array
                                                (
                                                    [IDX_SALES_FLAT_ORDER_STATUS] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STATUS
                                                            [COLUMNS] => Array
                                                                (
                                                                    [STATUS] => Array
                                                                        (
                                                                            [NAME] => status
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_STATE] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STATE
                                                            [COLUMNS] => Array
                                                                (
                                                                    [STATE] => Array
                                                                        (
                                                                            [NAME] => state
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_STORE_ID] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_STORE_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [STORE_ID] => Array
                                                                        (
                                                                            [NAME] => store_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [UNQ_SALES_FLAT_ORDER_INCREMENT_ID] => Array
                                                        (
                                                            [INDEX_NAME] => UNQ_SALES_FLAT_ORDER_INCREMENT_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [INCREMENT_ID] => Array
                                                                        (
                                                                            [NAME] => increment_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => unique
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_CREATED_AT] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_CREATED_AT
                                                            [COLUMNS] => Array
                                                                (
                                                                    [CREATED_AT] => Array
                                                                        (
                                                                            [NAME] => created_at
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_CUSTOMER_ID] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_CUSTOMER_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [CUSTOMER_ID] => Array
                                                                        (
                                                                            [NAME] => customer_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_EXT_ORDER_ID] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_EXT_ORDER_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [EXT_ORDER_ID] => Array
                                                                        (
                                                                            [NAME] => ext_order_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_QUOTE_ID] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_QUOTE_ID
                                                            [COLUMNS] => Array
                                                                (
                                                                    [QUOTE_ID] => Array
                                                                        (
                                                                            [NAME] => quote_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                    [IDX_SALES_FLAT_ORDER_UPDATED_AT] => Array
                                                        (
                                                            [INDEX_NAME] => IDX_SALES_FLAT_ORDER_UPDATED_AT
                                                            [COLUMNS] => Array
                                                                (
                                                                    [UPDATED_AT] => Array
                                                                        (
                                                                            [NAME] => updated_at
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                )

                                                            [TYPE] => index
                                                        )

                                                )

                                            [_foreignKeys:protected] => Array
                                                (
                                                    [FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID] => Array
                                                        (
                                                            [FK_NAME] => FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID
                                                            [COLUMN_NAME] => customer_id
                                                            [REF_TABLE_NAME] => customer_entity
                                                            [REF_COLUMN_NAME] => entity_id
                                                            [ON_DELETE] => SET NULL
                                                            [ON_UPDATE] => CASCADE
                                                        )

                                                    [FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                        (
                                                            [FK_NAME] => FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID
                                                            [COLUMN_NAME] => store_id
                                                            [REF_TABLE_NAME] => core_store
                                                            [REF_COLUMN_NAME] => store_id
                                                            [ON_DELETE] => SET NULL
                                                            [ON_UPDATE] => CASCADE
                                                        )

                                                )

                                            [_options:protected] => Array
                                                (
                                                    [type] => INNODB
                                                    [charset] => utf8
                                                    [collate] => utf8_general_ci
                                                )

                                        )

                                )

                        )

                    [8] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 624
                            [args] => Array
                                (
                                    [0] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
                                )

                            [function] => include
                        )

                    [9] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 421
                            [function] => _modifyResourceDb
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => install
                                    [1] => 
                                    [2] => 1.6.0.8
                                )

                        )

                    [10] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 327
                            [function] => _installResourceDb
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => 1.6.0.8
                                )

                        )

                    [11] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 235
                            [function] => applyUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [12] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/App.php
                            [line] => 417
                            [function] => applyAllUpdates
                            [class] => Mage_Core_Model_Resource_Setup
                            [type] => ::
                            [args] => Array
                                (
                                )

                        )

                    [13] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/code/core/Mage/Core/Model/App.php
                            [line] => 343
                            [function] => _initModules
                            [class] => Mage_Core_Model_App
                            [type] => ->
                            [args] => Array
                                (
                                )

                        )

                    [14] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/app/Mage.php
                            [line] => 684
                            [function] => run
                            [class] => Mage_Core_Model_App
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                            [scope_code] => 
                                            [scope_type] => store
                                            [options] => Array
                                                (
                                                )

                                        )

                                )

                        )

                    [15] => Array
                        (
                            [file] => /home/web/adidasshoesale.ca/htdocs/index.php
                            [line] => 87
                            [function] => run
                            [class] => Mage
                            [type] => ::
                            [args] => Array
                                (
                                    [0] => 
                                    [1] => store
                                )

                        )

                )

            [previous:Exception:private] => 
            [errorInfo] => Array
                (
                    [0] => 08S01
                    [1] => 1153
                    [2] => Got a packet bigger than 'max_allowed_packet' bytes
                )

        )

)