Changeset 23665 for branches


Ignore:
Timestamp:
2014/10/28 11:16:38 (9 years ago)
Author:
Seasoft
Message:

#2325 (dtb_products_class の INDEX 追加)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql

    r23652 r23665  
    12421242CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); 
    12431243CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class (product_id) WHERE del_flg = 0; 
     1244CREATE INDEX dtb_products_class_product_code_key ON dtb_products_class (product_id,product_code) WHERE del_flg = 0; 
     1245CREATE INDEX dtb_products_class_price01_key ON dtb_products_class (product_id,price01) WHERE del_flg = 0; 
     1246CREATE INDEX dtb_products_class_price02_key ON dtb_products_class (product_id,price02) WHERE del_flg = 0; 
     1247CREATE INDEX dtb_products_class_stock_key ON dtb_products_class (product_id,stock) WHERE del_flg = 0; 
     1248CREATE INDEX dtb_products_class_stock_unlimited_key ON dtb_products_class (product_id,stock_unlimited) WHERE del_flg = 0; 
     1249CREATE INDEX dtb_products_class_point_rate_key ON dtb_products_class (product_id,point_rate) WHERE del_flg = 0; 
     1250CREATE INDEX dtb_products_class_deliv_fee_key ON dtb_products_class (product_id,deliv_fee) WHERE del_flg = 0; 
Note: See TracChangeset for help on using the changeset viewer.