Changeset 4941

Timestamp:

Jan 15, 2008, 2:37:37 PM (15 years ago)

Author:

ogawa

Message:

#1788:install-2.10の変更されていたSQLファイルを元に戻した

Location:

OpenPNE/trunk/setup/sql

Files:

• mysql40/install/install-2.10-create_tables.sql (modified) (1 diff)
• mysql41/install/install-2.10-create_tables.sql (modified) (1 diff)

OpenPNE/trunk/setup/sql/mysql40/install/install-2.10-create_tables.sql

@@ -789 +789 @@
 
 CREATE TABLE `c_pc_address_pre` (
-  `c_pc_address_pre_id` int(11) NOT NULL auto_increment,
+  `c_pc_addess_pre_id` int(11) NOT NULL auto_increment,
   `c_member_id` int(11) NOT NULL default '0',
   `pc_address` text NOT NULL,
   `session` varchar(32) NOT NULL default '',
   `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
-  PRIMARY KEY  (`c_pc_address_pre_id`),
+  PRIMARY KEY  (`c_pc_addess_pre_id`),
   KEY `c_member_id` (`c_member_id`)
 ) TYPE=MyISAM;

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

@@ -791 +791 @@
 
 CREATE TABLE `c_pc_address_pre` (
-  `c_pc_address_pre_id` int(11) NOT NULL auto_increment,
+  `c_pc_addess_pre_id` int(11) NOT NULL auto_increment,
   `c_member_id` int(11) NOT NULL default '0',
   `pc_address` text NOT NULL,
   `session` varchar(32) NOT NULL default '',
   `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00',
-  PRIMARY KEY  (`c_pc_address_pre_id`),
+  PRIMARY KEY  (`c_pc_addess_pre_id`),
   KEY `c_member_id` (`c_member_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;