diff options
| author | June McEnroe <june@causal.agency> | 2019-12-06 16:18:42 -0500 |
|---|---|---|
| committer | June McEnroe <june@causal.agency> | 2019-12-06 16:18:42 -0500 |
| commit | 44361901d3a0b3063c01d05899bdbfa26a8e5361 (patch) | |
| tree | fd2c3e0850df8e1faa5d163bf8b51e3eac2c5e22 /database.h | |
| parent | Rename IDs to nouns and join with USING (diff) | |
| download | litterbox-44361901d3a0b3063c01d05899bdbfa26a8e5361.tar.gz litterbox-44361901d3a0b3063c01d05899bdbfa26a8e5361.zip | |
Fold networks into contexts
Diffstat (limited to '')
| -rw-r--r-- | database.h | 6 |
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)" |