Changeset 11560

Timestamp:

May 1, 2009, 4:53:22 PM (13 years ago)

Author:

kiwa

Message:

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

File:

• OpenPNE/trunk/setup/sql/mysql41/install/install-2.13.8-create_tables.sql (modified) (3 diffs)

OpenPNE/trunk/setup/sql/mysql41/install/install-2.13.8-create_tables.sql

@@ -671 +671 @@
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000;
 
+CREATE TABLE `c_image_size` (
+  `c_image_size_id` int(11) NOT NULL auto_increment,
+  `filename` text NOT NULL,
+  `c_member_id` int(11) NOT NULL default '0',
+  `filesize` int(11) NOT NULL default '0',
+  `image_category` enum('album','diary','commu','other') NOT NULL default 'other',
+  `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
+  PRIMARY KEY  (`c_image_size_id`),
+  KEY `c_member_id` (`c_member_id`),
+  KEY `c_member_id_image_category` (`c_member_id`,`image_category`),
+  KEY `filename` (`filename`(100))
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;
+
 CREATE TABLE `c_ktai_address_pre` (
   `c_ktai_address_pre_id` int(11) NOT NULL auto_increment,
@@ -772 +785 @@
   `is_disabled_regist_easy_access_id` tinyint(1) NOT NULL default '0',
   `login_id` varchar(255) NOT NULL default '',
+  `is_sns_entry_confirm` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`c_member_pre_id`),
   UNIQUE KEY `session` (`session`)
@@ -1114 +1128 @@
   `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
   `type` text,
+  `filesize` int(11) NOT NULL default '0',
   PRIMARY KEY  (`c_tmp_image_id`),
   KEY `filename` (`filename`(100))