diff options
Diffstat (limited to 'crates/secd/store/pg/sql/find_email_validation.sql')
| -rw-r--r-- | crates/secd/store/pg/sql/find_email_validation.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/crates/secd/store/pg/sql/find_email_validation.sql b/crates/secd/store/pg/sql/find_email_validation.sql index d16d8e7..96a8cc4 100644 --- a/crates/secd/store/pg/sql/find_email_validation.sql +++ b/crates/secd/store/pg/sql/find_email_validation.sql @@ -8,10 +8,10 @@ select , ev.created_at , ev.expires_at , ev.revoked_at -from auth.email_validation ev -join auth.identity_email ie using (identity_email_id) -join auth.email e using (email_id) -join auth.identity i using (identity_id) +from secd.email_validation ev +join secd.identity_email ie using (identity_email_id) +join secd.email e using (email_id) +join secd.identity i using (identity_id) where (($1 is null) or (email_validation_public_id = $1)) and (($2 is null) or (code = $2)); -- |