Changeset 17816 for branches/version-2_4/html/install/sql/add

Timestamp:

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

Author:

kishida

Message:

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

Location:

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

Files:

• dtb_session_mysql.sql (modified) (1 diff)
• dtb_session_pgsql.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);