From 681349db67bb828ab926b53734b44c50249d5f65 Mon Sep 17 00:00:00 2001
From: stilbruch <stilbruch@protonail.com>
Date: Mon, 21 Mar 2022 18:09:50 -0500
Subject: Setup basic database connections

---
 sql/init_db.sh | 3 +++
 sql/schema.sql | 6 ++++++
 2 files changed, 9 insertions(+)
 create mode 100755 sql/init_db.sh
 create mode 100644 sql/schema.sql

(limited to 'sql')

diff --git a/sql/init_db.sh b/sql/init_db.sh
new file mode 100755
index 0000000..b48ab13
--- /dev/null
+++ b/sql/init_db.sh
@@ -0,0 +1,3 @@
+#!/bin/sh
+
+sqlite3 strenghty.db < sql/schema.sql
diff --git a/sql/schema.sql b/sql/schema.sql
new file mode 100644
index 0000000..e14d778
--- /dev/null
+++ b/sql/schema.sql
@@ -0,0 +1,6 @@
+-- User table
+CREATE TABLE user(
+	id INTEGER PRIMARY KEY AUTOINCREMENT,
+	email TEXT NOT NULL,
+	hash TEXT NOT NULL
+);
-- 
cgit v1.2.3