From: adam <adam@megacz.com>
Date: Sat, 1 Mar 2008 05:56:35 +0000 (+0000)
Subject: add createIndex()
X-Git-Url: http://git.megacz.com/?p=org.ibex.mail.git;a=commitdiff_plain;h=64b56724b5544abacd9c41dd075cf1b4344b1e70

add createIndex()

darcs-hash:20080301055635-5007d-c7113c4e3c52dca0d8cea7fa40ae2d5433266fb2.gz
---

diff --git a/src/org/ibex/mail/SqliteDB.java b/src/org/ibex/mail/SqliteDB.java
index 0ee1401..f6655a4 100644
--- a/src/org/ibex/mail/SqliteDB.java
+++ b/src/org/ibex/mail/SqliteDB.java
@@ -78,8 +78,9 @@ public class SqliteDB {
             ps.executeUpdate();
             tables.put(name, this);
         }
-        public void createIndex(String name, String column) throws SQLException {
-            PreparedStatement ps = conn.prepareStatement("create index if not exists "+name+" on "+column);
+        public void createIndex(String column) throws SQLException { createIndex(column, column+"_index"); }
+        public void createIndex(String indexName, String column) throws SQLException {
+            PreparedStatement ps = conn.prepareStatement("create index if not exists "+column+" on "+name+" ("+indexName+")");
             ps.executeUpdate();
         }
         protected void reap(String reapColumn) {