PDOException Object
(
[message:protected] => SQLSTATE[HY000]: General error: 1025 Error on rename of './potjie_magento/sales_flat_quote_shipping_rate' to './potjie_magento/#sql2-10b1-3b252' (errno: 152)
[string:private] =>
[code:protected] => HY000
[file:protected] => /home/potjie/public_html/lib/Zend/Db/Statement/Pdo.php
[line:protected] => 228
[trace:private] => Array
(
[0] => Array
(
[file] => /home/potjie/public_html/lib/Zend/Db/Statement/Pdo.php
[line] => 228
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[1] => Array
(
[file] => /home/potjie/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php
[line] => 110
[function] => _execute
[class] => Zend_Db_Statement_Pdo
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[2] => Array
(
[file] => /home/potjie/public_html/lib/Zend/Db/Statement.php
[line] => 300
[function] => _execute
[class] => Varien_Db_Statement_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[3] => Array
(
[file] => /home/potjie/public_html/lib/Zend/Db/Adapter/Abstract.php
[line] => 479
[function] => execute
[class] => Zend_Db_Statement
[type] => ->
[args] => Array
(
[0] => Array
(
)
)
)
[4] => Array
(
[file] => /home/potjie/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
[line] => 238
[function] => query
[class] => Zend_Db_Adapter_Abstract
[type] => ->
[args] => Array
(
[0] => ALTER TABLE `sales_flat_quote_shipping_rate` DROP FOREIGN KEY `FK_B1F177EFB73D3EDF5322BA64AC48D150`
[1] => Array
(
)
)
)
[5] => Array
(
[file] => /home/potjie/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 419
[function] => query
[class] => Zend_Db_Adapter_Pdo_Abstract
[type] => ->
[args] => Array
(
[0] => ALTER TABLE `sales_flat_quote_shipping_rate` DROP FOREIGN KEY `FK_B1F177EFB73D3EDF5322BA64AC48D150`
[1] => Array
(
)
)
)
[6] => Array
(
[file] => /home/potjie/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 340
[function] => query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => ALTER TABLE `sales_flat_quote_shipping_rate` DROP FOREIGN KEY `FK_B1F177EFB73D3EDF5322BA64AC48D150`
)
)
[7] => Array
(
[file] => /home/potjie/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 701
[function] => raw_query
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => ALTER TABLE `sales_flat_quote_shipping_rate` DROP FOREIGN KEY `FK_B1F177EFB73D3EDF5322BA64AC48D150`
)
)
[8] => Array
(
[file] => /home/potjie/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
[line] => 1120
[function] => dropForeignKey
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => sales_flat_quote_shipping_rate
[1] => FK_B1F177EFB73D3EDF5322BA64AC48D150
)
)
[9] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php
[line] => 6619
[function] => modifyTables
[class] => Varien_Db_Adapter_Pdo_Mysql
[type] => ->
[args] => Array
(
[0] => Array
(
[sales_flat_quote] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Store Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[converted_at] => Array
(
[type] => timestamp
[comment] => Converted At
)
[is_active] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 1
[comment] => Is Active
)
[is_virtual] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Is Virtual
)
[is_multi_shipping] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Is Multi Shipping
)
[items_count] => Array
(
[type] => integer
[unsigned] => 1
[default] => 0
[comment] => Items Count
)
[items_qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Items Qty
)
[orig_order_id] => Array
(
[type] => integer
[unsigned] => 1
[default] => 0
[comment] => Orig Order Id
)
[store_to_base_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Store To Base Rate
)
[store_to_quote_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Store To Quote Rate
)
[base_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Base Currency Code
)
[store_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Store Currency Code
)
[quote_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Quote Currency Code
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Grand Total
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Grand Total
)
[checkout_method] => Array
(
[type] => text
[length] => 255
[comment] => Checkout Method
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[default] => 0
[comment] => Customer Id
)
[customer_tax_class_id] => Array
(
[type] => integer
[unsigned] => 1
[default] => 0
[comment] => Customer Tax Class Id
)
[customer_group_id] => Array
(
[type] => integer
[unsigned] => 1
[default] => 0
[comment] => Customer Group Id
)
[customer_email] => Array
(
[type] => text
[length] => 255
[comment] => Customer Email
)
[customer_prefix] => Array
(
[type] => text
[length] => 40
[comment] => Customer Prefix
)
[customer_firstname] => Array
(
[type] => text
[length] => 255
[comment] => Customer Firstname
)
[customer_middlename] => Array
(
[type] => text
[length] => 40
[comment] => Customer Middlename
)
[customer_lastname] => Array
(
[type] => text
[length] => 255
[comment] => Customer Lastname
)
[customer_suffix] => Array
(
[type] => text
[length] => 40
[comment] => Customer Suffix
)
[customer_dob] => Array
(
[type] => datetime
[comment] => Customer Dob
)
[customer_note] => Array
(
[type] => text
[length] => 255
[comment] => Customer Note
)
[customer_note_notify] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 1
[comment] => Customer Note Notify
)
[customer_is_guest] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Customer Is Guest
)
[remote_ip] => Array
(
[type] => text
[length] => 32
[comment] => Remote Ip
)
[applied_rule_ids] => Array
(
[type] => text
[length] => 255
[comment] => Applied Rule Ids
)
[reserved_order_id] => Array
(
[type] => text
[length] => 64
[comment] => Reserved Order Id
)
[password_hash] => Array
(
[type] => text
[length] => 255
[comment] => Password Hash
)
[coupon_code] => Array
(
[type] => text
[length] => 255
[comment] => Coupon Code
)
[global_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Global Currency Code
)
[base_to_global_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Global Rate
)
[base_to_quote_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Quote Rate
)
[customer_taxvat] => Array
(
[type] => text
[length] => 255
[comment] => Customer Taxvat
)
[customer_gender] => Array
(
[type] => text
[length] => 255
[comment] => Customer Gender
)
[subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal
)
[base_subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal
)
[subtotal_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal With Discount
)
[base_subtotal_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal With Discount
)
[is_changed] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Is Changed
)
[trigger_recollect] => Array
(
[type] => smallint
[nullable] =>
[comment] => Trigger Recollect
)
[ext_shipping_info] => Array
(
[type] => text
[length] => 64K
[comment] => Ext Shipping Info
)
)
[comment] => Sales Flat Quote
)
[sales_flat_quote_item] => Array
(
[columns] => Array
(
[item_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Item Id
)
[quote_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Quote Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[parent_item_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Item Id
)
[is_virtual] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Virtual
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[applied_rule_ids] => Array
(
[type] => text
[length] => 64K
[comment] => Applied Rule Ids
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[free_shipping] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Free Shipping
)
[is_qty_decimal] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Qty Decimal
)
[no_discount] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => No Discount
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Weight
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Qty
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Price
)
[base_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Price
)
[custom_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Custom Price
)
[discount_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Percent
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Amount
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Discount Amount
)
[tax_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Percent
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Amount
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Tax Amount
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Row Total
)
[base_row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Row Total
)
[row_total_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Row Total With Discount
)
[row_weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Row Weight
)
[product_type] => Array
(
[type] => text
[length] => 255
[comment] => Product Type
)
[base_tax_before_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Before Discount
)
[tax_before_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Before Discount
)
[original_custom_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Original Custom Price
)
[redirect_url] => Array
(
[type] => text
[length] => 255
[comment] => Redirect Url
)
[base_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Cost
)
[price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price Incl Tax
)
[base_price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price Incl Tax
)
[row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total Incl Tax
)
[base_row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total Incl Tax
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
)
[comment] => Sales Flat Quote Item
)
[sales_flat_quote_address] => Array
(
[columns] => Array
(
[address_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Address Id
)
[quote_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Quote Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Customer Id
)
[save_in_address_book] => Array
(
[type] => smallint
[default] => 0
[comment] => Save In Address Book
)
[customer_address_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Customer Address Id
)
[address_type] => Array
(
[type] => text
[length] => 255
[comment] => Address Type
)
[email] => Array
(
[type] => text
[length] => 255
[comment] => Email
)
[prefix] => Array
(
[type] => text
[length] => 40
[comment] => Prefix
)
[firstname] => Array
(
[type] => text
[length] => 255
[comment] => Firstname
)
[middlename] => Array
(
[type] => text
[length] => 40
[comment] => Middlename
)
[lastname] => Array
(
[type] => text
[length] => 255
[comment] => Lastname
)
[suffix] => Array
(
[type] => text
[length] => 40
[comment] => Suffix
)
[company] => Array
(
[type] => text
[length] => 255
[comment] => Company
)
[street] => Array
(
[type] => text
[length] => 255
[comment] => Street
)
[city] => Array
(
[type] => text
[length] => 255
[comment] => City
)
[region] => Array
(
[type] => text
[length] => 255
[comment] => Region
)
[region_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Region Id
)
[postcode] => Array
(
[type] => text
[length] => 255
[comment] => Postcode
)
[country_id] => Array
(
[type] => text
[length] => 255
[comment] => Country Id
)
[telephone] => Array
(
[type] => text
[length] => 255
[comment] => Telephone
)
[fax] => Array
(
[type] => text
[length] => 255
[comment] => Fax
)
[same_as_billing] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Same As Billing
)
[free_shipping] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Free Shipping
)
[collect_shipping_rates] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Collect Shipping Rates
)
[shipping_method] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Method
)
[shipping_description] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Description
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Weight
)
[subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Subtotal
)
[base_subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Subtotal
)
[subtotal_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Subtotal With Discount
)
[base_subtotal_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Subtotal With Discount
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Tax Amount
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Tax Amount
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Shipping Amount
)
[base_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Shipping Amount
)
[shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Tax Amount
)
[base_shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Tax Amount
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Discount Amount
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Discount Amount
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Grand Total
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Grand Total
)
[customer_notes] => Array
(
[type] => text
[length] => 64K
[comment] => Customer Notes
)
[applied_taxes] => Array
(
[type] => text
[length] => 64K
[comment] => Applied Taxes
)
[discount_description] => Array
(
[type] => text
[length] => 255
[comment] => Discount Description
)
[shipping_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Discount Amount
)
[base_shipping_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Discount Amount
)
[subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Incl Tax
)
[base_subtotal_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Total Incl Tax
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
[shipping_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Hidden Tax Amount
)
[shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Incl Tax
)
[base_shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Incl Tax
)
)
[comment] => Sales Flat Quote Address
)
[sales_flat_quote_address_item] => Array
(
[columns] => Array
(
[address_item_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Address Item Id
)
[parent_item_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Item Id
)
[quote_address_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Quote Address Id
)
[quote_item_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Quote Item Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[applied_rule_ids] => Array
(
[type] => text
[length] => 64K
[comment] => Applied Rule Ids
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Weight
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Qty
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Amount
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Amount
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Row Total
)
[base_row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Row Total
)
[row_total_with_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Row Total With Discount
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Discount Amount
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Tax Amount
)
[row_weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Row Weight
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[super_product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Super Product Id
)
[parent_product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Product Id
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
[image] => Array
(
[type] => text
[length] => 255
[comment] => Image
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[free_shipping] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Free Shipping
)
[is_qty_decimal] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Is Qty Decimal
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price
)
[discount_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Percent
)
[no_discount] => Array
(
[type] => integer
[unsigned] => 1
[comment] => No Discount
)
[tax_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Percent
)
[base_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price
)
[base_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Cost
)
[price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price Incl Tax
)
[base_price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price Incl Tax
)
[row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total Incl Tax
)
[base_row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total Incl Tax
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
)
[comment] => Sales Flat Quote Address Item
)
[sales_flat_quote_item_option] => Array
(
[columns] => Array
(
[option_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Option Id
)
[item_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Item Id
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Product Id
)
[code] => Array
(
[type] => text
[length] => 255
[nullable] =>
[comment] => Code
)
[value] => Array
(
[type] => text
[length] => 64K
[comment] => Value
)
)
[comment] => Sales Flat Quote Item Option
)
[sales_flat_quote_payment] => Array
(
[columns] => Array
(
[payment_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Payment Id
)
[quote_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Quote Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[method] => Array
(
[type] => text
[length] => 255
[comment] => Method
)
[cc_type] => Array
(
[type] => text
[length] => 255
[comment] => Cc Type
)
[cc_number_enc] => Array
(
[type] => text
[length] => 255
[comment] => Cc Number Enc
)
[cc_last4] => Array
(
[type] => text
[length] => 255
[comment] => Cc Last4
)
[cc_cid_enc] => Array
(
[type] => text
[length] => 255
[comment] => Cc Cid Enc
)
[cc_owner] => Array
(
[type] => text
[length] => 255
[comment] => Cc Owner
)
[cc_exp_month] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Cc Exp Month
)
[cc_exp_year] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Cc Exp Year
)
[cc_ss_owner] => Array
(
[type] => text
[length] => 255
[comment] => Cc Ss Owner
)
[cc_ss_start_month] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Cc Ss Start Month
)
[cc_ss_start_year] => Array
(
[type] => smallint
[unsigned] => 1
[default] => 0
[comment] => Cc Ss Start Year
)
[po_number] => Array
(
[type] => text
[length] => 255
[comment] => Po Number
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[cc_ss_issue] => Array
(
[type] => text
[length] => 255
[comment] => Cc Ss Issue
)
[additional_information] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Information
)
)
[comment] => Sales Flat Quote Payment
)
[sales_flat_quote_shipping_rate] => Array
(
[columns] => Array
(
[rate_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Rate Id
)
[address_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Address Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[carrier] => Array
(
[type] => text
[length] => 255
[comment] => Carrier
)
[carrier_title] => Array
(
[type] => text
[length] => 255
[comment] => Carrier Title
)
[code] => Array
(
[type] => text
[length] => 255
[comment] => Code
)
[method] => Array
(
[type] => text
[length] => 255
[comment] => Method
)
[method_description] => Array
(
[type] => text
[length] => 64K
[comment] => Method Description
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Price
)
[error_message] => Array
(
[type] => text
[length] => 64K
[comment] => Error Message
)
[method_title] => Array
(
[type] => text
[length] => 64K
[comment] => Method Title
)
)
[comment] => Sales Flat Quote Shipping Rate
)
[sales_flat_order] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[state] => Array
(
[type] => text
[length] => 32
[comment] => State
)
[status] => Array
(
[type] => text
[length] => 32
[comment] => Status
)
[coupon_code] => Array
(
[type] => text
[length] => 255
[comment] => Coupon Code
)
[protect_code] => Array
(
[type] => text
[length] => 255
[comment] => Protect Code
)
[shipping_description] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Description
)
[is_virtual] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Virtual
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Customer Id
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Amount
)
[base_discount_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Canceled
)
[base_discount_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Invoiced
)
[base_discount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Refunded
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[base_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Amount
)
[base_shipping_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Canceled
)
[base_shipping_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Invoiced
)
[base_shipping_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Refunded
)
[base_shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Tax Amount
)
[base_shipping_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Tax Refunded
)
[base_subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal
)
[base_subtotal_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Canceled
)
[base_subtotal_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Invoiced
)
[base_subtotal_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Refunded
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Amount
)
[base_tax_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Canceled
)
[base_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Invoiced
)
[base_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Refunded
)
[base_to_global_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Global Rate
)
[base_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Order Rate
)
[base_total_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Canceled
)
[base_total_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Invoiced
)
[base_total_invoiced_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Invoiced Cost
)
[base_total_offline_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Offline Refunded
)
[base_total_online_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Online Refunded
)
[base_total_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Paid
)
[base_total_qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Qty Ordered
)
[base_total_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Refunded
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Amount
)
[discount_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Canceled
)
[discount_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Invoiced
)
[discount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Refunded
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Amount
)
[shipping_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Canceled
)
[shipping_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Invoiced
)
[shipping_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Refunded
)
[shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Tax Amount
)
[shipping_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Tax Refunded
)
[store_to_base_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Base Rate
)
[store_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Order Rate
)
[subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal
)
[subtotal_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Canceled
)
[subtotal_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Invoiced
)
[subtotal_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Refunded
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[tax_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Canceled
)
[tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Invoiced
)
[tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Refunded
)
[total_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Canceled
)
[total_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Invoiced
)
[total_offline_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Offline Refunded
)
[total_online_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Online Refunded
)
[total_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Paid
)
[total_qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Qty Ordered
)
[total_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Refunded
)
[can_ship_partially] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Can Ship Partially
)
[can_ship_partially_item] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Can Ship Partially Item
)
[customer_is_guest] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Customer Is Guest
)
[customer_note_notify] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Customer Note Notify
)
[billing_address_id] => Array
(
[type] => integer
[comment] => Billing Address Id
)
[customer_group_id] => Array
(
[type] => smallint
[comment] => Customer Group Id
)
[edit_increment] => Array
(
[type] => integer
[comment] => Edit Increment
)
[email_sent] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Email Sent
)
[quote_address_id] => Array
(
[type] => integer
[comment] => Quote Address Id
)
[quote_id] => Array
(
[type] => integer
[comment] => Quote Id
)
[shipping_address_id] => Array
(
[type] => integer
[comment] => Shipping Address Id
)
[adjustment_negative] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Adjustment Negative
)
[adjustment_positive] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Adjustment Positive
)
[base_adjustment_negative] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Adjustment Negative
)
[base_adjustment_positive] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Adjustment Positive
)
[base_shipping_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Discount Amount
)
[base_subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Incl Tax
)
[base_total_due] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Due
)
[payment_authorization_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Payment Authorization Amount
)
[shipping_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Discount Amount
)
[subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Incl Tax
)
[total_due] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Due
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Weight
)
[customer_dob] => Array
(
[type] => datetime
[comment] => Customer Dob
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[applied_rule_ids] => Array
(
[type] => text
[length] => 255
[comment] => Applied Rule Ids
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[customer_email] => Array
(
[type] => text
[length] => 255
[comment] => Customer Email
)
[customer_firstname] => Array
(
[type] => text
[length] => 255
[comment] => Customer Firstname
)
[customer_lastname] => Array
(
[type] => text
[length] => 255
[comment] => Customer Lastname
)
[customer_middlename] => Array
(
[type] => text
[length] => 255
[comment] => Customer Middlename
)
[customer_prefix] => Array
(
[type] => text
[length] => 255
[comment] => Customer Prefix
)
[customer_suffix] => Array
(
[type] => text
[length] => 255
[comment] => Customer Suffix
)
[customer_taxvat] => Array
(
[type] => text
[length] => 255
[comment] => Customer Taxvat
)
[discount_description] => Array
(
[type] => text
[length] => 255
[comment] => Discount Description
)
[ext_customer_id] => Array
(
[type] => text
[length] => 255
[comment] => Ext Customer Id
)
[ext_order_id] => Array
(
[type] => text
[length] => 255
[comment] => Ext Order Id
)
[global_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Global Currency Code
)
[hold_before_state] => Array
(
[type] => text
[length] => 255
[comment] => Hold Before State
)
[hold_before_status] => Array
(
[type] => text
[length] => 255
[comment] => Hold Before Status
)
[order_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Order Currency Code
)
[original_increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Original Increment Id
)
[relation_child_id] => Array
(
[type] => text
[length] => 32
[comment] => Relation Child Id
)
[relation_child_real_id] => Array
(
[type] => text
[length] => 32
[comment] => Relation Child Real Id
)
[relation_parent_id] => Array
(
[type] => text
[length] => 32
[comment] => Relation Parent Id
)
[relation_parent_real_id] => Array
(
[type] => text
[length] => 32
[comment] => Relation Parent Real Id
)
[remote_ip] => Array
(
[type] => text
[length] => 255
[comment] => Remote Ip
)
[shipping_method] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Method
)
[store_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Store Currency Code
)
[store_name] => Array
(
[type] => text
[length] => 255
[comment] => Store Name
)
[x_forwarded_for] => Array
(
[type] => text
[length] => 255
[comment] => X Forwarded For
)
[customer_note] => Array
(
[type] => text
[length] => 64K
[comment] => Customer Note
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
[total_item_count] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Total Item Count
)
[customer_gender] => Array
(
[type] => integer
[comment] => Customer Gender
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
[shipping_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Hidden Tax Amount
)
[hidden_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Invoiced
)
[base_hidden_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Invoiced
)
[hidden_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Refunded
)
[base_hidden_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Refunded
)
[shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Incl Tax
)
[base_shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Incl Tax
)
)
[comment] => Sales Flat Order
)
[sales_flat_order_grid] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[status] => Array
(
[type] => text
[length] => 32
[comment] => Status
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[store_name] => Array
(
[type] => text
[length] => 255
[comment] => Store Name
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Customer Id
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[base_total_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Paid
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[total_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Paid
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[order_currency_code] => Array
(
[type] => text
[length] => 255
[comment] => Order Currency Code
)
[shipping_name] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Name
)
[billing_name] => Array
(
[type] => text
[length] => 255
[comment] => Billing Name
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
)
[comment] => Sales Flat Order Grid
)
[sales_flat_order_item] => Array
(
[columns] => Array
(
[item_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Item Id
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[parent_item_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Item Id
)
[quote_item_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Quote Item Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Updated At
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[product_type] => Array
(
[type] => text
[length] => 255
[comment] => Product Type
)
[product_options] => Array
(
[type] => text
[length] => 64K
[comment] => Product Options
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Weight
)
[is_virtual] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Virtual
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[applied_rule_ids] => Array
(
[type] => text
[length] => 64K
[comment] => Applied Rule Ids
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[free_shipping] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Free Shipping
)
[is_qty_decimal] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Qty Decimal
)
[no_discount] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => No Discount
)
[qty_backordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Backordered
)
[qty_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Canceled
)
[qty_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Invoiced
)
[qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Ordered
)
[qty_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Refunded
)
[qty_shipped] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Qty Shipped
)
[base_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Cost
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Price
)
[base_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Price
)
[original_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Original Price
)
[base_original_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Original Price
)
[tax_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Percent
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Amount
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Tax Amount
)
[tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Tax Invoiced
)
[base_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Tax Invoiced
)
[discount_percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Percent
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Amount
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Discount Amount
)
[discount_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Discount Invoiced
)
[base_discount_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Discount Invoiced
)
[amount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Amount Refunded
)
[base_amount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Base Amount Refunded
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Row Total
)
[base_row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Row Total
)
[row_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Row Invoiced
)
[base_row_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Base Row Invoiced
)
[row_weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[default] => 0.0000
[comment] => Row Weight
)
[base_tax_before_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Before Discount
)
[tax_before_discount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Before Discount
)
[ext_order_item_id] => Array
(
[type] => text
[length] => 255
[comment] => Ext Order Item Id
)
[locked_do_invoice] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Locked Do Invoice
)
[locked_do_ship] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Locked Do Ship
)
[price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price Incl Tax
)
[base_price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price Incl Tax
)
[row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total Incl Tax
)
[base_row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total Incl Tax
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
[hidden_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Invoiced
)
[base_hidden_tax_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Invoiced
)
[hidden_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Refunded
)
[base_hidden_tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Refunded
)
[is_nominal] => Array
(
[type] => integer
[nullable] =>
[comment] => Is Nominal
)
[tax_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Canceled
)
[hidden_tax_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Canceled
)
[tax_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Refunded
)
)
[comment] => Sales Flat Order Item
)
[sales_flat_order_address] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Id
)
[customer_address_id] => Array
(
[type] => integer
[comment] => Customer Address Id
)
[quote_address_id] => Array
(
[type] => integer
[comment] => Quote Address Id
)
[region_id] => Array
(
[type] => integer
[comment] => Region Id
)
[customer_id] => Array
(
[type] => integer
[comment] => Customer Id
)
[fax] => Array
(
[type] => text
[length] => 255
[comment] => Fax
)
[region] => Array
(
[type] => text
[length] => 255
[comment] => Region
)
[postcode] => Array
(
[type] => text
[length] => 255
[comment] => Postcode
)
[lastname] => Array
(
[type] => text
[length] => 255
[comment] => Lastname
)
[street] => Array
(
[type] => text
[length] => 255
[comment] => Street
)
[city] => Array
(
[type] => text
[length] => 255
[comment] => City
)
[email] => Array
(
[type] => text
[length] => 255
[comment] => Email
)
[telephone] => Array
(
[type] => text
[length] => 255
[comment] => Telephone
)
[country_id] => Array
(
[type] => text
[length] => 2
[comment] => Country Id
)
[firstname] => Array
(
[type] => text
[length] => 255
[comment] => Firstname
)
[address_type] => Array
(
[type] => text
[length] => 255
[comment] => Address Type
)
[prefix] => Array
(
[type] => text
[length] => 255
[comment] => Prefix
)
[middlename] => Array
(
[type] => text
[length] => 255
[comment] => Middlename
)
[suffix] => Array
(
[type] => text
[length] => 255
[comment] => Suffix
)
[company] => Array
(
[type] => text
[length] => 255
[comment] => Company
)
)
[comment] => Sales Flat Order Address
)
[sales_flat_order_payment] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[base_shipping_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Captured
)
[shipping_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Captured
)
[amount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount Refunded
)
[base_amount_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Paid
)
[amount_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount Canceled
)
[base_amount_authorized] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Authorized
)
[base_amount_paid_online] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Paid Online
)
[base_amount_refunded_online] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Refunded Online
)
[base_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Amount
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Amount
)
[amount_paid] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount Paid
)
[amount_authorized] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount Authorized
)
[base_amount_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Ordered
)
[base_shipping_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Refunded
)
[shipping_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Refunded
)
[base_amount_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Refunded
)
[amount_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount Ordered
)
[base_amount_canceled] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount Canceled
)
[quote_payment_id] => Array
(
[type] => integer
[comment] => Quote Payment Id
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[cc_exp_month] => Array
(
[type] => text
[length] => 255
[comment] => Cc Exp Month
)
[cc_ss_start_year] => Array
(
[type] => text
[length] => 255
[comment] => Cc Ss Start Year
)
[echeck_bank_name] => Array
(
[type] => text
[length] => 255
[comment] => Echeck Bank Name
)
[method] => Array
(
[type] => text
[length] => 255
[comment] => Method
)
[cc_debug_request_body] => Array
(
[type] => text
[length] => 255
[comment] => Cc Debug Request Body
)
[cc_secure_verify] => Array
(
[type] => text
[length] => 255
[comment] => Cc Secure Verify
)
[protection_eligibility] => Array
(
[type] => text
[length] => 255
[comment] => Protection Eligibility
)
[cc_approval] => Array
(
[type] => text
[length] => 255
[comment] => Cc Approval
)
[cc_last4] => Array
(
[type] => text
[length] => 255
[comment] => Cc Last4
)
[cc_status_description] => Array
(
[type] => text
[length] => 255
[comment] => Cc Status Description
)
[echeck_type] => Array
(
[type] => text
[length] => 255
[comment] => Echeck Type
)
[cc_debug_response_serialized] => Array
(
[type] => text
[length] => 255
[comment] => Cc Debug Response Serialized
)
[cc_ss_start_month] => Array
(
[type] => text
[length] => 255
[comment] => Cc Ss Start Month
)
[echeck_account_type] => Array
(
[type] => text
[length] => 255
[comment] => Echeck Account Type
)
[last_trans_id] => Array
(
[type] => text
[length] => 255
[comment] => Last Trans Id
)
[cc_cid_status] => Array
(
[type] => text
[length] => 255
[comment] => Cc Cid Status
)
[cc_owner] => Array
(
[type] => text
[length] => 255
[comment] => Cc Owner
)
[cc_type] => Array
(
[type] => text
[length] => 255
[comment] => Cc Type
)
[po_number] => Array
(
[type] => text
[length] => 255
[comment] => Po Number
)
[cc_exp_year] => Array
(
[type] => text
[length] => 255
[comment] => Cc Exp Year
)
[cc_status] => Array
(
[type] => text
[length] => 255
[comment] => Cc Status
)
[echeck_routing_number] => Array
(
[type] => text
[length] => 255
[comment] => Echeck Routing Number
)
[account_status] => Array
(
[type] => text
[length] => 255
[comment] => Account Status
)
[anet_trans_method] => Array
(
[type] => text
[length] => 255
[comment] => Anet Trans Method
)
[cc_debug_response_body] => Array
(
[type] => text
[length] => 255
[comment] => Cc Debug Response Body
)
[cc_ss_issue] => Array
(
[type] => text
[length] => 255
[comment] => Cc Ss Issue
)
[echeck_account_name] => Array
(
[type] => text
[length] => 255
[comment] => Echeck Account Name
)
[cc_avs_status] => Array
(
[type] => text
[length] => 255
[comment] => Cc Avs Status
)
[cc_number_enc] => Array
(
[type] => text
[length] => 255
[comment] => Cc Number Enc
)
[cc_trans_id] => Array
(
[type] => text
[length] => 255
[comment] => Cc Trans Id
)
[paybox_request_number] => Array
(
[type] => text
[length] => 255
[comment] => Paybox Request Number
)
[address_status] => Array
(
[type] => text
[length] => 255
[comment] => Address Status
)
[additional_information] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Information
)
)
[comment] => Sales Flat Order Payment
)
[sales_flat_order_status_history] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[is_customer_notified] => Array
(
[type] => integer
[comment] => Is Customer Notified
)
[is_visible_on_front] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Is Visible On Front
)
[comment] => Array
(
[type] => text
[length] => 64K
[comment] => Comment
)
[status] => Array
(
[type] => text
[length] => 32
[comment] => Status
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
)
[comment] => Sales Flat Order Status History
)
[sales_order_status] => Array
(
[columns] => Array
(
[status] => Array
(
[type] => text
[length] => 32
[nullable] =>
[primary] => 1
[comment] => Status
)
[label] => Array
(
[type] => text
[length] => 128
[nullable] =>
[comment] => Label
)
)
[comment] => Sales Order Status Table
)
[sales_order_status_state] => Array
(
[columns] => Array
(
[status] => Array
(
[type] => text
[length] => 32
[nullable] =>
[primary] => 1
[comment] => Status
)
[state] => Array
(
[type] => text
[length] => 32
[nullable] =>
[primary] => 1
[comment] => Label
)
[is_default] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Is Default
)
)
[comment] => Sales Order Status Table
)
[sales_order_status_label] => Array
(
[columns] => Array
(
[status] => Array
(
[type] => text
[length] => 32
[nullable] =>
[primary] => 1
[comment] => Status
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Store Id
)
[label] => Array
(
[type] => text
[length] => 128
[nullable] =>
[comment] => Label
)
)
[comment] => Sales Order Status Label Table
)
[sales_flat_invoice] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Tax Amount
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Amount
)
[store_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Order Rate
)
[base_shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Tax Amount
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Amount
)
[base_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Order Rate
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Amount
)
[subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Incl Tax
)
[base_subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Incl Tax
)
[store_to_base_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Base Rate
)
[base_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Amount
)
[total_qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Qty
)
[base_to_global_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Global Rate
)
[subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal
)
[base_subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Amount
)
[billing_address_id] => Array
(
[type] => integer
[comment] => Billing Address Id
)
[is_used_for_refund] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Used For Refund
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[email_sent] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Email Sent
)
[can_void_flag] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Can Void Flag
)
[state] => Array
(
[type] => integer
[comment] => State
)
[shipping_address_id] => Array
(
[type] => integer
[comment] => Shipping Address Id
)
[store_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Store Currency Code
)
[transaction_id] => Array
(
[type] => text
[length] => 255
[comment] => Transaction Id
)
[order_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Order Currency Code
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[global_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Global Currency Code
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
[shipping_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Hidden Tax Amount
)
[shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Incl Tax
)
[base_shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Incl Tax
)
[base_total_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Total Refunded
)
)
[comment] => Sales Flat Invoice
)
[sales_flat_invoice_grid] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[state] => Array
(
[type] => integer
[comment] => State
)
[store_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Store Currency Code
)
[order_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Order Currency Code
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[global_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Global Currency Code
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[order_increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Order Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[order_created_at] => Array
(
[type] => timestamp
[comment] => Order Created At
)
[billing_name] => Array
(
[type] => text
[length] => 255
[comment] => Billing Name
)
)
[comment] => Sales Flat Invoice Grid
)
[sales_flat_invoice_item] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[base_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[base_row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Amount
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Amount
)
[price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price Incl Tax
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Amount
)
[base_price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price Incl Tax
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Qty
)
[base_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Cost
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price
)
[base_row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total Incl Tax
)
[row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total Incl Tax
)
[product_id] => Array
(
[type] => integer
[comment] => Product Id
)
[order_item_id] => Array
(
[type] => integer
[comment] => Order Item Id
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
)
[comment] => Sales Flat Invoice Item
)
[sales_flat_invoice_comment] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[is_customer_notified] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Is Customer Notified
)
[is_visible_on_front] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Is Visible On Front
)
[comment] => Array
(
[type] => text
[length] => 64K
[comment] => Comment
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
)
[comment] => Sales Flat Invoice Comment
)
[sales_flat_shipment] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[total_weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Weight
)
[total_qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Qty
)
[email_sent] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Email Sent
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[customer_id] => Array
(
[type] => integer
[comment] => Customer Id
)
[shipping_address_id] => Array
(
[type] => integer
[comment] => Shipping Address Id
)
[billing_address_id] => Array
(
[type] => integer
[comment] => Billing Address Id
)
[shipment_status] => Array
(
[type] => integer
[comment] => Shipment Status
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
)
[comment] => Sales Flat Shipment
)
[sales_flat_shipment_grid] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[total_qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Qty
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[shipment_status] => Array
(
[type] => integer
[comment] => Shipment Status
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[order_increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Order Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[order_created_at] => Array
(
[type] => timestamp
[comment] => Order Created At
)
[shipping_name] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Name
)
)
[comment] => Sales Flat Shipment Grid
)
[sales_flat_shipment_item] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Weight
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Qty
)
[product_id] => Array
(
[type] => integer
[comment] => Product Id
)
[order_item_id] => Array
(
[type] => integer
[comment] => Order Item Id
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
)
[comment] => Sales Flat Shipment Item
)
[sales_flat_shipment_comment] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[is_customer_notified] => Array
(
[type] => integer
[comment] => Is Customer Notified
)
[is_visible_on_front] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Is Visible On Front
)
[comment] => Array
(
[type] => text
[length] => 64K
[comment] => Comment
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
)
[comment] => Sales Flat Shipment Comment
)
[sales_flat_shipment_track] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[weight] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Weight
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Qty
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[title] => Array
(
[type] => text
[length] => 255
[comment] => Title
)
[carrier_code] => Array
(
[type] => text
[length] => 32
[comment] => Carrier Code
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
)
[comment] => Sales Flat Shipment Track
)
[sales_flat_creditmemo] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[adjustment_positive] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Adjustment Positive
)
[base_shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Tax Amount
)
[store_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Order Rate
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Amount
)
[base_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Order Rate
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[base_adjustment_negative] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Adjustment Negative
)
[base_subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal Incl Tax
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Amount
)
[subtotal_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal Incl Tax
)
[adjustment_negative] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Adjustment Negative
)
[base_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Amount
)
[store_to_base_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Base Rate
)
[base_to_global_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Global Rate
)
[base_adjustment] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Adjustment
)
[base_subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Subtotal
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Amount
)
[subtotal] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Subtotal
)
[adjustment] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Adjustment
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[base_adjustment_positive] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Adjustment Positive
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Amount
)
[shipping_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Tax Amount
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[email_sent] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Email Sent
)
[creditmemo_status] => Array
(
[type] => integer
[comment] => Creditmemo Status
)
[state] => Array
(
[type] => integer
[comment] => State
)
[shipping_address_id] => Array
(
[type] => integer
[comment] => Shipping Address Id
)
[billing_address_id] => Array
(
[type] => integer
[comment] => Billing Address Id
)
[invoice_id] => Array
(
[type] => integer
[comment] => Invoice Id
)
[store_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Store Currency Code
)
[order_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Order Currency Code
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[global_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Global Currency Code
)
[transaction_id] => Array
(
[type] => text
[length] => 255
[comment] => Transaction Id
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
[shipping_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Hidden Tax Amount
)
[shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Incl Tax
)
[base_shipping_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Shipping Incl Tax
)
)
[comment] => Sales Flat Creditmemo
)
[sales_flat_creditmemo_grid] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[store_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Order Rate
)
[base_to_order_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Order Rate
)
[grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Grand Total
)
[store_to_base_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Store To Base Rate
)
[base_to_global_rate] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base To Global Rate
)
[base_grand_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Grand Total
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[creditmemo_status] => Array
(
[type] => integer
[comment] => Creditmemo Status
)
[state] => Array
(
[type] => integer
[comment] => State
)
[invoice_id] => Array
(
[type] => integer
[comment] => Invoice Id
)
[store_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Store Currency Code
)
[order_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Order Currency Code
)
[base_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Base Currency Code
)
[global_currency_code] => Array
(
[type] => text
[length] => 3
[comment] => Global Currency Code
)
[increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Increment Id
)
[order_increment_id] => Array
(
[type] => text
[length] => 50
[comment] => Order Increment Id
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
[order_created_at] => Array
(
[type] => timestamp
[comment] => Order Created At
)
[billing_name] => Array
(
[type] => text
[length] => 255
[comment] => Billing Name
)
)
[comment] => Sales Flat Creditmemo Grid
)
[sales_flat_creditmemo_item] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[base_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[base_row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total
)
[discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Discount Amount
)
[row_total] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total
)
[base_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Discount Amount
)
[price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price Incl Tax
)
[base_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Tax Amount
)
[base_price_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Price Incl Tax
)
[qty] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Qty
)
[base_cost] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Cost
)
[price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Price
)
[base_row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Row Total Incl Tax
)
[row_total_incl_tax] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Row Total Incl Tax
)
[product_id] => Array
(
[type] => integer
[comment] => Product Id
)
[order_item_id] => Array
(
[type] => integer
[comment] => Order Item Id
)
[additional_data] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Data
)
[description] => Array
(
[type] => text
[length] => 64K
[comment] => Description
)
[sku] => Array
(
[type] => text
[length] => 255
[comment] => Sku
)
[name] => Array
(
[type] => text
[length] => 255
[comment] => Name
)
[hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Hidden Tax Amount
)
[base_hidden_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Hidden Tax Amount
)
)
[comment] => Sales Flat Creditmemo Item
)
[sales_flat_creditmemo_comment] => Array
(
[columns] => Array
(
[entity_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Entity Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Parent Id
)
[is_customer_notified] => Array
(
[type] => integer
[comment] => Is Customer Notified
)
[is_visible_on_front] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Is Visible On Front
)
[comment] => Array
(
[type] => text
[length] => 64K
[comment] => Comment
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
)
[comment] => Sales Flat Creditmemo Comment
)
[sales_recurring_profile] => Array
(
[columns] => Array
(
[profile_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Profile Id
)
[state] => Array
(
[type] => text
[length] => 20
[nullable] =>
[comment] => State
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Customer Id
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[method_code] => Array
(
[type] => text
[length] => 32
[nullable] =>
[comment] => Method Code
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
[reference_id] => Array
(
[type] => text
[length] => 32
[comment] => Reference Id
)
[subscriber_name] => Array
(
[type] => text
[length] => 150
[comment] => Subscriber Name
)
[start_datetime] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Start Datetime
)
[internal_reference_id] => Array
(
[type] => text
[length] => 42
[nullable] =>
[comment] => Internal Reference Id
)
[schedule_description] => Array
(
[type] => text
[length] => 255
[nullable] =>
[comment] => Schedule Description
)
[suspension_threshold] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Suspension Threshold
)
[bill_failed_later] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Bill Failed Later
)
[period_unit] => Array
(
[type] => text
[length] => 20
[nullable] =>
[comment] => Period Unit
)
[period_frequency] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Period Frequency
)
[period_max_cycles] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Period Max Cycles
)
[billing_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Billing Amount
)
[trial_period_unit] => Array
(
[type] => text
[length] => 20
[comment] => Trial Period Unit
)
[trial_period_frequency] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Trial Period Frequency
)
[trial_period_max_cycles] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Trial Period Max Cycles
)
[trial_billing_amount] => Array
(
[type] => text
[length] => 64K
[comment] => Trial Billing Amount
)
[currency_code] => Array
(
[type] => text
[length] => 3
[nullable] =>
[comment] => Currency Code
)
[shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Shipping Amount
)
[tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Tax Amount
)
[init_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Init Amount
)
[init_may_fail] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Init May Fail
)
[order_info] => Array
(
[type] => text
[length] => 64K
[nullable] =>
[comment] => Order Info
)
[order_item_info] => Array
(
[type] => text
[length] => 64K
[nullable] =>
[comment] => Order Item Info
)
[billing_address_info] => Array
(
[type] => text
[length] => 64K
[nullable] =>
[comment] => Billing Address Info
)
[shipping_address_info] => Array
(
[type] => text
[length] => 64K
[comment] => Shipping Address Info
)
[profile_vendor_info] => Array
(
[type] => text
[length] => 64K
[comment] => Profile Vendor Info
)
[additional_info] => Array
(
[type] => text
[length] => 64K
[comment] => Additional Info
)
)
[comment] => Sales Recurring Profile
)
[sales_recurring_profile_order] => Array
(
[columns] => Array
(
[link_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Link Id
)
[profile_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Profile Id
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
)
[comment] => Sales Recurring Profile Order
)
[sales_order_tax] => Array
(
[columns] => Array
(
[tax_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Tax Id
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[code] => Array
(
[type] => text
[length] => 255
[comment] => Code
)
[title] => Array
(
[type] => text
[length] => 255
[comment] => Title
)
[percent] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Percent
)
[amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Amount
)
[priority] => Array
(
[type] => integer
[nullable] =>
[comment] => Priority
)
[position] => Array
(
[type] => integer
[nullable] =>
[comment] => Position
)
[base_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Amount
)
[process] => Array
(
[type] => smallint
[nullable] =>
[comment] => Process
)
[base_real_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Base Real Amount
)
[hidden] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Hidden
)
)
[comment] => Sales Order Tax Table
)
[sales_order_aggregated_created] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[nullable] =>
[comment] => Order Status
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[total_qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Qty Ordered
)
[total_qty_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Qty Invoiced
)
[total_income_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Income Amount
)
[total_revenue_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Revenue Amount
)
[total_profit_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Profit Amount
)
[total_invoiced_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Invoiced Amount
)
[total_canceled_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Canceled Amount
)
[total_paid_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Paid Amount
)
[total_refunded_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Refunded Amount
)
[total_tax_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Tax Amount
)
[total_tax_amount_actual] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Tax Amount Actual
)
[total_shipping_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Shipping Amount
)
[total_shipping_amount_actual] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Shipping Amount Actual
)
[total_discount_amount] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Discount Amount
)
[total_discount_amount_actual] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Total Discount Amount Actual
)
)
[comment] => Sales Order Aggregated Created
)
[sales_shipping_aggregated] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[comment] => Order Status
)
[shipping_description] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Description
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[total_shipping] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Shipping
)
[total_shipping_actual] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Shipping Actual
)
)
[comment] => Sales Shipping Aggregated
)
[sales_shipping_aggregated_order] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[comment] => Order Status
)
[shipping_description] => Array
(
[type] => text
[length] => 255
[comment] => Shipping Description
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[total_shipping] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Shipping
)
[total_shipping_actual] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Total Shipping Actual
)
)
[comment] => Sales Shipping Aggregated Order
)
[sales_invoiced_aggregated] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[comment] => Order Status
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[orders_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Orders Invoiced
)
[invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced
)
[invoiced_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced Captured
)
[invoiced_not_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced Not Captured
)
)
[comment] => Sales Invoiced Aggregated
)
[sales_invoiced_aggregated_order] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[nullable] =>
[comment] => Order Status
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[orders_invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Orders Invoiced
)
[invoiced] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced
)
[invoiced_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced Captured
)
[invoiced_not_captured] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Invoiced Not Captured
)
)
[comment] => Sales Invoiced Aggregated Order
)
[sales_refunded_aggregated] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[nullable] =>
[comment] => Order Status
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Refunded
)
[online_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Online Refunded
)
[offline_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Offline Refunded
)
)
[comment] => Sales Refunded Aggregated
)
[sales_refunded_aggregated_order] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[order_status] => Array
(
[type] => text
[length] => 50
[comment] => Order Status
)
[orders_count] => Array
(
[type] => integer
[nullable] =>
[comment] => Orders Count
)
[refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Refunded
)
[online_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Online Refunded
)
[offline_refunded] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[comment] => Offline Refunded
)
)
[comment] => Sales Refunded Aggregated Order
)
[sales_payment_transaction] => Array
(
[columns] => Array
(
[transaction_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Transaction Id
)
[parent_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Parent Id
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Order Id
)
[payment_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Payment Id
)
[txn_id] => Array
(
[type] => text
[length] => 100
[comment] => Txn Id
)
[parent_txn_id] => Array
(
[type] => text
[length] => 100
[comment] => Parent Txn Id
)
[txn_type] => Array
(
[type] => text
[length] => 15
[comment] => Txn Type
)
[is_closed] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[default] => 1
[comment] => Is Closed
)
[additional_information] => Array
(
[type] => blob
[length] => 64K
[comment] => Additional Information
)
[created_at] => Array
(
[type] => timestamp
[comment] => Created At
)
)
[comment] => Sales Payment Transaction
)
[sales_bestsellers_aggregated_daily] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[product_name] => Array
(
[type] => text
[length] => 255
[comment] => Product Name
)
[product_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Product Price
)
[qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Qty Ordered
)
[rating_pos] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Rating Pos
)
)
[comment] => Sales Bestsellers Aggregated Daily
)
[sales_bestsellers_aggregated_monthly] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[product_name] => Array
(
[type] => text
[length] => 255
[comment] => Product Name
)
[product_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Product Price
)
[qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Qty Ordered
)
[rating_pos] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Rating Pos
)
)
[comment] => Sales Bestsellers Aggregated Monthly
)
[sales_bestsellers_aggregated_yearly] => Array
(
[columns] => Array
(
[id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Id
)
[period] => Array
(
[type] => date
[comment] => Period
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[product_id] => Array
(
[type] => integer
[unsigned] => 1
[comment] => Product Id
)
[product_name] => Array
(
[type] => text
[length] => 255
[comment] => Product Name
)
[product_price] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Product Price
)
[qty_ordered] => Array
(
[type] => decimal
[scale] => 4
[precision] => 12
[nullable] =>
[default] => 0.0000
[comment] => Qty Ordered
)
[rating_pos] => Array
(
[type] => smallint
[unsigned] => 1
[nullable] =>
[comment] => Rating Pos
)
)
[comment] => Sales Bestsellers Aggregated Yearly
)
[sales_billing_agreement] => Array
(
[columns] => Array
(
[agreement_id] => Array
(
[type] => integer
[identity] => 1
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Agreement Id
)
[customer_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[comment] => Customer Id
)
[method_code] => Array
(
[type] => text
[length] => 32
[nullable] =>
[comment] => Method Code
)
[reference_id] => Array
(
[type] => text
[length] => 32
[nullable] =>
[comment] => Reference Id
)
[status] => Array
(
[type] => text
[length] => 20
[nullable] =>
[comment] => Status
)
[created_at] => Array
(
[type] => timestamp
[nullable] =>
[comment] => Created At
)
[updated_at] => Array
(
[type] => timestamp
[comment] => Updated At
)
[store_id] => Array
(
[type] => smallint
[unsigned] => 1
[comment] => Store Id
)
[agreement_label] => Array
(
[type] => text
[length] => 255
[comment] => Agreement Label
)
)
[comment] => Sales Billing Agreement
)
[sales_billing_agreement_order] => Array
(
[columns] => Array
(
[agreement_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Agreement Id
)
[order_id] => Array
(
[type] => integer
[unsigned] => 1
[nullable] =>
[primary] => 1
[comment] => Order Id
)
)
[comment] => Sales Billing Agreement Order
)
)
)
)
[10] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 624
[args] => Array
(
[0] => /home/potjie/public_html/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.5.9.9-1.6.0.0.php
)
[function] => include
)
[11] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 437
[function] => _modifyResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => upgrade
[1] => 1.4.0.25
[2] => 1.6.0.7
)
)
[12] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 320
[function] => _upgradeResourceDb
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
[0] => 1.4.0.25
[1] => 1.6.0.7
)
)
[13] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
[line] => 235
[function] => applyUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ->
[args] => Array
(
)
)
[14] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 417
[function] => applyAllUpdates
[class] => Mage_Core_Model_Resource_Setup
[type] => ::
[args] => Array
(
)
)
[15] => Array
(
[file] => /home/potjie/public_html/app/code/core/Mage/Core/Model/App.php
[line] => 343
[function] => _initModules
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
)
)
[16] => Array
(
[file] => /home/potjie/public_html/app/Mage.php
[line] => 683
[function] => run
[class] => Mage_Core_Model_App
[type] => ->
[args] => Array
(
[0] => Array
(
[scope_code] =>
[scope_type] => store
[options] => Array
(
)
)
)
)
[17] => Array
(
[file] => /home/potjie/public_html/index.php
[line] => 87
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
[0] =>
[1] => store
)
)
)
[errorInfo] => Array
(
[0] => HY000
[1] => 1025
[2] => Error on rename of './potjie_magento/sales_flat_quote_shipping_rate' to './potjie_magento/#sql2-10b1-3b252' (errno: 152)
)
)