From 2eafce5b76024b322dbe340ef7963f0b3332a480 Mon Sep 17 00:00:00 2001
From: FivePixels <o5pxels@gmail.com>
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

