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

Changeset 7681


Ignore:
Timestamp:
Jul 10, 2008, 6:31:29 PM (13 years ago)
Author:
ebihara
Message:

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

File:
1 edited

Legend:

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

    r7679 r7681  
    237237
    238238INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
    239   (SELECT NULL, c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
     239  (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
    240240    FROM c_diary_comment
    241241    GROUP BY c_member_id, c_diary_id
     
    243243
    244244INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
    245   (SELECT NULL, tmp_c_diary_comment_log.c_member_id, tmp_c_diary_comment_log.c_diary_id,
     245  (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,
    246246    tmp_c_diary_comment_log.r_datetime as r_datetime
    247247    FROM tmp_c_diary_comment_log
Note: See TracChangeset for help on using the changeset viewer.