Create host index on targets table

jsha · jsha · commit dd607fb7e3af · 2014-01-14T23:05:40.000-08:00
diff --git a/utils/make-sqlite.py b/utils/make-sqlite.py
@@ -38,9 +38,9 @@ def nomes_all(where=sys.argv[1:]):
               contents TEXT)''')
 c.execute('''DROP TABLE IF EXISTS targets''')
 c.execute('''CREATE TABLE targets
-             (
-              host TEXT,
+             (host TEXT,
               ruleset_id INTEGER)''')
+c.execute('''CREATE INDEX host_index on targets(host)''')
 
 parser = etree.XMLParser(remove_blank_text=True)
 
