CREATE TABLE `testdata` (

  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,

  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

  `titleid` int(10) unsigned DEFAULT NULL,

  `version` tinyint(3) unsigned DEFAULT NULL,

  `verrprt` tinyint(3) unsigned DEFAULT NULL,

  `dlcmask` bigint(20) unsigned DEFAULT NULL,

  `xuid` bigint(20) unsigned DEFAULT NULL,

  `gamertag` varchar(16) DEFAULT NULL,

  `xrgn` smallint(5) unsigned DEFAULT NULL,

  `xlng` tinyint(3) unsigned DEFAULT NULL,

  `xloc` tinyint(3) unsigned DEFAULT NULL,

  `scrw` smallint(5) unsigned DEFAULT NULL,

  `scrh` smallint(5) unsigned DEFAULT NULL,

  `vidi` tinyint(3) unsigned DEFAULT NULL,

  `vidw` tinyint(3) unsigned DEFAULT NULL,

  `vidh` tinyint(3) unsigned DEFAULT NULL,

  `vids` tinyint(3) unsigned DEFAULT NULL,

  `scrr` float DEFAULT NULL,

  `snd` tinyint(3) unsigned DEFAULT NULL,

  `joy` tinyint(3) unsigned DEFAULT NULL,

  `urgn` tinyint(3) unsigned DEFAULT NULL,

  `uach` int(10) unsigned DEFAULT NULL,

  `uzon` tinyint(3) unsigned DEFAULT NULL,

  `ucrd` int(10) unsigned DEFAULT NULL,

  `utit` int(10) unsigned DEFAULT NULL,

  `udif` tinyint(3) unsigned DEFAULT NULL,

  `usns` tinyint(3) unsigned DEFAULT NULL,

  `uyax` tinyint(3) unsigned DEFAULT NULL,

  `utia` tinyint(3) unsigned DEFAULT NULL,

  `utic` int(10) unsigned DEFAULT NULL,

  `dcpgmi` int(10) unsigned DEFAULT NULL,

  `dcpgme` int(10) unsigned DEFAULT NULL,

  `dcpgbu` int(10) unsigned DEFAULT NULL,

  `dcbwup` int(10) unsigned DEFAULT NULL,

  `dcbwdn` int(10) unsigned DEFAULT NULL,

  `dcid` tinyint(3) unsigned DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1

