Changeset 15239 for branches/feature-module-update

Timestamp:

2007/08/08 16:14:24 (17 years ago)

Author:

nanasess

Message:

TEXT 型の PRIMARY KEY に データ長を指定

File:

• branches/feature-module-update/html/install/sql/add/mtb_tables_mysql.sql (modified) (2 diffs)

branches/feature-module-update/html/install/sql/add/mtb_tables_mysql.sql

@@ -3 +3 @@
     name text,
     rank int2 NOT NULL DEFAULT 0,
-    PRIMARY KEY (id)
+    PRIMARY KEY (id(32))
 ) TYPE=InnoDB;
 
@@ -256 +256 @@
     rank int2 NOT NULL DEFAULT 0,
     remarks text,
-    PRIMARY KEY (id)
-) TYPE=InnoDB;
+    PRIMARY KEY (id(32))
+) TYPE=InnoDB;