diff options
| author | stilbruch <stilbruch@protonail.com> | 2022-03-21 18:09:50 -0500 |
|---|---|---|
| committer | stilbruch <stilbruch@protonail.com> | 2022-03-21 18:10:43 -0500 |
| commit | 681349db67bb828ab926b53734b44c50249d5f65 (patch) | |
| tree | ba164fba3f86eca2576850b4aa3a882e9f2d2c7b /sql | |
| parent | e035041e1a02332694bfa692f62217e58d9fada6 (diff) | |
| download | Strengthy-681349db67bb828ab926b53734b44c50249d5f65.tar.xz Strengthy-681349db67bb828ab926b53734b44c50249d5f65.zip | |
Setup basic database connections
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/init_db.sh | 3 | ||||
| -rw-r--r-- | sql/schema.sql | 6 |
2 files changed, 9 insertions, 0 deletions
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 +); |