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

Changeset 7742


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

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

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

Legend:

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

    r7680 r7742  
    99);
    1010
    11 INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, 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
     11INSERT INTO tmp_c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
     12  (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
    1313    FROM c_diary_comment
    1414    WHERE r_datetime <= current_timestamp + '-15 days'
  • OpenPNE/branches/stable-2.12.x/setup/sql/postgres74/update/update17-for2.12RC2-convert_c_diary_comment.sql

    r7735 r7742  
    99);
    1010
    11 INSERT INTO c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, 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
     11INSERT INTO tmp_c_diary_comment_log (c_diary_comment_log_id, c_member_id, c_diary_id, r_datetime)
     12  (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
    1313    FROM c_diary_comment
    1414    GROUP BY c_member_id, c_diary_id
  • OpenPNE/branches/stable-2.12.x/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql

    r7688 r7742  
    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.