ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 7746


Ignore:
Timestamp:
Jul 18, 2008, 1:53:41 PM (13 years ago)
Author:
ebihara
Message:

#2753:tmp_c_diary_comment_log へのインサートをおこなっていなかったのを修正

File:
1 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/trunk/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql

    r7689 r7746  
    252252);
    253253
    254 INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
    255   (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
     254INSERT INTO tmp_c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
     255  (SELECT nextval('tmp_c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
    256256    FROM c_diary_comment
    257257    GROUP BY c_member_id, c_diary_id
Note: See TracChangeset for help on using the changeset viewer.