diff options
Diffstat (limited to 'sql/sqlite3.sql')
-rw-r--r-- | sql/sqlite3.sql | 13 |
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 +); |