diff options
Diffstat (limited to 'crates/secd/store/pg/sql/write_email.sql')
| -rw-r--r-- | crates/secd/store/pg/sql/write_email.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/crates/secd/store/pg/sql/write_email.sql b/crates/secd/store/pg/sql/write_email.sql index 75fc494..cdcc971 100644 --- a/crates/secd/store/pg/sql/write_email.sql +++ b/crates/secd/store/pg/sql/write_email.sql @@ -1,11 +1,11 @@ -insert into auth.email ( +insert into secd.email ( address ) values ( $1 ) on conflict (address) do nothing returning email_id; -- -select email_id from auth.email where address = $1; +select email_id from secd.email where address = $1; -- -insert into auth.identity_email (identity_id, email_id, created_at) values ($1, $2, $3); +insert into secd.identity_email (identity_id, email_id, created_at) values ($1, $2, $3); -- |