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.sql11
1 files changed, 0 insertions, 11 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
deleted file mode 100644
index e5a0970..0000000
--- a/crates/secd/store/pg/sql/find_identity_by_code.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-select identity_email_validation_id
-from secd.email_validation
-where email_validation_public_id = $1::uuid
---
-select
- identity_public_id
- , data
- , i.created_at
-from secd.identity i
-left join secd.identity_email ie using (identity_id)
-where ie.identity_email_validation_id = $1;