Changeset 17813

Timestamp:

2009/02/20 11:08:27 (15 years ago)

Author:

kishida

Message:

sess_idにindexを張る時は、長さを指定してindexを張るようにする

File:

• branches/version-2_4/html/install/sql/insert_data.sql (modified) (1 diff)

branches/version-2_4/html/install/sql/insert_data.sql

@@ -2 +2 @@
 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
 CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id);
-CREATE INDEX dtb_session_sess_id_key ON dtb_session(sess_id);
+CREATE INDEX dtb_session_sess_id_key ON dtb_session (sess_id(32));
 
 INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date)