//
// Create the user list table
//
create table user (
	user varchar(10) not null,
    	pass char(16) not null,
    	email varchar(30) not null,
    	primary key(user)
	);

// 
// Create a table for a user's data
//
create table pws (
	date varchar(10) not null,
	remind enum('Y','N') not null default 'N',
	note varchar(200) not null,
	primary key(date)
	);

//
// Add a user to the user table
//
insert into user (user,pass,email) values('test',password('test'),'test@test.com');

//
// Check and see if the user and password are legit
//
select user from user where user = 'pws' and pass = password('blah');