summary refs log tree commit diff stats
path: root/ganarchy.py
diff options
context:
space:
mode:
authorSoniEx2 <endermoneymod@gmail.com>2019-04-19 16:47:32 -0300
committerSoniEx2 <endermoneymod@gmail.com>2019-04-19 16:47:32 -0300
commit429d3d5b304fa0907c8a7838d7e6212233b881c2 (patch)
tree59161401d2bcab0b5516078b5342604a31dce298 /ganarchy.py
parentef608985145e905354e011fba1897301c1c932e8 (diff)
Index repo_history by URL
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()