diff options
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 ); |