diff options
| author | FivePixels <o5pxels@gmail.com> | 2022-11-21 10:23:20 -0600 |
|---|---|---|
| committer | FivePixels <o5pxels@gmail.com> | 2022-11-21 10:23:20 -0600 |
| commit | 2eafce5b76024b322dbe340ef7963f0b3332a480 (patch) | |
| tree | bc508fd639db41fa40c3c634baffb20199b243a6 /sql | |
| parent | ddcb213051bf3f7ff58b972bf4a6fab49526ccd2 (diff) | |
| download | Strengthy-2eafce5b76024b322dbe340ef7963f0b3332a480.tar.xz Strengthy-2eafce5b76024b322dbe340ef7963f0b3332a480.zip | |
fix misspelling in db name, add columns to schema
Diffstat (limited to 'sql')
| -rwxr-xr-x | sql/init_db.sh | 2 | ||||
| -rw-r--r-- | sql/schema.sql | 4 |
2 files changed, 4 insertions, 2 deletions
diff --git a/sql/init_db.sh b/sql/init_db.sh index b48ab13..09c5031 100755 --- a/sql/init_db.sh +++ b/sql/init_db.sh @@ -1,3 +1,3 @@ #!/bin/sh -sqlite3 strenghty.db < sql/schema.sql +sqlite3 strengthy.db < sql/schema.sql diff --git a/sql/schema.sql b/sql/schema.sql index e14d778..44a7e2a 100644 --- a/sql/schema.sql +++ b/sql/schema.sql @@ -1,6 +1,8 @@ -- User table -CREATE TABLE user( +CREATE TABLE users( id INTEGER PRIMARY KEY AUTOINCREMENT, + username TEXT NOT NULL, + password TEXT NOT NULL, email TEXT NOT NULL, hash TEXT NOT NULL ); |