From 2eafce5b76024b322dbe340ef7963f0b3332a480 Mon Sep 17 00:00:00 2001 From: FivePixels Date: Mon, 21 Nov 2022 10:23:20 -0600 Subject: fix misspelling in db name, add columns to schema --- sql/schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to '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 ); -- cgit v1.2.3