summaryrefslogtreecommitdiffstats
path: root/makebugtable.sh
diff options
context:
space:
mode:
authorterry%mozilla.org <>1999-05-06 06:18:38 +0200
committerterry%mozilla.org <>1999-05-06 06:18:38 +0200
commit5100352d43d8f1426360bbc3906d832c0447191b (patch)
treebd5934c1f0abf624e286e3f2fb85fb1b69e3fb01 /makebugtable.sh
parentdaffcd74e36eab5a9813f5187329fb396f8d7b6d (diff)
downloadbugzilla-5100352d43d8f1426360bbc3906d832c0447191b.tar.gz
bugzilla-5100352d43d8f1426360bbc3906d832c0447191b.tar.xz
Allow querying of bug creation times.
Diffstat (limited to 'makebugtable.sh')
-rwxr-xr-xmakebugtable.sh3
1 files changed, 2 insertions, 1 deletions
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),