aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/sqlite/sql/find_identity_by_code.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/secd/store/sqlite/sql/find_identity_by_code.sql')
-rw-r--r--crates/secd/store/sqlite/sql/find_identity_by_code.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/crates/secd/store/sqlite/sql/find_identity_by_code.sql b/crates/secd/store/sqlite/sql/find_identity_by_code.sql
deleted file mode 100644
index b70a13a..0000000
--- a/crates/secd/store/sqlite/sql/find_identity_by_code.sql
+++ /dev/null
@@ -1,11 +0,0 @@
-select identity_email_validation_id
-from email_validation
-where email_validation_public_id = $1::uuid
---
-select
- identity_public_id
- , data
- , i.created_at
-from identity i
-left join identity_email ie using (identity_id)
-where ie.identity_email_validation_id = ?1;