From f8aeecaf8cd33d87315c5a50be9a762e142062a4 Mon Sep 17 00:00:00 2001
From: "travis%sedsystems.ca" <>
Date: Wed, 9 Feb 2005 00:51:02 +0000
Subject: Bug 257315 : type of delta_ts in bugs table should not be timestamp
 Patch by Tomas Kopal <Tomas.Kopal@altap.cz>  r=mkanat, LpSolit   a=justdave

---
 globals.pl | 5 ++---
 1 file changed, 2 insertions(+), 3 deletions(-)

(limited to 'globals.pl')

diff --git a/globals.pl b/globals.pl
index 7a0ccebaa..f4a11e72f 100644
--- a/globals.pl
+++ b/globals.pl
@@ -137,7 +137,7 @@ sub AppendComment {
         "VALUES($bugid, $whoid, $timestamp, " . SqlQuote($comment) . ", " . 
         $privacyval . ", " . SqlQuote($work_time) . ")");
 
-    SendSQL("UPDATE bugs SET delta_ts = now() WHERE bug_id = $bugid");
+    SendSQL("UPDATE bugs SET delta_ts = $timestamp WHERE bug_id = $bugid");
 }
 
 sub GetFieldID {
@@ -1269,8 +1269,7 @@ sub RemoveVotes {
         SendSQL("SELECT SUM(vote_count) FROM votes WHERE bug_id = $id");
         my $v = FetchOneColumn();
         $v ||= 0;
-        SendSQL("UPDATE bugs SET votes = $v, delta_ts = delta_ts " .
-                "WHERE bug_id = $id");
+        SendSQL("UPDATE bugs SET votes = $v WHERE bug_id = $id");
     }
 }
 
-- 
cgit v1.2.1