From 64b56724b5544abacd9c41dd075cf1b4344b1e70 Mon Sep 17 00:00:00 2001 From: adam Date: Sat, 1 Mar 2008 05:56:35 +0000 Subject: [PATCH] add createIndex() darcs-hash:20080301055635-5007d-c7113c4e3c52dca0d8cea7fa40ae2d5433266fb2.gz --- src/org/ibex/mail/SqliteDB.java | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) 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) { -- 1.7.10.4