From 19ca3aa8dbc4f551836cd0dac9150118c9128ee1 Mon Sep 17 00:00:00 2001
From: "terry%netscape.com" <>
Date: Wed, 24 Mar 1999 06:32:19 +0000
Subject: Can now query for a specified field being changed at a specified
 time, optionally to a specified value.

---
 makeactivitytable.sh | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'makeactivitytable.sh')

diff --git a/makeactivitytable.sh b/makeactivitytable.sh
index 047d81e7e..9af62ef61 100755
--- a/makeactivitytable.sh
+++ b/makeactivitytable.sh
@@ -24,7 +24,6 @@ use bugs;
 
 drop table bugs_activity
 OK_ALL_DONE
-
 mysql << OK_ALL_DONE
 use bugs;
 create table bugs_activity (
@@ -36,7 +35,8 @@ create table bugs_activity (
         newvalue tinytext,
 
         index (bug_id),
-        index (when)
+        index (when),
+	index (field)
 );
 
 
-- 
cgit v1.2.3-24-g4f1b