diff options
Diffstat (limited to 'src/main/db/schema.ts')
| -rw-r--r-- | src/main/db/schema.ts | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/main/db/schema.ts b/src/main/db/schema.ts index 39ee567..4c24c6a 100644 --- a/src/main/db/schema.ts +++ b/src/main/db/schema.ts | |||
| @@ -30,6 +30,11 @@ export function initSchema(db: Database.Database) { | |||
| 30 | created_at INTEGER NOT NULL DEFAULT (unixepoch()) | 30 | created_at INTEGER NOT NULL DEFAULT (unixepoch()) |
| 31 | ); | 31 | ); |
| 32 | 32 | ||
| 33 | CREATE TABLE IF NOT EXISTS settings ( | ||
| 34 | key TEXT PRIMARY KEY, | ||
| 35 | value TEXT NOT NULL | ||
| 36 | ); | ||
| 37 | |||
| 33 | CREATE INDEX IF NOT EXISTS idx_sessions_project ON sessions(project_id); | 38 | CREATE INDEX IF NOT EXISTS idx_sessions_project ON sessions(project_id); |
| 34 | CREATE INDEX IF NOT EXISTS idx_messages_session ON messages(session_id); | 39 | CREATE INDEX IF NOT EXISTS idx_messages_session ON messages(session_id); |
| 35 | `); | 40 | `); |
