summaryrefslogtreecommitdiffstats
path: root/contrib
diff options
context:
space:
mode:
authortravis%sedsystems.ca <>2005-02-09 01:51:02 +0100
committertravis%sedsystems.ca <>2005-02-09 01:51:02 +0100
commitf8aeecaf8cd33d87315c5a50be9a762e142062a4 (patch)
treec92dc215a4f6780005bacf825fb6fbdc39552ae1 /contrib
parentc0df359943e8b746f02f5c43d25e5ffea99f8d19 (diff)
downloadbugzilla-f8aeecaf8cd33d87315c5a50be9a762e142062a4.tar.gz
bugzilla-f8aeecaf8cd33d87315c5a50be9a762e142062a4.tar.xz
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
Diffstat (limited to 'contrib')
-rwxr-xr-xcontrib/bug_email.pl6
-rw-r--r--contrib/jb2bz.py2
2 files changed, 5 insertions, 3 deletions
diff --git a/contrib/bug_email.pl b/contrib/bug_email.pl
index 6589401e8..1f2f28421 100755
--- a/contrib/bug_email.pl
+++ b/contrib/bug_email.pl
@@ -38,7 +38,7 @@
#
# You need to work with bug_email.pl the MIME::Parser installed.
#
-# $Id: bug_email.pl,v 1.22 2005/01/30 04:22:28 justdave%bugzilla.org Exp $
+# $Id: bug_email.pl,v 1.23 2005/02/08 16:51:03 travis%sedsystems.ca Exp $
###############################################################
# 02/12/2000 (SML)
@@ -1085,7 +1085,7 @@ END
my $reporter = "";
my $query = "insert into bugs (\n" . join(",\n", @used_fields ) .
- ", bug_status, creation_ts, everconfirmed) values ( ";
+ ", bug_status, creation_ts, delta_ts, everconfirmed) values ( ";
# 'Yuck'. Then again, this whole file should be rewritten anyway...
$query =~ s/product/product_id/;
@@ -1140,7 +1140,7 @@ END
$state = SqlQuote("NEW");
}
- $query .= $state . ", \'$bug_when\', $ever_confirmed)\n";
+ $query .= $state . ", \'$bug_when\', \'$bug_when\', $ever_confirmed)\n";
# $query .= SqlQuote( "NEW" ) . ", now(), " . SqlQuote($comment) . " )\n";
SendSQL("SELECT userid FROM profiles WHERE login_name=\'$reporter\'");
diff --git a/contrib/jb2bz.py b/contrib/jb2bz.py
index dbd47ea7a..ed8231dfc 100644
--- a/contrib/jb2bz.py
+++ b/contrib/jb2bz.py
@@ -208,6 +208,7 @@ def process_jitterbug(filename):
"bug_severity='normal'," \
"bug_status=%s," \
"creation_ts=%s," \
+ "delta_ts=%s," \
"short_desc=%s," \
"product=%s," \
"rep_platform='All'," \
@@ -219,6 +220,7 @@ def process_jitterbug(filename):
[ current['number'],
bug_status,
time.strftime("%Y-%m-%d %H:%M:%S", current['date-reported'][:9]),
+ time.strftime("%Y-%m-%d %H:%M:%S", current['date-reported'][:9]),
current['short-description'],
product,
reporter,