diff options
| author | benj <benj@rse8.com> | 2022-12-08 11:16:32 -0800 |
|---|---|---|
| committer | benj <benj@rse8.com> | 2022-12-08 11:16:32 -0800 |
| commit | 3a4de13528fc85dcbe6bc9055d97ba5cc87f5712 (patch) | |
| tree | ea07f93e4de9d178f9dd786a0d772ee8b21cb0c3 /crates/secd/store/pg/sql/write_email.sql | |
| parent | 2c4eb2d311919ad9fb70738199ecf99bf20c9fce (diff) | |
| download | secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.gz secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.bz2 secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.lz secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.xz secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.tar.zst secdiam-3a4de13528fc85dcbe6bc9055d97ba5cc87f5712.zip | |
update schema to `secd`
add dummy `dev` command to cli
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); -- |
