Compute available summary (and view)

[order_line_extra.git] / sql / clean_sales_order_details.sql

diff --git a/sql/clean_sales_order_details.sql b/sql/clean_sales_order_details.sql
index d8ebd99b9c4cda6d436e4ac8463f8f91af59ccab..2b70ddfea3873c180660c7cd6cab0e7c5406c165 100644 (file)
--- a/sql/clean_sales_order_details.sql
+++ b/sql/clean_sales_order_details.sql
@@ -4,3 +4,5 @@ ALTER TABlE 0_sales_order_details
 # DROP COLUMN priority;
 
 DROP TABLE IF EXISTS 0_denorm_order_details_queue;
+DROP TABLE IF EXISTS 0_denorm_qoh;
+DROP VIEW  IF EXISTS 0_order_summary_view;