crates/secd/store/sqlite/sql/write_email.sql


1
2
3
4
5
6
7
8
9
10
11

insert into email (
       address
) values (
       ?1
) on conflict (address) do nothing
returning email_id;
--
select email_id from email where email = ?1;
--
insert into identity_email (identity_id, email_id, created_at) values (?1, ?2, ?3);
--