DROP TABLE IF EXISTS `test`.`user`; CREATE TABLE `test`.`user` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL, `password` varchar(64) NOT NULL, `first_name` varchar(128) NOT NULL, `last_name` varchar(128) NOT NULL, `date_created` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;