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

Timestamp:

2010/09/22 13:23:00 (14 years ago)

Author:

eccuore

Message:

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

File:

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

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

@@ -53 +53 @@
         dtb_products.update_date,
         dtb_products.deliv_date_id,
-        dtb_products.down,
-        dtb_products.down_filename,
-        dtb_products.down_realfilename,
         T4.product_code_min,
         T4.product_code_max,
@@ -105 +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
+;