aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/write_session.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/secd/store/pg/sql/write_session.sql')
-rw-r--r--crates/secd/store/pg/sql/write_session.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/crates/secd/store/pg/sql/write_session.sql b/crates/secd/store/pg/sql/write_session.sql
deleted file mode 100644
index aa9c0a1..0000000
--- a/crates/secd/store/pg/sql/write_session.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-insert into secd.session (
- identity_id
- , token_hash
- , created_at
- , expired_at
- , revoked_at
-) 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;