Ignore:
Timestamp:
2010/09/20 20:40:27 (16 years ago)
Author:
nanasess
bzr:base-revision:
svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18814
bzr:committer:
Kentaro Ohkouchi <[email protected]>
bzr:file-ids:

data/Smarty/templates/default/admin/products/product_class.tpl 15732@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2FSmarty%2Ftemplates%2Fdefault%2Fadmin%2Fproducts%2Fproduct_class.tpl
data/class/SC_Initial.php 16506@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Initial.php
data/class/SC_Product.php 18277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2FSC_Product.php
data/class/SC_Query.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Query.php
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php 15123@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fdb%2Fdbfactory%2FSC_DB_DBFactory_MYSQL.php
data/class/helper/SC_Helper_CSV.php 15535@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_CSV.php
data/class/helper/SC_Helper_DB.php 15176@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_DB.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php 15661@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_RecommendSearch.php
data/class/pages/admin/customer/LC_Page_Admin_Customer.php 15568@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcustomer%2FLC_Page_Admin_Customer.php
data/class/pages/admin/mail/LC_Page_Admin_Mail.php 15640@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail.php
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php 15654@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail_Preview.php
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php 17293@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fadmin%2Forder%2FLC_Page_Admin_Order_ProductSelect.php
data/class/pages/admin/products/LC_Page_Admin_Products.php 15342@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products.php
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php 15342@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_Product.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php 15559@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductClass.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php 15526@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductRank.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php 15557@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fproducts%2FLC_Page_Admin_Products_ProductSelect.php
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php 15367@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Ffrontparts%2Fbloc%2FLC_Page_FrontParts_Bloc_Best5.php
data/class/pages/mypage/LC_Page_Mypage_Favorite.php 17162@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Favorite.php
data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php
data/class/pages/products/LC_Page_Products_List.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_List.php
data/class/pages/rss/LC_Page_Rss_Products.php 16193@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Frss%2FLC_Page_Rss_Products.php
data/class/pages/shopping/LC_Page_Shopping_Complete.php 15223@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fshopping%2FLC_Page_Shopping_Complete.php
data/class/util/SC_Utils.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Futil%2FSC_Utils.php
data/install.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Finstall.php
data/require_classes.php 18500@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_4-dev%2Fdata%2Frequire_classes.php
html/admin/require.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Fadmin%2Frequire.php
html/handle_error.php 18500@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fversion-2_4-dev%2Fhtml%2Fhandle_error.php
html/install/index.php 16809@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Findex.php
html/install/sql/create_table_mysql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_mysql.sql
html/install/sql/create_table_pgsql.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_table_pgsql.sql
html/install/sql/create_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fcreate_view.sql
html/install/sql/drop_table.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_table.sql
html/install/sql/drop_view.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Fdrop_view.sql
html/install/sql/insert_data.sql 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Finstall%2Fsql%2Finsert_data.sql
html/require.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fhtml%2Frequire.php
test/class/page/LC_Page_Admin_Products_ProductClass_Test.php lc_page_admin_produc-20100910101923-ux7d8xbbsd4inq1c-1
bzr:mapping-version:
v4
bzr:merge:

[email protected]
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
[email protected]
bzr:revno:
2298
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-parents:

data/Smarty/templates/default/admin/products/product_class.tpl [email protected]
data/class/SC_Initial.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18795 [email protected]
data/class/SC_Product.php [email protected]
data/class/SC_Query.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18813 [email protected]
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php [email protected]
data/class/helper/SC_Helper_CSV.php [email protected]
data/class/helper/SC_Helper_DB.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php [email protected]
data/class/pages/admin/customer/LC_Page_Admin_Customer.php [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18798 [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php [email protected]
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php [email protected]
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Favorite.php [email protected]
data/class/pages/products/LC_Page_Products_Detail.php [email protected]
data/class/pages/products/LC_Page_Products_List.php [email protected]
data/class/pages/rss/LC_Page_Rss_Products.php [email protected]
data/class/pages/shopping/LC_Page_Shopping_Complete.php [email protected]
data/class/util/SC_Utils.php svn-v4:1e3b908f-19a9-db11-a64c-001125224ba8:branches/version-2_5-dev:18812 [email protected]
data/install.php [email protected]
data/require_classes.php [email protected]
html/admin/require.php [email protected] [email protected]
html/handle_error.php [email protected] [email protected]
html/install/index.php [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/create_view.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql [email protected]
html/install/sql/insert_data.sql [email protected]
html/require.php [email protected] [email protected]
bzr:text-revisions:

data/Smarty/templates/default/admin/products/product_class.tpl [email protected]
data/class/SC_Product.php [email protected]
data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php [email protected]
data/class/helper/SC_Helper_CSV.php [email protected]
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php [email protected]
data/class/pages/admin/customer/LC_Page_Admin_Customer.php [email protected]
data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php [email protected]
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductRank.php [email protected]
data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php [email protected]
data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Best5.php [email protected]
data/class/pages/mypage/LC_Page_Mypage_Favorite.php [email protected]
data/class/pages/products/LC_Page_Products_Detail.php [email protected]
data/class/pages/products/LC_Page_Products_List.php [email protected]
data/class/pages/rss/LC_Page_Rss_Products.php [email protected]
data/class/pages/shopping/LC_Page_Shopping_Complete.php [email protected]
data/require_classes.php [email protected]
html/install/index.php [email protected]
html/install/sql/create_table_mysql.sql [email protected]
html/install/sql/create_table_pgsql.sql [email protected]
html/install/sql/create_view.sql [email protected]
html/install/sql/drop_table.sql [email protected]
html/install/sql/drop_view.sql [email protected]
html/install/sql/insert_data.sql [email protected]
test/class/page/LC_Page_Admin_Products_ProductClass_Test.php [email protected]
bzr:timestamp:
2010-09-20 20:39:58.994999886 +0900
bzr:user-agent:
bzr2.1.1+bzr-svn1.0.2
svn:original-date:
2010-09-20T11:39:58.995000Z
Message:

規格まわりの内部構成変更に伴う修正(#781)

  • 規格のデータ構造を木構造へ変更
  • 商品検索ロジックを SC_Product クラスへできるだけ集約
  • 以下の VIEW を削除
    • vw_category_count;
    • vw_product_class;
    • vw_products_nonclass;
    • vw_cross_products_class;
    • vw_cross_class;
    • vw_download_class;
Location:
branches/version-2_5-dev/html/install
Files:
7 edited

Legend:

Unmodified
Added
Removed

  • branches/version-2_5-dev/html/install/index.php

    r18794 r18815  
    972972                 array("dtb_products_class", "product_class_id"), 
    973973                 array("dtb_products", "product_id"), 
     974                 array("dtb_class_combination", "class_combination_id"), 
    974975                 array("dtb_review", "review_id"), 
    975976                 array("dtb_send_history", "send_id"), 

  • branches/version-2_5-dev/html/install/sql/create_table_mysql.sql

    r18791 r18815  
    256256CREATE TABLE dtb_products ( 
    257257    product_id int  NOT NULL, 
    258     name text, 
    259     deliv_fee numeric, 
    260     sale_limit numeric, 
    261     category_id int, 
     258    name text NOT NULL, 
    262259    maker_id int, 
    263260    rank int, 
    264261    status smallint NOT NULL DEFAULT 2, 
    265     product_flag text, 
    266     point_rate numeric, 
    267262    comment1 text, 
    268263    comment2 text, 
    … …  
    312307    update_date datetime, 
    313308    deliv_date_id int, 
    314     down smallint NOT NULL , 
     309    down smallint NOT NULL DEFAULT 0, 
    315310    down_filename text, 
    316311    down_realfilename text, 
    … …  
    321316    product_class_id int  NOT NULL, 
    322317    product_id int NOT NULL, 
    323     classcategory_id1 int NOT NULL DEFAULT 0, 
    324     classcategory_id2 int NOT NULL DEFAULT 0, 
     318    class_combination_id int, 
    325319    product_code text, 
    326320    stock numeric, 
    327321    stock_unlimited smallint NOT NULL DEFAULT 0, 
    328322    sale_limit numeric, 
     323    sale_unlimited smallint NOT NULL DEFAULT 0, 
    329324    price01 numeric, 
    330325    price02 numeric, 
     326    deliv_fee numeric, 
     327    point_rate numeric, 
    331328    status smallint, 
    332329    creator_id int NOT NULL, 
    333330    create_date datetime NOT NULL, 
    334331    update_date datetime, 
     332    del_flg smallint NOT NULL DEFAULT 0, 
    335333    PRIMARY KEY (product_class_id) 
    336334) TYPE=InnoDB; 
    … …  
    345343    update_date datetime, 
    346344    del_flg smallint NOT NULL DEFAULT 0, 
    347     product_id int, 
    348345    PRIMARY KEY (class_id) 
    349346) TYPE=InnoDB; 
    … …  
    360357    del_flg smallint NOT NULL DEFAULT 0, 
    361358    PRIMARY KEY (classcategory_id) 
     359) TYPE=InnoDB; 
     360 
     361CREATE TABLE dtb_class_combination ( 
     362    class_combination_id int NOT NULL, 
     363    parent_class_combination_id int, 
     364    classcategory_id int NOT NULL, 
     365    level int, 
     366    PRIMARY KEY(class_combination_id) 
    362367) TYPE=InnoDB; 
    363368 
    … …  
    380385    rank int NOT NULL, 
    381386    PRIMARY KEY(product_id, category_id) 
     387) TYPE=InnoDB; 
     388 
     389CREATE TABLE dtb_product_status ( 
     390    product_status_id smallint NOT NULL, 
     391    product_id int NOT NULL, 
     392    creator_id int NOT NULL, 
     393    create_date datetime NOT NULL, 
     394    update_date datetime, 
     395    del_flg smallint NOT NULL DEFAULT 0, 
     396    PRIMARY KEY(product_status_id, product_id) 
    382397) TYPE=InnoDB; 
    383398 

  • branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql

    r18791 r18815  
    256256CREATE TABLE dtb_products ( 
    257257    product_id int NOT NULL, 
    258     name text, 
    259     deliv_fee numeric, 
    260     sale_limit numeric, 
    261     category_id int, 
     258    name text NOT NULL, 
    262259    maker_id int, 
    263260    rank int, 
    264261    status smallint NOT NULL DEFAULT 2, 
    265     product_flag text, 
    266     point_rate numeric, 
    267262    comment1 text, 
    268263    comment2 text, 
    … …  
    312307    update_date timestamp, 
    313308    deliv_date_id int, 
    314     down int2 NOT NULL , 
     309    down smallint NOT NULL DEFAULT 0, 
    315310    down_filename text, 
    316311    down_realfilename text, 
    … …  
    321316    product_class_id int NOT NULL, 
    322317    product_id int NOT NULL, 
    323     classcategory_id1 int NOT NULL DEFAULT 0, 
    324     classcategory_id2 int NOT NULL DEFAULT 0, 
     318    class_combination_id int, 
    325319    product_code text, 
    326320    stock numeric, 
    327321    stock_unlimited smallint NOT NULL DEFAULT 0, 
    328322    sale_limit numeric, 
     323    sale_unlimited smallint NOT NULL DEFAULT 0, 
    329324    price01 numeric, 
    330325    price02 numeric, 
     326    deliv_fee numeric, 
     327    point_rate numeric, 
    331328    status smallint, 
    332329    creator_id int NOT NULL, 
    333330    create_date timestamp NOT NULL DEFAULT now(), 
    334331    update_date timestamp, 
     332    del_flg smallint NOT NULL DEFAULT 0, 
    335333    PRIMARY KEY (product_class_id) 
    336334); 
    … …  
    345343    update_date timestamp, 
    346344    del_flg smallint NOT NULL DEFAULT 0, 
    347     product_id int, 
    348345    PRIMARY KEY (class_id) 
    349346); 
    … …  
    360357    del_flg smallint NOT NULL DEFAULT 0, 
    361358    PRIMARY KEY (classcategory_id) 
     359); 
     360 
     361CREATE TABLE dtb_class_combination ( 
     362    class_combination_id int NOT NULL, 
     363    parent_class_combination_id int, 
     364    classcategory_id int NOT NULL, 
     365    level int, 
     366    PRIMARY KEY (class_combination_id) 
    362367); 
    363368 
    … …  
    381386    PRIMARY KEY(product_id, category_id) 
    382387); 
     388 
     389CREATE TABLE dtb_product_status ( 
     390    product_status_id smallint NOT NULL, 
     391    product_id int NOT NULL, 
     392    creator_id int NOT NULL, 
     393    create_date timestamp NOT NULL DEFAULT now(), 
     394    update_date timestamp, 
     395    del_flg smallint NOT NULL DEFAULT 0, 
     396    PRIMARY KEY (product_status_id, product_id) 
     397); 
     398 
    383399 
    384400CREATE TABLE dtb_bat_order_daily ( 

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

    r18777 r18815  
    1 CREATE VIEW vw_cross_class as 
    2     SELECT 
    3         T1.class_id AS class_id1, 
    4         T2.class_id AS class_id2, 
    5         T1.classcategory_id AS classcategory_id1, 
    6         T2.classcategory_id AS classcategory_id2, 
    7         T1.name AS name1, 
    8         T2.name AS name2, 
    9         T1.rank AS rank1, 
    10         T2.rank AS rank2 
    11     FROM 
    12         dtb_classcategory AS T1, 
    13         dtb_classcategory AS T2 
    14 ; 
    15  
    16 CREATE VIEW vw_cross_products_class AS 
    17     SELECT 
    18         T1.class_id1, 
    19         T1.class_id2, 
    20         T1.classcategory_id1, 
    21         T1.classcategory_id2, 
    22         T2.product_id, 
    23         T1.name1, 
    24         T1.name2, 
    25         T2.product_code, 
    26         T2.stock, 
    27         T2.price01, 
    28         T2.price02, 
    29         T1.rank1, 
    30         T1.rank2 
    31     FROM 
    32         vw_cross_class AS T1 
    33         LEFT JOIN dtb_products_class AS T2 
    34             ON T1.classcategory_id1 = T2.classcategory_id1 
    35             AND T1.classcategory_id2 = T2.classcategory_id2 
    36 ; 
    37  
    38 CREATE VIEW vw_products_nonclass AS 
    39     SELECT * 
    40     FROM 
    41         dtb_products AS T1 
    42         LEFT JOIN 
    43         ( 
    44             SELECT 
    45                 product_id AS product_id_sub, 
    46                 product_code, 
    47                 price01, 
    48                 price02, 
    49                 stock, 
    50                 stock_unlimited, 
    51                 classcategory_id1, 
    52                 classcategory_id2 
    53             FROM dtb_products_class 
    54             WHERE 
    55                 classcategory_id1 = 0 
    56                 AND classcategory_id2 = 0 
    57         ) AS T2 
    58         ON T1.product_id = T2.product_id_sub 
    59 ; 
    60  
    611CREATE VIEW vw_products_allclass_detail AS 
    622    SELECT 
    633        dtb_products.product_id, 
    644        dtb_products."name", 
    65         dtb_products.deliv_fee, 
    66         dtb_products.sale_limit, 
    675        dtb_products.maker_id, 
    686        dtb_products.rank, 
    697        dtb_products.status, 
    70         dtb_products.product_flag, 
    71         dtb_products.point_rate, 
    728        dtb_products.comment1, 
    739        dtb_products.comment2, 
    … …  
    169105            ON T2.category_id = dtb_category.category_id 
    170106; 
    171  
    172 CREATE VIEW vw_product_class AS 
    173      SELECT * 
    174        FROM 
    175       (SELECT T3.product_class_id, 
    176               T3.product_id AS product_id_sub, 
    177               classcategory_id1, 
    178               classcategory_id2, 
    179               T3.rank AS rank1, 
    180               T4.rank AS rank2, 
    181               T3.class_id AS class_id1, 
    182               T4.class_id AS class_id2, 
    183               stock, 
    184               price01, 
    185               price02, 
    186               stock_unlimited, 
    187               product_code 
    188          FROM (dtb_products_class AS T1 
    189     LEFT JOIN dtb_classcategory AS T2 
    190            ON T1.classcategory_id1 = T2.classcategory_id) AS T3 
    191   LEFT JOIN dtb_classcategory AS T4 
    192          ON T3.classcategory_id2 = T4.classcategory_id) AS T5 
    193   LEFT JOIN dtb_products AS T6 
    194          ON product_id_sub = T6.product_id; 
    195  
    196 CREATE VIEW vw_category_count AS 
    197      SELECT T1.category_id, 
    198             T1.category_name, 
    199             T1.parent_category_id, 
    200             T1.level, 
    201             T1.rank, 
    202             T2.product_count 
    203        FROM dtb_category AS T1 
    204   LEFT JOIN dtb_category_total_count AS T2 
    205          ON T1.category_id = T2.category_id 
    206 ; 
    207  
    208 CREATE VIEW vw_download_class as 
    209      SELECT 
    210           p.product_id AS product_id, 
    211           p.down_realfilename AS down_realfilename, 
    212           p.down_filename AS down_filename, 
    213           od.order_id AS order_id, 
    214           o.customer_id AS customer_id, 
    215           o.commit_date AS commit_date, 
    216           o.status AS status 
    217      FROM 
    218           dtb_products p, 
    219           dtb_order_detail od, 
    220           dtb_order o 
    221      WHERE 
    222           p.product_id = od.product_id AND 
    223           od.order_id = o.order_id; 

  • branches/version-2_5-dev/html/install/sql/drop_table.sql

    r18791 r18815  
    1313DROP TABLE dtb_products; 
    1414DROP TABLE dtb_products_class; 
     15DROP TABLE dtb_product_status; 
    1516DROP TABLE dtb_class; 
    1617DROP TABLE dtb_classcategory; 
     18DROP TABLE dtb_class_combination; 
    1719DROP TABLE dtb_category; 
    1820DROP TABLE dtb_product_categories; 

  • branches/version-2_5-dev/html/install/sql/drop_view.sql

    r18787 r18815  
    1 DROP VIEW vw_category_count; 
    2 DROP VIEW vw_product_class; 
    31DROP VIEW vw_products_allclass; 
    42DROP VIEW vw_products_allclass_detail; 
    5 DROP VIEW vw_products_nonclass; 
    6 DROP VIEW vw_cross_products_class; 
    7 DROP VIEW vw_cross_class; 
    8 DROP VIEW vw_download_class; 

  • branches/version-2_5-dev/html/install/sql/insert_data.sql

    r18791 r18815  
    3737INSERT INTO dtb_category_total_count (category_id, product_count, create_date) VALUES (4, 1, CURRENT_TIMESTAMP); 
    3838 
    39 INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg, product_id) VALUES (1, '味', NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, NULL); 
    40 INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg, product_id) VALUES (2, '大きさ', NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0, NULL); 
     39INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg) VALUES (1, '味', NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     40INSERT INTO dtb_class (class_id, name, status, rank, creator_id, create_date, update_date, del_flg) VALUES (2, '大きさ', NULL, 2, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    4141 
    4242INSERT INTO dtb_classcategory (classcategory_id, name, class_id, status, rank, creator_id, create_date, update_date, del_flg) VALUES (1, 'バニラ', 1, NULL, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
    … …  
    392392INSERT INTO dtb_product_categories (product_id, category_id, rank) VALUES (2, 4, 1); 
    393393 
    394 INSERT INTO dtb_products (product_id, name, deliv_fee, sale_limit, category_id, maker_id, rank, status, product_flag, point_rate, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id, down, down_filename, down_realfilename) VALUES (1, 'アイスクリーム', NULL, NULL, 5, NULL, 1, 1, '10010', 10, NULL, NULL, 'アイス,バニラ,チョコ,抹茶', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '暑い夏にどうぞ。', '08311201_44f65122ee5fe.jpg', '冷たいものはいかがですか？', '08311202_44f6515906a41.jpg', '08311203_44f651959bcb5.jpg', NULL, '<b>おいしいよ<b>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 2, 1, NULL, NULL); 
    395 INSERT INTO dtb_products (product_id, name, deliv_fee, sale_limit, category_id, maker_id, rank, status, product_flag, point_rate, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id, down, down_filename, down_realfilename) VALUES (2, 'おなべ', NULL, 5, NULL, NULL, 1, 1, '11001', 5, NULL, NULL, '鍋,なべ,ナベ', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '一人用からあります。', '08311311_44f661811fec0.jpg', 'たまには鍋でもどうでしょう。', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 3, 1, NULL, NULL); 
    396  
    397 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (1, 1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    398 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (2, 1, 3, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    399 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (3, 1, 3, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    400 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (4, 1, 2, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    401 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (5, 1, 2, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    402 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (6, 1, 2, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    403 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (7, 1, 1, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    404 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (8, 1, 1, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    405 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (9, 1, 1, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
    406 INSERT INTO dtb_products_class (product_class_id, product_id, classcategory_id1, classcategory_id2, product_code, stock, stock_unlimited, sale_limit, price01, price02, status, creator_id, create_date, update_date) VALUES (10, 2, 0, 0, 'nabe-01', 100, 0, NULL, 1700, 1650, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
     394INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (1, 'アイスクリーム', NULL, 1, 1, NULL, NULL, 'アイス,バニラ,チョコ,抹茶', NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', '暑い夏にどうぞ。', '08311201_44f65122ee5fe.jpg', '冷たいものはいかがですか?', '08311202_44f6515906a41.jpg', '08311203_44f651959bcb5.jpg', '', '<b>おいしいよ<b>', 'NULL', NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 2); 
     395INSERT INTO dtb_products (product_id, name, maker_id, rank, status, comment1, comment2, comment3, comment4, comment5, comment6, note, file1, file2, file3, file4, file5, file6, main_list_comment, main_list_image, main_comment, main_image, main_large_image, sub_title1, sub_comment1, sub_image1, sub_large_image1, sub_title2, sub_comment2, sub_image2, sub_large_image2, sub_title3, sub_comment3, sub_image3, sub_large_image3, sub_title4, sub_comment4, sub_image4, sub_large_image4, sub_title5, sub_comment5, sub_image5, sub_large_image5, sub_title6, sub_comment6, sub_image6, sub_large_image6, del_flg, creator_id, create_date, update_date, deliv_date_id) VALUES (2, 'おなべ', NULL, 1, 1, NULL, NULL, '鍋,なべ,ナベ', NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', '一人用からあります。', '08311311_44f661811fec0.jpg', 'たまには鍋でもどうでしょう。', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', '', 'NULL', 'NULL', NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NULL', NULL, NULL, NULL, 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 3); 
     396 
     397INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(1, 1, 10, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, 10, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     398INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(2, 1, 11, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, 5, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     399INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(3, 1, 12, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     400INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(4, 1, 13, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     401INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(5, 1, 14, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     402INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(6, 1, 15, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     403INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(7, 1, 16, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     404INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(8, 1, 17, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     405INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(9, 1, 18, 'ice-01', NULL, 1, NULL, 0, 150, 120, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     406INSERT INTO dtb_products_class (product_class_id, product_id, class_combination_id, product_code, stock, stock_unlimited, sale_limit, sale_unlimited, price01, price02, deliv_fee, point_rate, status, creator_id, create_date, update_date, del_flg) VALUES(10, 2, NULL, 'nabe-01', 100, 0, 5, 0, 1700, 1650, NULL, NULL, NULL, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 0); 
     407 
     408INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(1, NULL, 3, 1); 
     409INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(2, NULL, 3, 1); 
     410INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(3, NULL, 3, 1); 
     411INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(4, NULL, 2, 1); 
     412INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(5, NULL, 2, 1); 
     413INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(6, NULL, 2, 1); 
     414INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(7, NULL, 1, 1); 
     415INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(8, NULL, 1, 1); 
     416INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(9, NULL, 1, 1); 
     417INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(10, 1, 6, 2); 
     418INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(11, 2, 5, 2); 
     419INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(12, 3, 4, 2); 
     420INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(13, 4, 6, 2); 
     421INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(14, 5, 5, 2); 
     422INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(15, 6, 4, 2); 
     423INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(16, 7, 6, 2); 
     424INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(17, 8, 5, 2); 
     425INSERT INTO dtb_class_combination (class_combination_id, parent_class_combination_id, classcategory_id, level) VALUES(18, 9, 4, 2); 
     426 
     427INSERT INTO dtb_product_status (product_status_id, product_id, creator_id, create_date, update_date, del_flg) VALUES (1, 1, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 2); 
    407428 
    408429INSERT INTO dtb_recommend_products (product_id, recommend_product_id, rank, comment, status, creator_id, create_date, update_date) VALUES (2, 1, 4, 'お口直しに。', 0, 2, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP); 
Note: See TracChangeset for help on using the changeset viewer.