1. Create table for testing (pn database "test")
CREATE TABLE `users` (
`userID` int(8) NOT NULL auto_increment,
`username` varchar(32) NOT NULL,
`password` varchar(32) default NULL,
PRIMARY KEY (`userID`)
)
insert into `users` ( `userID`, `username`, `password` ) values ( NULL, 'admin', NULL )
insert into `users` ( `userID`, `username`, `password` ) values ( NULL, 'user1', NULL )
insert into `users` ( `userID`, `username`, `password` ) values ( NULL, 'george', NULL )
insert into `users` ( `userID`, `username`, `password` ) values ( NULL, 'paul', NULL )
