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