DROP TABLE IF EXISTS `users` ;
CREATE TABLE `users` (
    `id` int AUTO_INCREMENT PRIMARY KEY,
    `username` varchar(12) UNIQUE,
    `salt` char(4),
    `password` char(32),
    `firstname` varchar(12),
    `lastname` varchar(25),
    `email` varchar(45),
    `created` timestamp DEFAULT CURRENT_TIMESTAMP
) ;
 

INSERT `users` ( `username`  , `firstname`, `lastname`, `email` )
    values ( "burt", "Burton", "Rosenber", "burt@cs.miami.edu") ;