summaryrefslogtreecommitdiffhomepage
path: root/internal/db/sql/files.sql
diff options
context:
space:
mode:
authoradamdottv <[email protected]>2025-05-13 13:08:43 -0500
committeradamdottv <[email protected]>2025-05-13 13:08:43 -0500
commit01b6bf5bb7307246cb2cca7f1cbc8aba693941cc (patch)
treef47f5aa2b323ce8fea55f6999308486ff790d26e /internal/db/sql/files.sql
parentd8f3b606258a5655d73acc94d6cb37b421350817 (diff)
downloadopencode-01b6bf5bb7307246cb2cca7f1cbc8aba693941cc.tar.gz
opencode-01b6bf5bb7307246cb2cca7f1cbc8aba693941cc.zip
chore: refactor db
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 *;