[whups] [patch] update_logs_table.php

[Jason M. Felice]

My old comments weren't showing up because there were no entries in
whups_logs for the comments in whups_comments.

The following patch to update_logs_table.php will add the appropriate
entries.

It's the first patch from `epm', my new patch manager, so let me know if it
horks (it applies fine here).

-- 
 Jason M. Felice
 Cronosys, LLC <http://www.cronosys.com/>
 216.221.4600 x302
-------------- next part --------------
epm diff update_logs_table.php
--- update_logs_table.php	2003-08-22 14:35:34.000000000 -0400
+++ update_logs_table.php	2003-08-22 14:37:08.000000000 -0400
@@ -72,6 +72,42 @@
     }
 }
 
+$sql = 'INSERT INTO whups_logs (
+	ticket_id,
+	state_id_to,
+	priority_id_to,
+	log_timestamp,
+	user_id,
+	comment_id_log,
+	type_id_to,
+	module_id_to,
+	user_uid_action,
+	user_uid_changed
+    ) SELECT
+	whups_comments.ticket_id,
+	whups_tickets.state_id,
+	whups_tickets.priority_id,
+	whups_comments.comment_timestamp,
+	whups_comments.user_id_creator,
+	whups_comments.comment_id,
+	whups_tickets.type_id,
+	whups_tickets.module_id,
+	NULL,
+	NULL
+    FROM
+	whups_comments,
+	whups_tickets
+    WHERE
+    	whups_tickets.ticket_id = whups_comments.ticket_id
+	AND whups_comments.comment_id NOT IN (
+	    SELECT comment_id_log FROM whups_logs
+	);';
+$result = $db->query($sql);
+if (is_a($result,'PEAR_Error')) {
+    $output .= 'Could not add log entries for old comments.';
+    $output .= $result->toString() . "\n\n";
+}
+
 if (empty($output)) {
     echo "Migrated successfully.\n";
 } else {