Changeset 6460

Timestamp:

Apr 9, 2008, 7:42:50 PM (14 years ago)

Author:

ebihara

Message:

MySQL4.1以降用updateSQLに SET NAMES を指定

Location:

OpenPNE/trunk/setup/sql/mysql41/update

Files:

• update08-for2.11.6-create_c_config_decoration.sql (modified) (1 diff)
• update09-for2.11.6-create_c_member_config.sql (modified) (2 diffs)

OpenPNE/trunk/setup/sql/mysql41/update/update08-for2.11.6-create_c_config_decoration.sql

@@ +1 @@
+/*!40101 SET NAMES utf8 */;
 CREATE TABLE `c_config_decoration` (
   `c_config_decoration_id` int(11) NOT NULL auto_increment,

OpenPNE/trunk/setup/sql/mysql41/update/update09-for2.11.6-create_c_member_config.sql

@@ -1 @@
-/* ユーザ個別設定テーブル */
+/*!40101 SET NAMES utf8 */;
+
 CREATE TABLE `c_member_config` (
   `c_member_config_id` int(11) NOT NULL auto_increment,
@@ -18 +19 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-
-/* 携帯コメントメール通知オプション */
 INSERT INTO `c_member_config_option` VALUES (NULL,'SEND_COMMENT_MAIL_KTAI');