drop table if exists login;
drop table if exists user;

create table user(
	id integer primary key autoincrement not null,
	username varchar(32) unique not null,
	password varchar(32) not null
);

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
);