From 3a4de13528fc85dcbe6bc9055d97ba5cc87f5712 Mon Sep 17 00:00:00 2001 From: benj Date: Thu, 8 Dec 2022 11:16:32 -0800 Subject: update schema to `secd` add dummy `dev` command to cli --- crates/secd/store/sqlite/sql/find_identity_by_code.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'crates/secd/store/sqlite') diff --git a/crates/secd/store/sqlite/sql/find_identity_by_code.sql b/crates/secd/store/sqlite/sql/find_identity_by_code.sql index e1a6050..77844ff 100644 --- a/crates/secd/store/sqlite/sql/find_identity_by_code.sql +++ b/crates/secd/store/sqlite/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; -- 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; -- cgit v1.2.3