From 5100352d43d8f1426360bbc3906d832c0447191b Mon Sep 17 00:00:00 2001
From: "terry%mozilla.org" <>
Date: Thu, 6 May 1999 04:18:38 +0000
Subject: Allow querying of bug creation times.

---
 makebugtable.sh | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'makebugtable.sh')

diff --git a/makebugtable.sh b/makebugtable.sh
index c142b2d5a..18d83a66c 100755
--- a/makebugtable.sh
+++ b/makebugtable.sh
@@ -34,7 +34,7 @@ assigned_to mediumint not null, # This is a comment.
 bug_file_loc text,
 bug_severity enum("blocker", "critical", "major", "normal", "minor", "trivial", "enhancement") not null,
 bug_status enum("NEW", "ASSIGNED", "REOPENED", "RESOLVED", "VERIFIED", "CLOSED") not null,
-creation_ts datetime,
+creation_ts datetime not null,
 delta_ts timestamp,
 short_desc mediumtext,
 long_desc mediumtext,
@@ -52,6 +52,7 @@ qa_contact mediumint not null,
 status_whiteboard mediumtext not null,
 
 index (assigned_to),
+index (creation_ts),
 index (delta_ts),
 index (bug_severity),
 index (bug_status),
-- 
cgit v1.2.3-24-g4f1b