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

Changeset 7680


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

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

Location:
OpenPNE/branches/stable-2.12.x/setup/sql/postgres74
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • OpenPNE/branches/stable-2.12.x/setup/sql/postgres74/update/update13-for2.12beta1-fix_bug_c_diary_comment.sql

    r6729 r7680  
    1010
    1111INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
    12   (SELECT NULL, c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
     12  (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime
    1313    FROM c_diary_comment
    1414    WHERE r_datetime <= current_timestamp + '-15 days'
    … …  
    1717
    1818INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
    19   (SELECT NULL, tmp_c_diary_comment_log.c_member_id, tmp_c_diary_comment_log.c_diary_id,
     19  (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,
    2020    tmp_c_diary_comment_log.r_datetime as r_datetime
    2121    FROM tmp_c_diary_comment_log

  • OpenPNE/branches/stable-2.12.x/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql

    r7678 r7680  
    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.