summaryrefslogtreecommitdiffhomepage
path: root/internal/db/sql/files.sql
diff options
context:
space:
mode:
Diffstat (limited to 'internal/db/sql/files.sql')
-rw-r--r--internal/db/sql/files.sql8
1 files changed, 3 insertions, 5 deletions
diff --git a/internal/db/sql/files.sql b/internal/db/sql/files.sql
index aba2a6111..560a6984f 100644
--- a/internal/db/sql/files.sql
+++ b/internal/db/sql/files.sql
@@ -28,11 +28,9 @@ INSERT INTO files (
session_id,
path,
content,
- version,
- created_at,
- updated_at
+ version
) VALUES (
- ?, ?, ?, ?, ?, strftime('%s', 'now'), strftime('%s', 'now')
+ ?, ?, ?, ?, ?
)
RETURNING *;
@@ -41,7 +39,7 @@ UPDATE files
SET
content = ?,
version = ?,
- updated_at = strftime('%s', 'now')
+ updated_at = strftime('%Y-%m-%dT%H:%M:%f000Z', 'now')
WHERE id = ?
RETURNING *;