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

Changeset 11560


Ignore:
Timestamp:
May 1, 2009, 4:53:22 PM (13 years ago)
Author:
kiwa
Message:

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

File:
1 edited

Legend:

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

    r11559 r11560  
    671671) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000;
    672672
     673CREATE TABLE `c_image_size` (
     674  `c_image_size_id` int(11) NOT NULL auto_increment,
     675  `filename` text NOT NULL,
     676  `c_member_id` int(11) NOT NULL default '0',
     677  `filesize` int(11) NOT NULL default '0',
     678  `image_category` enum('album','diary','commu','other') NOT NULL default 'other',
     679  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
     680  PRIMARY KEY  (`c_image_size_id`),
     681  KEY `c_member_id` (`c_member_id`),
     682  KEY `c_member_id_image_category` (`c_member_id`,`image_category`),
     683  KEY `filename` (`filename`(100))
     684) ENGINE=MyISAM DEFAULT CHARSET=utf8;
     685
    673686CREATE TABLE `c_ktai_address_pre` (
    674687  `c_ktai_address_pre_id` int(11) NOT NULL auto_increment,
     
    772785  `is_disabled_regist_easy_access_id` tinyint(1) NOT NULL default '0',
    773786  `login_id` varchar(255) NOT NULL default '',
     787  `is_sns_entry_confirm` tinyint(1) NOT NULL default '0',
    774788  PRIMARY KEY  (`c_member_pre_id`),
    775789  UNIQUE KEY `session` (`session`)
     
    11141128  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
    11151129  `type` text,
     1130  `filesize` int(11) NOT NULL default '0',
    11161131  PRIMARY KEY  (`c_tmp_image_id`),
    11171132  KEY `filename` (`filename`(100))
Note: See TracChangeset for help on using the changeset viewer.