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

Changeset 11561


Ignore:
Timestamp:
May 1, 2009, 4:57:09 PM (11 years ago)
Author:
kiwa
Message:

#3907:2.13.8用セットアップSQL作成(MySQL4.0)

File:
1 edited

Legend:

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

    r11559 r11561  
    669669) TYPE=MyISAM MAX_ROWS=190000;
    670670
     671CREATE TABLE `c_image_size` (
     672  `c_image_size_id` int(11) NOT NULL auto_increment,
     673  `filename` text NOT NULL,
     674  `c_member_id` int(11) NOT NULL default '0',
     675  `filesize` int(11) NOT NULL default '0',
     676  `image_category` enum('album','diary','commu','other') NOT NULL default 'other',
     677  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
     678  PRIMARY KEY  (`c_image_size_id`),
     679  KEY `c_member_id` (`c_member_id`),
     680  KEY `c_member_id_image_category` (`c_member_id`,`image_category`),
     681  KEY `filename` (`filename`(100))
     682) TYPE=MyISAM;
     683
    671684CREATE TABLE `c_ktai_address_pre` (
    672685  `c_ktai_address_pre_id` int(11) NOT NULL auto_increment,
     
    770783  `is_disabled_regist_easy_access_id` tinyint(1) NOT NULL default '0',
    771784  `login_id` varchar(255) NOT NULL default '',
     785  `is_sns_entry_confirm` tinyint(1) NOT NULL default '0',
    772786  PRIMARY KEY  (`c_member_pre_id`),
    773787  UNIQUE KEY `session` (`session`)
     
    11121126  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    11131127  `type` text,
     1128  `filesize` int(11) NOT NULL default '0',
    11141129  PRIMARY KEY  (`c_tmp_image_id`),
    11151130  KEY `filename` (`filename`(100))
Note: See TracChangeset for help on using the changeset viewer.