summaryrefslogtreecommitdiff
path: root/sql/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql/schema.sql')
-rw-r--r--sql/schema.sql4
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
);