Changeset 6633
- Timestamp:
- Apr 18, 2008, 8:07:46 PM (14 years ago)
- Location:
- OpenPNE/trunk
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/setup/sql/mysql41/update/update-for2.12-db-tuning.sql
r6632 r6633 9 9 10 10 /* 日記コメント記入履歴Table */ 11 CREATE TABLE `c_diary_comment_ summary` (12 `c_diary_comment_ summary_id` int(11) NOT NULL auto_increment,11 CREATE TABLE `c_diary_comment_log` ( 12 `c_diary_comment_log_id` int(11) NOT NULL auto_increment, 13 13 `c_member_id` int(11) NOT NULL default '0', 14 14 `c_diary_id` int(11) NOT NULL default '0', 15 15 `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', 16 PRIMARY KEY (`c_diary_comment_ summary_id`)16 PRIMARY KEY (`c_diary_comment_log_id`) 17 17 ) ENGINE=MyISAM DEFAULT CHARSET=utf8; 18 18 19 CREATE INDEX `c_member_id_r_datetime` ON `c_diary_comment_ summary`(c_member_id,r_datetime);20 CREATE INDEX `c_diary_id` ON `c_diary_comment_ summary`(c_diary_id);21 CREATE INDEX `c_diary_id_r_datetime` ON `c_diary_comment_ summary`(c_diary_id,r_datetime);22 CREATE INDEX `c_member_id_c_diary_id` ON `c_diary_comment_ summary`(c_member_id,c_diary_id);19 CREATE INDEX `c_member_id_r_datetime` ON `c_diary_comment_log`(c_member_id,r_datetime); 20 CREATE INDEX `c_diary_id` ON `c_diary_comment_log`(c_diary_id); 21 CREATE INDEX `c_diary_id_r_datetime` ON `c_diary_comment_log`(c_diary_id,r_datetime); 22 CREATE INDEX `c_member_id_c_diary_id` ON `c_diary_comment_log`(c_member_id,c_diary_id); 23 23 24 24 /* 既存データのコンバート */ -
OpenPNE/trunk/webapp/lib/db/diary.php
r6631 r6633 544 544 545 545 $sql = 'SELECT c_diary_id, r_datetime as maxdate' . 546 ' FROM c_diary_comment_ summary' .546 ' FROM c_diary_comment_log' . 547 547 ' WHERE c_member_id = ?' . 548 548 ' ORDER BY maxdate DESC'; … … 566 566 { 567 567 $sql = 'SELECT c_diary_id, c_member_id, r_datetime' . 568 ' FROM c_diary_comment_ summary' .568 ' FROM c_diary_comment_log' . 569 569 ' WHERE c_member_id = ?' . 570 570 ' ORDER BY r_datetime DESC'; … … 580 580 581 581 $sql = 'SELECT c_diary_id' . 582 ' FROM c_diary_comment_ summary' .582 ' FROM c_diary_comment_log' . 583 583 ' WHERE c_member_id = ?'; 584 584 $params = array(intval($c_member_id)); … … 1044 1044 } 1045 1045 1046 $sql = 'DELETE FROM c_diary_comment_ summaryWHERE c_diary_id = ?';1046 $sql = 'DELETE FROM c_diary_comment_log WHERE c_diary_id = ?'; 1047 1047 db_query($sql, $params); 1048 1048 … … 1187 1187 * @param int $c_diary_id 1188 1188 */ 1189 function db_diary_insert_c_diary_comment_ summary($c_member_id, $c_diary_id)1190 { 1191 $sql = 'SELECT c_diary_id FROM c_diary_comment_ summary'1189 function db_diary_insert_c_diary_comment_log($c_member_id, $c_diary_id) 1190 { 1191 $sql = 'SELECT c_diary_id FROM c_diary_comment_log' 1192 1192 . ' WHERE c_member_id = ? AND c_diary_id = ?'; 1193 1193 $params = array(intval($c_member_id),intval($c_diary_id)); … … 1199 1199 'r_datetime' => db_now(), 1200 1200 ); 1201 $ins_id = db_insert('c_diary_comment_ summary', $data);1201 $ins_id = db_insert('c_diary_comment_log', $data); 1202 1202 } 1203 1203 } … … 1208 1208 * @param int $c_diary_id 1209 1209 */ 1210 function db_diary_update_c_diary_comment_ summary($c_diary_id)1210 function db_diary_update_c_diary_comment_log($c_diary_id) 1211 1211 { 1212 1212 $data = array( … … 1214 1214 ); 1215 1215 $where = array('c_diary_id' => intval($c_diary_id)); 1216 $rtn = db_update('c_diary_comment_ summary',$data,$where);1216 $rtn = db_update('c_diary_comment_log',$data,$where); 1217 1217 return array($ins_id,$rtn); 1218 1218 } … … 1227 1227 * 1228 1228 */ 1229 function db_diary_delete_c_diary_comment_ summary($c_member_id, $c_diary_id)1229 function db_diary_delete_c_diary_comment_log($c_member_id, $c_diary_id) 1230 1230 { 1231 1231 // 投稿したコメントの有無 … … 1236 1236 // コメントが無ければ履歴削除 1237 1237 if(!$count){ 1238 $sql = 'DELETE FROM c_diary_comment_ summary'1238 $sql = 'DELETE FROM c_diary_comment_log' 1239 1239 . ' WHERE c_member_id = ? AND c_diary_id = ?'; 1240 1240 $params = array(intval($c_member_id),intval($c_diary_id)); … … 1250 1250 ); 1251 1251 $where = array('c_diary_id' => intval($c_diary_id)); 1252 $rtn = db_update('c_diary_comment_ summary',$data,$where);1252 $rtn = db_update('c_diary_comment_log',$data,$where); 1253 1253 } 1254 1254 -
OpenPNE/trunk/webapp/modules/ktai/do/fh_diary_delete_c_diary_comment.php
r6631 r6633 35 35 36 36 //コメント記入履歴削除実行 37 db_diary_delete_c_diary_comment_ summary($target_c_member_id,$c_diary_comment['c_diary_id']);37 db_diary_delete_c_diary_comment_log($target_c_member_id,$c_diary_comment['c_diary_id']); 38 38 39 39 $p = array('target_c_diary_id' => $c_diary['c_diary_id']); -
OpenPNE/trunk/webapp/modules/ktai/do/fh_diary_insert_c_diary_comment.php
r6631 r6633 47 47 //日記コメント記入履歴追加 48 48 if ($u != $target_c_member_id) { 49 db_diary_insert_c_diary_comment_ summary($u,$target_c_diary_id);49 db_diary_insert_c_diary_comment_log($u,$target_c_diary_id); 50 50 } 51 51 //日記コメント記入履歴更新 52 db_diary_update_c_diary_comment_ summary($target_c_diary_id);52 db_diary_update_c_diary_comment_log($target_c_diary_id); 53 53 54 54 //日記コメントが書き込まれたので日記自体を未読扱いにする -
OpenPNE/trunk/webapp/modules/pc/do/fh_diary_delete_c_diary_comment.php
r6631 r6633 37 37 38 38 //コメント記入履歴削除実行 39 db_diary_delete_c_diary_comment_ summary($target_c_diary_comment['c_member_id'],$target_c_diary_id);39 db_diary_delete_c_diary_comment_log($target_c_diary_comment['c_member_id'],$target_c_diary_id); 40 40 } 41 41 -
OpenPNE/trunk/webapp/modules/pc/do/fh_diary_insert_c_diary_comment.php
r6631 r6633 58 58 //日記コメント記入履歴更新 59 59 if ($u != $target_c_member_id) { 60 db_diary_insert_c_diary_comment_ summary($u,$target_c_diary_id);60 db_diary_insert_c_diary_comment_log($u,$target_c_diary_id); 61 61 } 62 db_diary_update_c_diary_comment_ summary($target_c_diary_id);62 db_diary_update_c_diary_comment_log($target_c_diary_id); 63 63 64 64 //日記コメントが書き込まれたので日記自体を未読扱いにする
Note: See TracChangeset
for help on using the changeset viewer.