CREATE TABLE users (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT,
	username varchar(32) NOT NULL UNIQUE,
	salt varchar(64) NOT NULL,
	passwordhash varchar(64) NOT NULL,
	PRIMARY KEY (id)
);

CREATE TABLE history (
	id INT UNSIGNED NOT NULL AUTO_INCREMENT,
	user_id INT UNSIGNED NOT NULL,
	query varchar(2048) NOT NULL,
	PRIMARY KEY (id),
	INDEX (user_id)
);