create index on id

1 files changed, 1 insertions, 1 deletions

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,