diff options
Diffstat (limited to 'crates/secd/store/sqlite/sql')
| -rw-r--r-- | crates/secd/store/sqlite/sql/write_session.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/crates/secd/store/sqlite/sql/write_session.sql b/crates/secd/store/sqlite/sql/write_session.sql index 4679912..9ffb105 100644 --- a/crates/secd/store/sqlite/sql/write_session.sql +++ b/crates/secd/store/sqlite/sql/write_session.sql @@ -7,4 +7,5 @@ insert into session ( ) values ( (select identity_id from identity where identity_public_id = $1) , $2, $3, $4, $5 -); +) on conflict (token_hash) do update + set revoked_at = excluded.revoked_at; |