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/schema.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/schema.sql')
| -rw-r--r-- | sql/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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 ); |