aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/find_identity_by_code.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/secd/store/pg/sql/find_identity_by_code.sql')
-rw-r--r--crates/secd/store/pg/sql/find_identity_by_code.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/crates/secd/store/pg/sql/find_identity_by_code.sql b/crates/secd/store/pg/sql/find_identity_by_code.sql
index 9df6614..e016a0e 100644
--- a/crates/secd/store/pg/sql/find_identity_by_code.sql
+++ b/crates/secd/store/pg/sql/find_identity_by_code.sql
@@ -1,11 +1,11 @@
select identity_email_id
-from auth.email_validation
+from secd.email_validation
where email_validation_public_id = $1::uuid
--
select
identity_public_id
, data
, i.created_at
-from auth.identity i
-left join auth.identity_email ie using (identity_id)
+from secd.identity i
+left join secd.identity_email ie using (identity_id)
where ie.identity_email_id = $1;