CREATE TABLE `author` (
 `authorID` int(11) NOT NULL AUTO_INCREMENT,
 `firstname` varchar(30) NOT NULL,
 `lastname` varchar(30) NOT NULL,
 `username` varchar(30) NOT NULL,
 `password` varchar(30) NOT NULL,
 `email` varchar(40) NOT NULL,
 PRIMARY KEY (`authorID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8