From b3f0a14d9b3cdf8d029d02989031ecb4667fbcd0 Mon Sep 17 00:00:00 2001
From: Maxime Bourget <bmx007@gmail.com>
Date: Tue, 7 May 2013 18:09:47 +0100
Subject: [PATCH] Add denorm table

---
 hooks.php                          | 4 +++-
 sql/clean_sales_order_details.sql  | 8 +++++---
 sql/denorm_sales_order_details.sql | 2 ++
 3 files changed, 10 insertions(+), 4 deletions(-)
 create mode 100644 sql/denorm_sales_order_details.sql

diff --git a/hooks.php b/hooks.php
index 2425ba9..dfac389 100644
--- a/hooks.php
+++ b/hooks.php
@@ -42,7 +42,9 @@ class hooks_order_line_extra extends hooks {
         global $db_connections;
 
         $updates = array(
-            'alter_sales_order_details.sql' => array('sales_order_details', 'required_date')
+						'alter_sales_order_details.sql' => array('sales_order_details', 'required_date'),
+						'create_denorm_order_details_queue.sql' => array('denorm_order_details_queue'),
+
         );
 
         return $this->update_databases($company, $updates, $check_only);
diff --git a/sql/clean_sales_order_details.sql b/sql/clean_sales_order_details.sql
index 9202103..d8ebd99 100644
--- a/sql/clean_sales_order_details.sql
+++ b/sql/clean_sales_order_details.sql
@@ -1,4 +1,6 @@
 ALTER TABlE 0_sales_order_details
-DROP COLUMN required_date ,
-DROP COLUMN comment ,
-DROP COLUMN priority ;
+# DROP COLUMN required_date ,
+# DROP COLUMN comment ,
+# DROP COLUMN priority;
+
+DROP TABLE IF EXISTS 0_denorm_order_details_queue;
diff --git a/sql/denorm_sales_order_details.sql b/sql/denorm_sales_order_details.sql
new file mode 100644
index 0000000..867a9d3
--- /dev/null
+++ b/sql/denorm_sales_order_details.sql
@@ -0,0 +1,2 @@
+ALTER TABlE 0_sales_order_details
+ADD COLUMN denorm_quantity_in_queue INTEGER;
-- 
2.30.2