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