aboutsummaryrefslogtreecommitdiff
path: root/crates/secd/store/pg/sql/write_email.sql
diff options
context:
space:
mode:
authorbenj <benj@rse8.com>2022-12-08 11:16:32 -0800
committerbenj <benj@rse8.com>2022-12-08 11:16:32 -0800
commit3a4de13528fc85dcbe6bc9055d97ba5cc87f5712 (patch)
treeea07f93e4de9d178f9dd786a0d772ee8b21cb0c3 /crates/secd/store/pg/sql/write_email.sql
parent2c4eb2d311919ad9fb70738199ecf99bf20c9fce (diff)
downloadsecdiam-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.sql6
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);
--