Changeset 6498

Timestamp:

Apr 10, 2008, 12:07:42 AM (12 years ago)

Author:

ogawa

Message:

#2205:mysql40修正

File:

• OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.6-create_tables.sql (modified) (3 diffs)

OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.6-create_tables.sql

@@ -500 +500 @@
 CREATE TABLE `c_diary_category` (
   `c_diary_category_id` int(11) NOT NULL auto_increment,
-  `category_name` text character set utf8 collate utf8_unicode_ci NOT NULL,
+  `category_name` text NOT NULL,
   `c_member_id` int(11) NOT NULL default '0',
   `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
@@ -594 +594 @@
 CREATE TABLE `c_holiday` (
   `c_holiday_id` int(11) NOT NULL auto_increment,
-  `name` text character set utf8 collate utf8_unicode_ci NOT NULL,
+  `name` text NOT NULL,
   `month` int(11) NOT NULL default '0',
   `day` int(11) NOT NULL default '0',
@@ -608 +608 @@
   PRIMARY KEY  (`c_image_id`),
   KEY `filename` (`filename`(100))
-) TYPE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000;
+) TYPE=MyISAM MAX_ROWS=190000;
 
 CREATE TABLE `c_ktai_address_pre` (