K2KUgYcT

1CREATE TABLE IF NOT EXISTS `clientinfo` (
2  `id` int(10) unsigned NOT NULL,
3  `database_id` int(10) unsigned NOT NULL,
4  `unique_id` varchar(255) NOT NULL,
5  `last_nickname` varchar(255) NOT NULL,
6  `last_active` int(11) NOT NULL,
7  `best_active` int(11) NOT NULL,
8  `info` text NOT NULL,
9  `is_online` tinyint(4) NOT NULL DEFAULT '0',
10  `best_connections` int(11) NOT NULL DEFAULT '0',
11  `country` varchar(4) NOT NULL,
12  `client_base64HashClientUID` text NOT NULL,
13  `client_channel` text NOT NULL,
14  `timespent` int(255) NOT NULL,
15  `lastgameschange` int(255) NOT NULL,
16  PRIMARY KEY (`database_id`)
17) ENGINE=InnoDB DEFAULT CHARSET=latin1;