Changeset 18824 for branches/version-2_5-dev/html
- Timestamp:
- 2010/09/27 11:49:29 (14 years ago)
- Location:
- branches/version-2_5-dev/html/install/sql
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r18820 r18824 765 765 order_id int NOT NULL, 766 766 product_id int NOT NULL, 767 classcategory_id1 int NOT NULL, 768 classcategory_id2 int NOT NULL, 767 product_class_id int NOT NULL, 769 768 product_name text NOT NULL, 770 769 product_code text, -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r18820 r18824 767 767 order_id int NOT NULL, 768 768 product_id int NOT NULL, 769 classcategory_id1 int NOT NULL, 770 classcategory_id2 int NOT NULL, 769 product_class_id int NOT NULL, 771 770 product_name text NOT NULL, 772 771 product_code text, -
branches/version-2_5-dev/html/install/sql/create_view.sql
r18819 r18824 102 102 ON T2.category_id = dtb_category.category_id 103 103 ; 104 CREATE VIEW vw_download_class as105 SELECT106 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 status115 FROM116 dtb_products_class pc,117 dtb_order_detail od,118 dtb_order o119 WHERE120 pc.product_id = od.product_id AND121 pc.classcategory_id1 = od.classcategory_id1 AND122 pc.classcategory_id2 = od.classcategory_id2 AND123 od.order_id = o.order_id124 ;
Note: See TracChangeset
for help on using the changeset viewer.