CREATE TABLE IF NOT EXISTS `users` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8_bin NOT NULL,
  `email` varchar(50) COLLATE utf8_bin NOT NULL,
  `passhash` varchar(50) COLLATE utf8_bin NOT NULL,
  `invitecode` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '''nocode''',
  `registration_ts` int(20) NOT NULL,
  `last_activity` int(20) NOT NULL,
  `class` int(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;