Changeset 23646 for branches


Ignore:
Timestamp:
2014/10/11 20:30:22 (9 years ago)
Author:
Seasoft
Message:

rv r23645

  • 不具合原因ではなかったようなので戻します。
Location:
branches/version-2_13-dev/html/install/sql
Files:
2 edited

Legend:

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

    r23644 r23646  
    329329    del_flg smallint NOT NULL DEFAULT 0, 
    330330    PRIMARY KEY (product_class_id), 
    331     UNIQUE (product_id, classcategory_id1, classcategory_id2) 
     331    CONSTRAINT dtb_products_class_unique_key UNIQUE (product_id, classcategory_id1, classcategory_id2) 
    332332); 
    333333 
  • branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql

    r23644 r23646  
    329329    del_flg smallint NOT NULL DEFAULT 0, 
    330330    PRIMARY KEY (product_class_id), 
    331     UNIQUE (product_id, classcategory_id1, classcategory_id2) 
     331    CONSTRAINT dtb_products_class_unique_key UNIQUE (product_id, classcategory_id1, classcategory_id2) /* キー名競合回避 */ 
    332332); 
    333333 
     
    12411241CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); 
    12421242CREATE INDEX dtb_mobile_ext_session_id_create_date_key ON dtb_mobile_ext_session_id (create_date); 
    1243 CREATE INDEX dtb_products_class_product_id ON dtb_products_class (product_id) WHERE del_flg = 0; 
     1243CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class (product_id) WHERE del_flg = 0; 
Note: See TracChangeset for help on using the changeset viewer.