Changeset 7681

Timestamp:

Jul 10, 2008, 6:31:29 PM (13 years ago)

Author:

ebihara

Message:

#2753:PostgreSQL版セットアップSQLで、 c_diary_comment_log に過去の日記コメント記入履歴を挿入できなくなっていたのを修正

File:

• OpenPNE/trunk/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql (modified) (2 diffs)

OpenPNE/trunk/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql

@@ -237 +237 @@
 
 INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
-  (SELECT NULL, c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
+  (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
     FROM c_diary_comment
     GROUP BY c_member_id, c_diary_id
@@ -243 +243 @@
 
 INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
-  (SELECT NULL, tmp_c_diary_comment_log.c_member_id, tmp_c_diary_comment_log.c_diary_id, 
+  (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), tmp_c_diary_comment_log.c_member_id, tmp_c_diary_comment_log.c_diary_id, 
     tmp_c_diary_comment_log.r_datetime as r_datetime
     FROM tmp_c_diary_comment_log