Zend_Db_Statement_Exception Object
(
[_previous:Zend_Exception:private] =>
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_flat_order' already exists
[string:Exception:private] =>
[code:protected] => 42
[file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 234
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2048
[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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
)
[function] => include
)
[8] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[12] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[13] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[14] => Array
(
[file] => /www/wwwroot/kiwilighting.com/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] => PDOException Object
(
[message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_flat_order' already exists
[string:Exception:private] =>
[code:protected] => 42S01
[file:protected] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:Exception:private] => Array
(
[0] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 2048
[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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Sales/sql/sales_setup/install-1.6.0.0.php
)
[function] => include
)
[9] => Array
(
[file] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/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] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[13] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /www/wwwroot/kiwilighting.com/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[15] => Array
(
[file] => /www/wwwroot/kiwilighting.com/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[previous:Exception:private] =>
[errorInfo] => Array
(
[0] => 42S01
[1] => 1050
[2] => Table 'sales_flat_order' already exists
)
)
)