From d3b6bcaf493f19971d1a3401a0720daac82c9410 Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Fri, 10 Mar 2017 16:51:34 +0100
Subject: create index on id

---
 joblib.py | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'joblib.py')

diff --git a/joblib.py b/joblib.py
index 40ba814..0c529ea 100644
--- a/joblib.py
+++ b/joblib.py
@@ -33,7 +33,7 @@ class JobQueue(object):
             await con.execute("""
                 CREATE TABLE IF NOT EXISTS
                 jobs (
-                    id SERIAL,
+                    id SERIAL PRIMARY KEY,
                     priority INT DEFAULT 0,
                     status TEXT DEFAULT 'open',
                     type TEXT,
-- 
cgit v1.3.1