summary refs log tree commit diff
path: root/database.h
diff options
context:
space:
mode:
authorJune McEnroe <june@causal.agency>2019-12-06 16:18:42 -0500
committerJune McEnroe <june@causal.agency>2019-12-06 16:18:42 -0500
commit44361901d3a0b3063c01d05899bdbfa26a8e5361 (patch)
treefd2c3e0850df8e1faa5d163bf8b51e3eac2c5e22 /database.h
parentRename IDs to nouns and join with USING (diff)
downloadlitterbox-44361901d3a0b3063c01d05899bdbfa26a8e5361.tar.gz
litterbox-44361901d3a0b3063c01d05899bdbfa26a8e5361.zip
Fold networks into contexts
Diffstat (limited to '')
-rw-r--r--database.h6
1 files changed, 1 insertions, 5 deletions
diff --git a/database.h b/database.h
index eec6cb6..485791b 100644
--- a/database.h
+++ b/database.h
@@ -150,13 +150,9 @@ static inline int dbVersion(sqlite3 *db) {
 
 static const char *InitSQL = {
 	"BEGIN TRANSACTION;"
-	"CREATE TABLE networks ("
-		"network INTEGER PRIMARY KEY,"
-		"name TEXT NOT NULL UNIQUE"
-	");"
 	"CREATE TABLE contexts ("
 		"context INTEGER PRIMARY KEY,"
-		"network INTEGER NOT NULL REFERENCES networks,"
+		"network TEXT NOT NULL,"
 		"name TEXT NOT NULL,"
 		"query BOOLEAN NOT NULL,"
 		"UNIQUE (network, name)"