1. CREATE TABLE IF NOT EXISTS `users` (
  2.   `id` INT(10) NOT NULL AUTO_INCREMENT,
  3.   `user_email` VARCHAR(255) NOT NULL,
  4.   `user_password` VARCHAR(128) NOT NULL,
  5.   `user_salt` VARCHAR(128) NOT NULL,
  6.   `user_displayname` VARCHAR(80) NOT NULL,
  7.   PRIMARY KEY (`id`),
  8.   UNIQUE KEY `user_email` (`user_email`)
  9. ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;