From 0920c4d4f30a3345870d385d5c6f3e0919228b56 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Mon, 12 Dec 2022 17:06:57 -0800
Subject: (oauth2 + email added): a mess that may or may not really work and
 needs to be refactored...

---
 crates/secd/store/pg/sql/write_session.sql | 7 ++-----
 1 file changed, 2 insertions(+), 5 deletions(-)

(limited to 'crates/secd/store/pg/sql/write_session.sql')

diff --git a/crates/secd/store/pg/sql/write_session.sql b/crates/secd/store/pg/sql/write_session.sql
index 86cde55..1b238c6 100644
--- a/crates/secd/store/pg/sql/write_session.sql
+++ b/crates/secd/store/pg/sql/write_session.sql
@@ -2,8 +2,7 @@ insert into secd.session (
        identity_id
        , secret_hash
        , created_at
-       , touched_at
-       , expires_at
+       , expired_at
        , revoked_at
 ) values (
          (select identity_id from secd.identity where identity_public_id = $1)
@@ -11,8 +10,6 @@ insert into secd.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;
 --
-- 
cgit v1.2.3

