diff options
Diffstat (limited to 'internal/db/sql')
| -rw-r--r-- | internal/db/sql/files.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/internal/db/sql/files.sql b/internal/db/sql/files.sql index c2e799076..aba2a6111 100644 --- a/internal/db/sql/files.sql +++ b/internal/db/sql/files.sql @@ -6,7 +6,9 @@ WHERE id = ? LIMIT 1; -- name: GetFileByPathAndSession :one SELECT * FROM files -WHERE path = ? AND session_id = ? LIMIT 1; +WHERE path = ? AND session_id = ? +ORDER BY created_at DESC +LIMIT 1; -- name: ListFilesBySession :many SELECT * |