CREATE TABLE `games` (
  `gameidlogin` varchar(32) NOT NULL,
  `displayed_name` varchar(64) NOT NULL,
  `password` varchar(32) NOT NULL,
  `email` varchar(128) NOT NULL,
  `hidden` varchar(128) NOT NULL,
  PRIMARY KEY  (`gameidlogin`)
) TYPE=MyISAM;

CREATE TABLE `serverlist` (
  `servername` varchar(64) NOT NULL,
  `address` varchar(16) NOT NULL,
  `port` int(5) NOT NULL,
  `game` varchar(32) NOT NULL,
  `info` varchar(255) NOT NULL,
  `time`   numeric(20,0) NOT NULL,
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`address`,`port`)
) TYPE=MyISAM;


