Add user auth and flashes

1 files changed, 16 insertions, 0 deletions

diff --git a/sql/sqlite3/03_users.sql b/sql/sqlite3/03_users.sql
new file mode 100644
index 0000000..b332c9c
--- /dev/null
+++ b/sql/sqlite3/03_users.sql
@@ -0,0 +1,16 @@
+create table users (
+	id integer primary key autoincrement,
+	email varchar not null,
+	first_name varchar not null,
+	last_name varchar not null,
+	enabled integer not null default 0,
+	pw_hash varchar not null,
+	pw_salt varchar not null,
+	last_login_at timestamp null,
+	created_at timestamp not null,
+	updated_at timestamp not null
+);
+create index "users#email" on users(email);
+
+insert into users (email, first_name, last_name, enabled, pw_hash, pw_salt, created_at, updated_at)
+values ('admin@example.com', 'Admin', 'User', 1, 'f1b4e14683c2ad53b3c798baeea6b17b7cf77b291825353cff3f24a255d98fe9', 'UvQgb6w0RjCOaM9L', date('now'), date('now'));