From 1800d43d678a650f8a629c8fd375820ba78ae2cb Mon Sep 17 00:00:00 2001
From: adam <adam@megacz.com>
Date: Sat, 1 Mar 2008 05:53:08 +0000
Subject: [PATCH] add createIndex() calls to Whitelist

darcs-hash:20080301055308-5007d-a41eab9f08c6602719e08e1cc99bb259d157ba6b.gz
---
 src/org/ibex/mail/Whitelist.java |    3 +++
 1 file changed, 3 insertions(+)

diff --git a/src/org/ibex/mail/Whitelist.java b/src/org/ibex/mail/Whitelist.java
index f85181d..5d57407 100644
--- a/src/org/ibex/mail/Whitelist.java
+++ b/src/org/ibex/mail/Whitelist.java
@@ -17,8 +17,11 @@ public class Whitelist extends SqliteDB {
     public Whitelist(String filename) throws SQLException {
         super(filename);
         SqliteTable whitelist = getTable("whitelist", "(email)");
+        whitelist.createIndex("email");
         SqliteTable pending   = getTable("pending",   "(spamid,email,message,date)");
         pending.reap("date");
+        pending.createIndex("spamid");
+        pending.createIndex("email");
     }
 
     public boolean handleRequest(org.ibex.net.Connection c) {
-- 
1.7.10.4