summary refs log tree commit diff stats
path: root/ganarchy.py
diff options
context:
space:
mode:
Diffstat (limited to 'ganarchy.py')
-rwxr-xr-xganarchy.py1
1 files changed, 1 insertions, 0 deletions
diff --git a/ganarchy.py b/ganarchy.py
index 22695ba..dffceca 100755
--- a/ganarchy.py
+++ b/ganarchy.py
@@ -87,6 +87,7 @@ def initdb():
     c.execute('''CREATE TABLE repos (url TEXT PRIMARY KEY, active INT)''')
     c.execute('''CREATE INDEX active_key ON repos (active)''')
     c.execute('''CREATE TABLE repo_history (entry INTEGER PRIMARY KEY ASC AUTOINCREMENT, url TEXT, count INTEGER, head_commit TEXT)''')
+    c.execute('''CREATE INDEX url_key ON repo_history (url)''')
     c.execute('''CREATE TABLE config (git_commit TEXT, project_title TEXT)''')
     c.execute('''INSERT INTO config VALUES ('', '')''')
     conn.commit()