Changeset 893

Timestamp:

Nov 24, 2006, 8:00:12 PM (16 years ago)

Author:

ebihara

Message:

update用SQLファイル（c_diary_categoryテーブル追加用）が正しくなかったのを修正

File:

• OpenPNE/branches/ebihara/dev_2_6/setup/sql/update/update_20061121_diary_category.sql (modified) (1 diff)

OpenPNE/branches/ebihara/dev_2_6/setup/sql/update/update_20061121_diary_category.sql

@@ -1 +1 @@
 CREATE TABLE `c_diary_category` (
   `c_diary_category_id` int(11) NOT NULL auto_increment,
-  `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',
+  `category_name` text collate utf8_unicode_ci NOT NULL,
+  `c_member_id` int(11) NOT NULL,
+  `r_datetime` datetime NOT NULL,
   PRIMARY KEY  (`c_diary_category_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 CREATE TABLE `c_diary_category_diary` (
   `c_diary_category_diary_id` int(11) NOT NULL auto_increment,
   `c_diary_category_id` int(11) NOT NULL,
-  `c_diary__id` int(11) NOT NULL,
+  `c_diary_id` int(11) NOT NULL,
   PRIMARY KEY  (`c_diary_category_diary_id`)
-) TYPE=MyISAM;
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;