Changeset 17816 for branches/version-2_4/html

Timestamp:

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

Author:

kishida

Message:

text型にindex貼る場合、mysqlとpostgresで文法が違うので、別ファイルに記入する

Location:

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

Files:

• add/dtb_session_mysql.sql (modified) (1 diff)
• add/dtb_session_pgsql.sql (modified) (1 diff)
• insert_data.sql (modified) (1 diff)

branches/version-2_4/html/install/sql/add/dtb_session_mysql.sql

@@ -5 +5 @@
     update_date datetime NOT NULL
 ) TYPE=InnoDB;
+CREATE INDEX dtb_session_sess_id_key ON dtb_session (sess_id(32));

branches/version-2_4/html/install/sql/add/dtb_session_pgsql.sql

@@ -5 +5 @@
     update_date timestamp NOT NULL
 );
+CREATE INDEX dtb_session_sess_id_key ON dtb_session (sess_id);

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(32));
 
 INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date)