//
// 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');
               (
geocities.com/tokyo/courtyard/2734)                   (
geocities.com/tokyo/courtyard)                   (
geocities.com/tokyo)