Zend_Db_Statement_Exception Object
(
    [_previous:Zend_Exception:private] => 
    [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_aggregated_updated' already exists
    [string:Exception:private] => 
    [code:protected] => 42
    [file:protected] => /home/kidsboul/public_html/lib/Zend/Db/Statement/Pdo.php
    [line:protected] => 234
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/kidsboul/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php
                    [line] => 110
                    [function] => _execute
                    [class] => Zend_Db_Statement_Pdo
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                )

                        )

                )

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

                        )

                )

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

                        )

                )

            [3] => Array
                (
                    [file] => /home/kidsboul/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
                    [line] => 238
                    [function] => query
                    [class] => Zend_Db_Adapter_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [4] => Array
                (
                    [file] => /home/kidsboul/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 428
                    [function] => query
                    [class] => Zend_Db_Adapter_Pdo_Abstract
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                            [1] => Array
                                (
                                )

                        )

                )

            [5] => Array
                (
                    [file] => /home/kidsboul/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                    [line] => 2117
                    [function] => query
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                        )

                )

            [6] => Array
                (
                    [file] => /home/kidsboul/public_html/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.3-1.6.0.4.php
                    [line] => 37
                    [function] => createTable
                    [class] => Varien_Db_Adapter_Pdo_Mysql
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Varien_Db_Ddl_Table Object
                                (
                                    [_tableName:protected] => sales_order_aggregated_updated
                                    [_schemaName:protected] => 
                                    [_tableComment:protected] => Sales Order Aggregated Updated
                                    [_columns:protected] => Array
                                        (
                                            [ID] => Array
                                                (
                                                    [COLUMN_NAME] => id
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 0
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 1
                                                    [PRIMARY] => 1
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 1
                                                    [COMMENT] => Id
                                                )

                                            [PERIOD] => Array
                                                (
                                                    [COLUMN_NAME] => period
                                                    [COLUMN_TYPE] => date
                                                    [COLUMN_POSITION] => 1
                                                    [DATA_TYPE] => date
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 1
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Period
                                                )

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

                                            [ORDER_STATUS] => Array
                                                (
                                                    [COLUMN_NAME] => order_status
                                                    [COLUMN_TYPE] => text
                                                    [COLUMN_POSITION] => 3
                                                    [DATA_TYPE] => text
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 50
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Order Status
                                                )

                                            [ORDERS_COUNT] => Array
                                                (
                                                    [COLUMN_NAME] => orders_count
                                                    [COLUMN_TYPE] => integer
                                                    [COLUMN_POSITION] => 4
                                                    [DATA_TYPE] => integer
                                                    [DEFAULT] => 
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 
                                                    [PRECISION] => 
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Orders Count
                                                )

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

                                            [TOTAL_QTY_INVOICED] => Array
                                                (
                                                    [COLUMN_NAME] => total_qty_invoiced
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 6
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Qty Invoiced
                                                )

                                            [TOTAL_INCOME_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_income_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 7
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Income Amount
                                                )

                                            [TOTAL_REVENUE_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_revenue_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 8
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Revenue Amount
                                                )

                                            [TOTAL_PROFIT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_profit_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 9
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Profit Amount
                                                )

                                            [TOTAL_INVOICED_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_invoiced_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 10
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Invoiced Amount
                                                )

                                            [TOTAL_CANCELED_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_canceled_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 11
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Canceled Amount
                                                )

                                            [TOTAL_PAID_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_paid_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 12
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Paid Amount
                                                )

                                            [TOTAL_REFUNDED_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_refunded_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 13
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Refunded Amount
                                                )

                                            [TOTAL_TAX_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_tax_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 14
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Tax Amount
                                                )

                                            [TOTAL_TAX_AMOUNT_ACTUAL] => Array
                                                (
                                                    [COLUMN_NAME] => total_tax_amount_actual
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 15
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Tax Amount Actual
                                                )

                                            [TOTAL_SHIPPING_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_shipping_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 16
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Shipping Amount
                                                )

                                            [TOTAL_SHIPPING_AMOUNT_ACTUAL] => Array
                                                (
                                                    [COLUMN_NAME] => total_shipping_amount_actual
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 17
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Shipping Amount Actual
                                                )

                                            [TOTAL_DISCOUNT_AMOUNT] => Array
                                                (
                                                    [COLUMN_NAME] => total_discount_amount
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 18
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Discount Amount
                                                )

                                            [TOTAL_DISCOUNT_AMOUNT_ACTUAL] => Array
                                                (
                                                    [COLUMN_NAME] => total_discount_amount_actual
                                                    [COLUMN_TYPE] => decimal
                                                    [COLUMN_POSITION] => 19
                                                    [DATA_TYPE] => decimal
                                                    [DEFAULT] => '0.0000'
                                                    [NULLABLE] => 
                                                    [LENGTH] => 
                                                    [SCALE] => 4
                                                    [PRECISION] => 12
                                                    [UNSIGNED] => 
                                                    [PRIMARY] => 
                                                    [PRIMARY_POSITION] => 0
                                                    [IDENTITY] => 
                                                    [COMMENT] => Total Discount Amount Actual
                                                )

                                        )

                                    [_indexes:protected] => Array
                                        (
                                            [UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS] => Array
                                                (
                                                    [INDEX_NAME] => UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS
                                                    [COLUMNS] => Array
                                                        (
                                                            [PERIOD] => Array
                                                                (
                                                                    [NAME] => period
                                                                    [SIZE] => 
                                                                    [POSITION] => 0
                                                                )

                                                            [STORE_ID] => Array
                                                                (
                                                                    [NAME] => store_id
                                                                    [SIZE] => 
                                                                    [POSITION] => 1
                                                                )

                                                            [ORDER_STATUS] => Array
                                                                (
                                                                    [NAME] => order_status
                                                                    [SIZE] => 
                                                                    [POSITION] => 2
                                                                )

                                                        )

                                                    [TYPE] => unique
                                                )

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

                                                        )

                                                    [TYPE] => index
                                                )

                                        )

                                    [_foreignKeys:protected] => Array
                                        (
                                            [FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                (
                                                    [FK_NAME] => FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID
                                                    [COLUMN_NAME] => store_id
                                                    [REF_TABLE_NAME] => core_store
                                                    [REF_COLUMN_NAME] => store_id
                                                    [ON_DELETE] => SET NULL
                                                    [ON_UPDATE] => CASCADE
                                                )

                                        )

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

                                )

                        )

                )

            [7] => Array
                (
                    [file] => /home/kidsboul/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                    [line] => 624
                    [args] => Array
                        (
                            [0] => /home/kidsboul/public_html/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.3-1.6.0.4.php
                        )

                    [function] => include
                )

            [8] => Array
                (
                    [file] => /home/kidsboul/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.6.0.3
                            [2] => 1.6.0.8
                        )

                )

            [9] => Array
                (
                    [file] => /home/kidsboul/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.6.0.3
                            [1] => 1.6.0.8
                        )

                )

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

                )

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

                )

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

                )

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

                                )

                        )

                )

            [14] => Array
                (
                    [file] => /home/kidsboul/public_html/index.php
                    [line] => 80
                    [function] => run
                    [class] => Mage
                    [type] => ::
                    [args] => Array
                        (
                            [0] => 
                            [1] => store
                        )

                )

        )

    [previous:Exception:private] => PDOException Object
        (
            [message:protected] => SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'sales_order_aggregated_updated' already exists
            [string:Exception:private] => 
            [code:protected] => 42S01
            [file:protected] => /home/kidsboul/public_html/lib/Zend/Db/Statement/Pdo.php
            [line:protected] => 228
            [trace:Exception:private] => Array
                (
                    [0] => Array
                        (
                            [file] => /home/kidsboul/public_html/lib/Zend/Db/Statement/Pdo.php
                            [line] => 228
                            [function] => execute
                            [class] => PDOStatement
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

                    [1] => Array
                        (
                            [file] => /home/kidsboul/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/kidsboul/public_html/app/code/core/Zend/Db/Statement.php
                            [line] => 291
                            [function] => _execute
                            [class] => Varien_Db_Statement_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Array
                                        (
                                        )

                                )

                        )

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

                                )

                        )

                    [4] => Array
                        (
                            [file] => /home/kidsboul/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php
                            [line] => 238
                            [function] => query
                            [class] => Zend_Db_Adapter_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [5] => Array
                        (
                            [file] => /home/kidsboul/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 428
                            [function] => query
                            [class] => Zend_Db_Adapter_Pdo_Abstract
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                                    [1] => Array
                                        (
                                        )

                                )

                        )

                    [6] => Array
                        (
                            [file] => /home/kidsboul/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php
                            [line] => 2117
                            [function] => query
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => CREATE TABLE `sales_order_aggregated_updated` (
  `id` int UNSIGNED NOT NULL auto_increment COMMENT 'Id' ,
  `period` date NULL COMMENT 'Period' ,
  `store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
  `order_status` varchar(50) NOT NULL COMMENT 'Order Status' ,
  `orders_count` int NOT NULL COMMENT 'Orders Count' ,
  `total_qty_ordered` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Ordered' ,
  `total_qty_invoiced` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Qty Invoiced' ,
  `total_income_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Income Amount' ,
  `total_revenue_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Revenue Amount' ,
  `total_profit_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Profit Amount' ,
  `total_invoiced_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Invoiced Amount' ,
  `total_canceled_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Canceled Amount' ,
  `total_paid_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Paid Amount' ,
  `total_refunded_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Refunded Amount' ,
  `total_tax_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount' ,
  `total_tax_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Tax Amount Actual' ,
  `total_shipping_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount' ,
  `total_shipping_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Shipping Amount Actual' ,
  `total_discount_amount` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount' ,
  `total_discount_amount_actual` decimal(12,4) NOT NULL default '0.0000' COMMENT 'Total Discount Amount Actual' ,
  PRIMARY KEY (`id`),
  UNIQUE `UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS` (`period`, `store_id`, `order_status`),
  INDEX `IDX_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID` (`store_id`),
  CONSTRAINT `FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `core_store` (`store_id`) ON DELETE SET NULL ON UPDATE CASCADE
) COMMENT='Sales Order Aggregated Updated' ENGINE=InnoDB charset=utf8 COLLATE=utf8_general_ci
                                )

                        )

                    [7] => Array
                        (
                            [file] => /home/kidsboul/public_html/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.3-1.6.0.4.php
                            [line] => 37
                            [function] => createTable
                            [class] => Varien_Db_Adapter_Pdo_Mysql
                            [type] => ->
                            [args] => Array
                                (
                                    [0] => Varien_Db_Ddl_Table Object
                                        (
                                            [_tableName:protected] => sales_order_aggregated_updated
                                            [_schemaName:protected] => 
                                            [_tableComment:protected] => Sales Order Aggregated Updated
                                            [_columns:protected] => Array
                                                (
                                                    [ID] => Array
                                                        (
                                                            [COLUMN_NAME] => id
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 0
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 1
                                                            [PRIMARY] => 1
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 1
                                                            [COMMENT] => Id
                                                        )

                                                    [PERIOD] => Array
                                                        (
                                                            [COLUMN_NAME] => period
                                                            [COLUMN_TYPE] => date
                                                            [COLUMN_POSITION] => 1
                                                            [DATA_TYPE] => date
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 1
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Period
                                                        )

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

                                                    [ORDER_STATUS] => Array
                                                        (
                                                            [COLUMN_NAME] => order_status
                                                            [COLUMN_TYPE] => text
                                                            [COLUMN_POSITION] => 3
                                                            [DATA_TYPE] => text
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 50
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Order Status
                                                        )

                                                    [ORDERS_COUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => orders_count
                                                            [COLUMN_TYPE] => integer
                                                            [COLUMN_POSITION] => 4
                                                            [DATA_TYPE] => integer
                                                            [DEFAULT] => 
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 
                                                            [PRECISION] => 
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Orders Count
                                                        )

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

                                                    [TOTAL_QTY_INVOICED] => Array
                                                        (
                                                            [COLUMN_NAME] => total_qty_invoiced
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 6
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Qty Invoiced
                                                        )

                                                    [TOTAL_INCOME_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_income_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 7
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Income Amount
                                                        )

                                                    [TOTAL_REVENUE_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_revenue_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 8
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Revenue Amount
                                                        )

                                                    [TOTAL_PROFIT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_profit_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 9
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Profit Amount
                                                        )

                                                    [TOTAL_INVOICED_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_invoiced_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 10
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Invoiced Amount
                                                        )

                                                    [TOTAL_CANCELED_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_canceled_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 11
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Canceled Amount
                                                        )

                                                    [TOTAL_PAID_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_paid_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 12
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Paid Amount
                                                        )

                                                    [TOTAL_REFUNDED_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_refunded_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 13
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Refunded Amount
                                                        )

                                                    [TOTAL_TAX_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_tax_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 14
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Tax Amount
                                                        )

                                                    [TOTAL_TAX_AMOUNT_ACTUAL] => Array
                                                        (
                                                            [COLUMN_NAME] => total_tax_amount_actual
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 15
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Tax Amount Actual
                                                        )

                                                    [TOTAL_SHIPPING_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_shipping_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 16
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Shipping Amount
                                                        )

                                                    [TOTAL_SHIPPING_AMOUNT_ACTUAL] => Array
                                                        (
                                                            [COLUMN_NAME] => total_shipping_amount_actual
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 17
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Shipping Amount Actual
                                                        )

                                                    [TOTAL_DISCOUNT_AMOUNT] => Array
                                                        (
                                                            [COLUMN_NAME] => total_discount_amount
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 18
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Discount Amount
                                                        )

                                                    [TOTAL_DISCOUNT_AMOUNT_ACTUAL] => Array
                                                        (
                                                            [COLUMN_NAME] => total_discount_amount_actual
                                                            [COLUMN_TYPE] => decimal
                                                            [COLUMN_POSITION] => 19
                                                            [DATA_TYPE] => decimal
                                                            [DEFAULT] => '0.0000'
                                                            [NULLABLE] => 
                                                            [LENGTH] => 
                                                            [SCALE] => 4
                                                            [PRECISION] => 12
                                                            [UNSIGNED] => 
                                                            [PRIMARY] => 
                                                            [PRIMARY_POSITION] => 0
                                                            [IDENTITY] => 
                                                            [COMMENT] => Total Discount Amount Actual
                                                        )

                                                )

                                            [_indexes:protected] => Array
                                                (
                                                    [UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS] => Array
                                                        (
                                                            [INDEX_NAME] => UNQ_SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS
                                                            [COLUMNS] => Array
                                                                (
                                                                    [PERIOD] => Array
                                                                        (
                                                                            [NAME] => period
                                                                            [SIZE] => 
                                                                            [POSITION] => 0
                                                                        )

                                                                    [STORE_ID] => Array
                                                                        (
                                                                            [NAME] => store_id
                                                                            [SIZE] => 
                                                                            [POSITION] => 1
                                                                        )

                                                                    [ORDER_STATUS] => Array
                                                                        (
                                                                            [NAME] => order_status
                                                                            [SIZE] => 
                                                                            [POSITION] => 2
                                                                        )

                                                                )

                                                            [TYPE] => unique
                                                        )

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

                                                                )

                                                            [TYPE] => index
                                                        )

                                                )

                                            [_foreignKeys:protected] => Array
                                                (
                                                    [FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID] => Array
                                                        (
                                                            [FK_NAME] => FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID
                                                            [COLUMN_NAME] => store_id
                                                            [REF_TABLE_NAME] => core_store
                                                            [REF_COLUMN_NAME] => store_id
                                                            [ON_DELETE] => SET NULL
                                                            [ON_UPDATE] => CASCADE
                                                        )

                                                )

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

                                        )

                                )

                        )

                    [8] => Array
                        (
                            [file] => /home/kidsboul/public_html/app/code/core/Mage/Core/Model/Resource/Setup.php
                            [line] => 624
                            [args] => Array
                                (
                                    [0] => /home/kidsboul/public_html/app/code/core/Mage/Sales/sql/sales_setup/upgrade-1.6.0.3-1.6.0.4.php
                                )

                            [function] => include
                        )

                    [9] => Array
                        (
                            [file] => /home/kidsboul/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.6.0.3
                                    [2] => 1.6.0.8
                                )

                        )

                    [10] => Array
                        (
                            [file] => /home/kidsboul/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.6.0.3
                                    [1] => 1.6.0.8
                                )

                        )

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

                        )

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

                        )

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

                        )

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

                                        )

                                )

                        )

                    [15] => Array
                        (
                            [file] => /home/kidsboul/public_html/index.php
                            [line] => 80
                            [function] => run
                            [class] => Mage
                            [type] => ::
                            [args] => Array
                                (
                                    [0] => 
                                    [1] => store
                                )

                        )

                )

            [previous:Exception:private] => 
            [errorInfo] => Array
                (
                    [0] => 42S01
                    [1] => 1050
                    [2] => Table 'sales_order_aggregated_updated' already exists
                )

        )

)