diff options
Diffstat (limited to 'internal/db/sql/sessions.sql')
| -rw-r--r-- | internal/db/sql/sessions.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/internal/db/sql/sessions.sql b/internal/db/sql/sessions.sql index 2be8b7ccc..f065b5f56 100644 --- a/internal/db/sql/sessions.sql +++ b/internal/db/sql/sessions.sql @@ -1,6 +1,7 @@ -- name: CreateSession :one INSERT INTO sessions ( id, + parent_session_id, title, message_count, prompt_tokens, @@ -15,6 +16,7 @@ INSERT INTO sessions ( ?, ?, ?, + ?, strftime('%s', 'now'), strftime('%s', 'now') ) RETURNING *; @@ -27,6 +29,7 @@ WHERE id = ? LIMIT 1; -- name: ListSessions :many SELECT * FROM sessions +WHERE parent_session_id is NULL ORDER BY created_at DESC; -- name: UpdateSession :one |