summary refs log tree commit diff stats
path: root/ganarchy.py
diff options
context:
space:
mode:
authorSoniEx2 <endermoneymod@gmail.com>2019-04-19 09:52:28 -0300
committerSoniEx2 <endermoneymod@gmail.com>2019-04-19 09:52:28 -0300
commit9b983f9862ac336340803d0870a05a1ed93914ee (patch)
tree908519d322a267c652fb2ad43d7e22dbdc065b10 /ganarchy.py
parentc38c2d321cd78828d9eb86a5b70c0197135a721a (diff)
Add an index
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 90e72c7..ed48538 100755
--- a/ganarchy.py
+++ b/ganarchy.py
@@ -85,6 +85,7 @@ def initdb():
     conn = sqlite3.connect(data_home + "/ganarchy.db")
     c = conn.cursor()
     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 TABLE config (git_commit TEXT, project_title TEXT)''')
     c.execute('''INSERT INTO config VALUES ('', '')''')