aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/sqlite/sql/write_session.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/secd/store/sqlite/sql/write_session.sql')
-rw-r--r--crates/secd/store/sqlite/sql/write_session.sql7
1 files changed, 2 insertions, 5 deletions
diff --git a/crates/secd/store/sqlite/sql/write_session.sql b/crates/secd/store/sqlite/sql/write_session.sql
index 3c26986..480af54 100644
--- a/crates/secd/store/sqlite/sql/write_session.sql
+++ b/crates/secd/store/sqlite/sql/write_session.sql
@@ -2,8 +2,7 @@ insert into session (
identity_id
, secret_hash
, created_at
- , touched_at
- , expires_at
+ , expired_at
, revoked_at
) values (
(select identity_id from identity where identity_public_id = ?1)
@@ -11,8 +10,6 @@ insert into session (
, ?3
, ?4
, ?5
- , ?6
) on conflict (secret_hash) do update
- set touched_at = excluded.touched_at
- , revoked_at = excluded.revoked_at;
+ set revoked_at = excluded.revoked_at;
--