Changeset 7681
- Timestamp:
- Jul 10, 2008, 6:31:29 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql
r7679 r7681 237 237 238 238 INSERT 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_datetime239 (SELECT nextval('c_diary_comment_log_c_diary_comment_log_id_seq'), c_member_id, c_diary_id, MAX(r_datetime) AS r_datetime 240 240 FROM c_diary_comment 241 241 GROUP BY c_member_id, c_diary_id … … 243 243 244 244 INSERT 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, 246 246 tmp_c_diary_comment_log.r_datetime as r_datetime 247 247 FROM tmp_c_diary_comment_log
Note: See TracChangeset
for help on using the changeset viewer.