From aadc1975d459f0e2e2807dbb3e2a36098476128b Mon Sep 17 00:00:00 2001 From: Cara Salter Date: Tue, 19 Jul 2022 12:49:28 -0400 Subject: Initial commit --- migrations/20220719122322_peer.sql | 11 +++++++++++ migrations/20220719152547_users.sql | 8 ++++++++ 2 files changed, 19 insertions(+) create mode 100644 migrations/20220719122322_peer.sql create mode 100644 migrations/20220719152547_users.sql (limited to 'migrations') 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 +); -- cgit v1.2.3