Initial commit

2 files changed, 19 insertions, 0 deletions

diff --git a/migrations/20220719122322_peer.sql b/migrations/20220719122322_peer.sql
new file mode 100644
index 0000000..c06c574
--- /dev/null
+++ b/migrations/20220719122322_peer.sql
@@ -0,0 +1,11 @@
+-- Add migration script here
+CREATE TABLE peers (
+    id TEXT PRIMARY KEY,
+    addr CIDR NOT NULL,
+    public_key TEXT NOT NULL
+);
+CREATE TABLE networks (
+    id TEXT PRIMARY KEY,
+    subnet CIDR NOT NULL,
+    description TEXT
+)
diff --git a/migrations/20220719152547_users.sql b/migrations/20220719152547_users.sql
new file mode 100644
index 0000000..4407bcc
--- /dev/null
+++ b/migrations/20220719152547_users.sql
@@ -0,0 +1,8 @@
+-- Add migration script here
+CREATE TABLE users (
+    id TEXT PRIMARY KEY, 
+    email TEXT NOT NULL,
+    pref_name TEXT NOT NULL,
+    pw_hash TEXT NOT NULL,
+    last_login TIMESTAMP
+);