Changeset 4672

Timestamp:

Dec 13, 2007, 1:42:47 PM (13 years ago)

Author:

ebihara

Message:

#1537:postgresqlのセットアップSQL内、c_pc_address_preのプライマリキーのカラム名間違いを修正

Location:

OpenPNE/trunk/setup/sql/postgres74

Files:

• install/install-2.10-create_tables.sql (modified) (1 diff)
• option/option-2.10.1to2.10.2-alter_c_pc_address_pre.sql (copied) (copied from OpenPNE/branches/stable-2.10.x/setup/sql/postgres74/option/option-2.10.1to2.10.2-alter_c_pc_address_pre.sql)

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

@@ -817 +817 @@
 
 CREATE TABLE c_pc_address_pre (
-  c_pc_addess_pre_id serial NOT NULL,
+  c_pc_address_pre_id serial NOT NULL,
   c_member_id int4 NOT NULL default '0',
   pc_address text NOT NULL,
   session varchar(32) NOT NULL default '',
   r_datetime timestamp NOT NULL default '0000-01-01 00:00:00',
-  PRIMARY KEY  (c_pc_addess_pre_id)
+  PRIMARY KEY  (c_pc_address_pre_id)
 );