Changeset 18824 for branches/version-2_5-dev/html/install/sql/create_view.sql

Timestamp:

2010/09/27 11:49:29 (14 years ago)

Author:

eccuore

Message:

#792(ダウンロード販売機能) vw_download_class削除、product_class_id対応（規格構成変更と並行作業中なので、作業途中の部分有）

File:

• branches/version-2_5-dev/html/install/sql/create_view.sql (modified) (1 diff)

branches/version-2_5-dev/html/install/sql/create_view.sql

@@ -102 +102 @@
             ON T2.category_id = dtb_category.category_id
 ;
-CREATE VIEW vw_download_class as
-        SELECT
-            pc.product_id AS product_id,
-            pc.classcategory_id1 AS classcategory_id1,
-            pc.classcategory_id2 AS classcategory_id2,
-            pc.down_realfilename AS down_realfilename,
-            pc.down_filename AS down_filename,
-            o.order_id AS order_id,
-            o.customer_id AS customer_id,
-            o.payment_date AS payment_date,
-            o.status AS status
-        FROM
-            dtb_products_class pc,
-            dtb_order_detail od,
-            dtb_order o
-        WHERE
-            pc.product_id = od.product_id AND
-            pc.classcategory_id1 = od.classcategory_id1 AND
-            pc.classcategory_id2 = od.classcategory_id2 AND
-            od.order_id = o.order_id
-;