Changeset 18038 for branches/comu-ver2/html

Timestamp:

2009/06/03 22:39:58 (15 years ago)

Author:

Seasoft

Message:

dtb_session にプライマリキーを付与。

• 正式版の r17774 の改訂バージョン

Location:

branches/comu-ver2/html/install/sql/add

Files:

• dtb_session_mysql.sql (modified) (1 diff)
• dtb_session_pgsql.sql (modified) (1 diff)

branches/comu-ver2/html/install/sql/add/dtb_session_mysql.sql

@@ -1 +1 @@
 CREATE TABLE dtb_session (
-    sess_id text NOT NULL,
+    sess_id varchar(50) NOT NULL,
     sess_data text,
     create_date datetime NOT NULL,
-    update_date datetime NOT NULL
+    update_date datetime NOT NULL,
+    PRIMARY KEY (sess_id)
 ) TYPE=InnoDB;

branches/comu-ver2/html/install/sql/add/dtb_session_pgsql.sql

@@ -3 +3 @@
     sess_data text,
     create_date timestamp NOT NULL,
-    update_date timestamp NOT NULL
+    update_date timestamp NOT NULL,
+    PRIMARY KEY (sess_id)
 );