CREATE TABLE `users` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_email` varchar(320) DEFAULT NULL, `user_password` varchar(255) DEFAULT NULL, `user_created` int(11) DEFAULT NULL, `user_deleted` bit(1) DEFAULT NULL, `group_id` int(11) DEFAULT '0', PRIMARY KEY (`user_id`), UNIQUE KEY `user_email_UNIQUE` (`user_email`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;