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

Changeset 893


Ignore:
Timestamp:
Nov 24, 2006, 8:00:12 PM (14 years ago)
Author:
ebihara
Message:

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

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/ebihara/dev_2_6/setup/sql/update/update_20061121_diary_category.sql

    r810 r893  
    11CREATE TABLE `c_diary_category` (
    22  `c_diary_category_id` int(11) NOT NULL auto_increment,
    3   `category_name` text NOT NULL,
    4   `     c_member_id` int(11) NOT NULL default '0',
    5   `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
     3  `category_name` text collate utf8_unicode_ci NOT NULL,
     4  `c_member_id` int(11) NOT NULL,
     5  `r_datetime` datetime NOT NULL,
    66  PRIMARY KEY  (`c_diary_category_id`)
    7 ) TYPE=MyISAM;
     7) ENGINE=MyISAM DEFAULT CHARSET=utf8;
    88
    99CREATE TABLE `c_diary_category_diary` (
    1010  `c_diary_category_diary_id` int(11) NOT NULL auto_increment,
    1111  `c_diary_category_id` int(11) NOT NULL,
    12   `c_diary__id` int(11) NOT NULL,
     12  `c_diary_id` int(11) NOT NULL,
    1313  PRIMARY KEY  (`c_diary_category_diary_id`)
    14 ) TYPE=MyISAM;
     14) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Note: See TracChangeset for help on using the changeset viewer.