From aa8c20d501b58001a5e1b24964c62363e2112ff8 Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
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

