ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 6498


Ignore:
Timestamp:
Apr 10, 2008, 12:07:42 AM (12 years ago)
Author:
ogawa
Message:

#2205:mysql40修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/mysql40/install/install-2.11.6-create_tables.sql

    r6497 r6498  
    500500CREATE TABLE `c_diary_category` (
    501501  `c_diary_category_id` int(11) NOT NULL auto_increment,
    502   `category_name` text character set utf8 collate utf8_unicode_ci NOT NULL,
     502  `category_name` text NOT NULL,
    503503  `c_member_id` int(11) NOT NULL default '0',
    504504  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
     
    594594CREATE TABLE `c_holiday` (
    595595  `c_holiday_id` int(11) NOT NULL auto_increment,
    596   `name` text character set utf8 collate utf8_unicode_ci NOT NULL,
     596  `name` text NOT NULL,
    597597  `month` int(11) NOT NULL default '0',
    598598  `day` int(11) NOT NULL default '0',
     
    608608  PRIMARY KEY  (`c_image_id`),
    609609  KEY `filename` (`filename`(100))
    610 ) TYPE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000;
     610) TYPE=MyISAM MAX_ROWS=190000;
    611611
    612612CREATE TABLE `c_ktai_address_pre` (
Note: See TracChangeset for help on using the changeset viewer.