CREATE TABLE `users` (
  `id` int(6) NOT NULL auto_increment,
  `username` varchar(63) collate latin1_general_ci NOT NULL,
  `password` varchar(31) collate latin1_general_ci NOT NULL,
  `email` varchar(127) collate latin1_general_ci NOT NULL,
  `datejoined` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
);