aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvgeny Zinoviev <me@ch1p.io>2022-11-18 04:12:39 +0300
committerEvgeny Zinoviev <me@ch1p.io>2022-11-18 04:12:39 +0300
commitf7eaeeb88e250f14ac6fceebce27815f7ae3b702 (patch)
treecfafbf18cb20d835dc2bf0654ed62149a6dc40a6
parent7d2f2a89ac7030dc3e13de735048b267c1b390b8 (diff)
fix sqlite syntax error
-rw-r--r--src/home/soundsensor/server.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/home/soundsensor/server.py b/src/home/soundsensor/server.py
index 3e4fa03..4b14bd0 100644
--- a/src/home/soundsensor/server.py
+++ b/src/home/soundsensor/server.py
@@ -45,7 +45,7 @@ class Database(SQLiteBase):
cursor = self.cursor()
if version < 1:
- cursor.execute("CREATE TABLE IF NOT EXISTS status (guard_enabled) INTEGER NOT NULL")
+ cursor.execute("CREATE TABLE IF NOT EXISTS status (guard_enabled INTEGER NOT NULL)")
cursor.execute("INSERT INTO status (guard_enabled) VALUES (-1)")
self.commit()