CREATE TABLE IF NOT EXISTS `clientinfo` (
  `id` int(10) unsigned NOT NULL,
  `database_id` int(10) unsigned NOT NULL,
  `unique_id` varchar(255) NOT NULL,
  `last_nickname` varchar(255) NOT NULL,
  `last_active` int(11) NOT NULL,
  `best_active` int(11) NOT NULL,
  `info` text NOT NULL,
  `is_online` tinyint(4) NOT NULL DEFAULT '0',
  `best_connections` int(11) NOT NULL DEFAULT '0',
  `country` varchar(4) NOT NULL,
  `client_base64HashClientUID` text NOT NULL,
  `client_channel` text NOT NULL,
  `timespent` int(255) NOT NULL,
  `lastgameschange` int(255) NOT NULL,
  PRIMARY KEY (`database_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;