Changeset 23646
- Timestamp:
- 2014/10/11 20:30:22 (9 years ago)
- 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 329 329 del_flg smallint NOT NULL DEFAULT 0, 330 330 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) 332 332 ); 333 333 -
branches/version-2_13-dev/html/install/sql/create_table_pgsql.sql
r23644 r23646 329 329 del_flg smallint NOT NULL DEFAULT 0, 330 330 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) /* キー名競合回避 */ 332 332 ); 333 333 … … 1241 1241 CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id (url); 1242 1242 CREATE 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;1243 CREATE 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.