From aa8c20d501b58001a5e1b24964c62363e2112ff8 Mon Sep 17 00:00:00 2001 From: benj Date: Fri, 25 Nov 2022 16:42:16 -0800 Subject: some shell is coming together and a rough API --- .../sqlite/migrations/20221125051738_bootstrap.sql | 32 ++++++++++++++++++++++ 1 file changed, 32 insertions(+) create mode 100644 store/sqlite/migrations/20221125051738_bootstrap.sql (limited to 'store/sqlite/migrations/20221125051738_bootstrap.sql') diff --git a/store/sqlite/migrations/20221125051738_bootstrap.sql b/store/sqlite/migrations/20221125051738_bootstrap.sql new file mode 100644 index 0000000..70a8892 --- /dev/null +++ b/store/sqlite/migrations/20221125051738_bootstrap.sql @@ -0,0 +1,32 @@ +create table if not exists identity ( + identity_id integer primary key autoincrement + , identity_public_id uuid + , data text default '{}' + , created_at timestamp not null default current_timestamp + , unique(identity_public_id) +); + +create table if not exists email ( + email_id integer primary key autoincrement + , address text not null + , unique(address) +); + +create table if not exists identity_email ( + identity_email_id integer primary key autoincrement + , identity_id integer not null references identity(identity_id) + , email_id integer not null references email(email_id) + , created_at timestamp not null default current_timestamp + , deleted_at timestamp not null default current_timestamp +); + +create table if not exists email_validation_request ( + email_validation_request_id integer primary key autoincrement + -- uuid + , email_validation_request_public_id text not null + , identity_email_id integer not null references identity_email(identity_email_id) + , is_validated boolean not null default false + , created_at timestamp not null default current_timestamp + , expires_at timestamp + , revoked_at timestamp +); -- cgit v1.2.3