remember logins and table for login form

1 files changed, 10 insertions, 3 deletions

diff --git a/sql/sqlite3.sql b/sql/sqlite3.sql
index 9aaa818..beefe6e 100644
--- a/sql/sqlite3.sql
+++ b/sql/sqlite3.sql
@@ -1,9 +1,16 @@
-drop table if exists users;
+drop table if exists login;
+drop table if exists user;
 
-create table users(
+create table user(
 	id integer primary key autoincrement not null,
 	username varchar(32) unique not null,
 	password varchar(32) not null
 );
 
-insert into users(username, password) values('admin','admin');
+insert into user(username, password) values('admin','admin');
+
+create table login(
+	id integer primary key autoincrement not null,
+	user_id integer references user(id),
+	last_login TIMESTAMP
+);