CREATE TABLE IF NOT EXISTS `users` ( `id` int(10) NOT NULL AUTO_INCREMENT, `user_email` varchar(255) NOT NULL, `user_password` varchar(128) NOT NULL, `user_salt` varchar(128) NOT NULL, `user_displayname` varchar(80) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_email` (`user_email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;