From 2c4eb2d311919ad9fb70738199ecf99bf20c9fce Mon Sep 17 00:00:00 2001
From: benj <benj@rse8.com>
Date: Thu, 1 Dec 2022 10:30:34 -0800
Subject: - basic functionality with psql and sqlite - cli helper tool

---
 .../sqlite/migrations/20221125051738_bootstrap.sql | 32 ----------------------
 1 file changed, 32 deletions(-)
 delete 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
deleted file mode 100644
index 70a8892..0000000
--- a/store/sqlite/migrations/20221125051738_bootstrap.sql
+++ /dev/null
@@ -1,32 +0,0 @@
-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

