From 1ecc06c8b06acdd4a7589709ab27a99434ba71f8 Mon Sep 17 00:00:00 2001 From: Oleg Broytman Date: Wed, 22 Jul 2015 21:06:29 +0300 Subject: [PATCH] Create indices for the table --- xsetbg_db.py | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/xsetbg_db.py b/xsetbg_db.py index 77dc702..eedb25f 100755 --- a/xsetbg_db.py +++ b/xsetbg_db.py @@ -11,7 +11,7 @@ __all__ = ['xsetbg_db_path', 'xsetbg_db'] import os from sqlobject import SQLObject, connectionForURI, sqlhub, \ - StringCol, UnicodeCol, IntCol, BoolCol, dberrors + StringCol, UnicodeCol, IntCol, BoolCol, DatabaseIndex, dberrors from xsetbg_conf import xsetbg_conf @@ -27,6 +27,9 @@ class XSetBg(SQLObject): last_shown = IntCol(default=None) # timestamp flag = BoolCol(default=None) + last_shown_idx = DatabaseIndex('last_shown') + flag_idx = DatabaseIndex('flag') + db_dirs = [] try: -- 2.39.2