Changeset 11322

Timestamp:

Apr 16, 2009, 4:25:02 PM (13 years ago)

Author:

kiwa

Message:

#3792:PostgreSQL用セットアップSQL作成

File:

• OpenPNE/trunk/setup/sql/postgres74/install/install-2.13.7-create_tables.sql (modified) (3 diffs)

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

@@ -325 +325 @@
   is_receive_mail_pc int4 NOT NULL default '0',
   is_receive_message int4 NOT NULL default '1',
+  is_display_topic_home smallint NOT NULL default '1',
   PRIMARY KEY  (c_commu_member_id)
 );
@@ -547 +548 @@
   public_flag varchar(20) NOT NULL default 'public',
   u_datetime timestamp NOT NULL default '0000-01-01 00:00:00',
+  is_comment_input smallint NOT NULL default '1',
   PRIMARY KEY  (c_diary_id)
 );
@@ -650 +652 @@
   intro text NOT NULL,
   r_datetime_intro timestamp NOT NULL default '0000-01-01 00:00:00',
+  is_display_friend_home smallint NOT NULL default '1',
   PRIMARY KEY  (c_friend_id)
 );