From 5f0e8a99661f7b4a9b7993bf3cf6f2fa3b78967e Mon Sep 17 00:00:00 2001
From: Ben Linskey
Date: Sun, 2 Feb 2014 01:47:08 -0500
Subject: Update lexicon index

This commit adds the greekLowercase column to the lexicon index. This will
hopefully speed up search queries a bit.
---
 src/com/benlinskey/grdbc/LexiconCreator.java | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'src/com/benlinskey/grdbc')

diff --git a/src/com/benlinskey/grdbc/LexiconCreator.java b/src/com/benlinskey/grdbc/LexiconCreator.java
index 3a242ff..f33007b 100644
--- a/src/com/benlinskey/grdbc/LexiconCreator.java
+++ b/src/com/benlinskey/grdbc/LexiconCreator.java
@@ -203,7 +203,8 @@ public class LexiconCreator {
 
         // Create an index on the three columns matched against search queries.
         String sql = "CREATE INDEX searchIndex ON " + TABLE_NAME
-                + " (betaNoSymbols, betaSymbols, greekNoSymbols)";
+                + " (betaNoSymbols, betaSymbols, greekNoSymbols, "
+                + "greekLowercase)";
         try {
             Statement statement = connection.createStatement();
             statement.executeUpdate(sql);
-- 
cgit v1.2.3