Ignore:
Timestamp:
2010/09/27 11:49:29 (11 years ago)
Author:
eccuore
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/html/install/sql/create_view.sql

    r18819 r18824  
    102102            ON T2.category_id = dtb_category.category_id 
    103103; 
    104 CREATE VIEW vw_download_class as 
    105         SELECT 
    106             pc.product_id AS product_id, 
    107             pc.classcategory_id1 AS classcategory_id1, 
    108             pc.classcategory_id2 AS classcategory_id2, 
    109             pc.down_realfilename AS down_realfilename, 
    110             pc.down_filename AS down_filename, 
    111             o.order_id AS order_id, 
    112             o.customer_id AS customer_id, 
    113             o.payment_date AS payment_date, 
    114             o.status AS status 
    115         FROM 
    116             dtb_products_class pc, 
    117             dtb_order_detail od, 
    118             dtb_order o 
    119         WHERE 
    120             pc.product_id = od.product_id AND 
    121             pc.classcategory_id1 = od.classcategory_id1 AND 
    122             pc.classcategory_id2 = od.classcategory_id2 AND 
    123             od.order_id = o.order_id 
    124 ; 
Note: See TracChangeset for help on using the changeset viewer.