CREATE TABLE `gcm` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rid` blob,
  `ip` varchar(50) DEFAULT NULL,
  `cntry` varchar(255) DEFAULT NULL,
  `tz` int(255) DEFAULT NULL,
  `reg_tim` datetime DEFAULT NULL,
  `loc` varchar(20) DEFAULT NULL,
  `dev_id` varchar(50) DEFAULT NULL,
  `game` varchar(255) DEFAULT NULL,
  `additional` varchar(255) DEFAULT NULL,
  `updated_cnt` int(11) unsigned zerofill NOT NULL DEFAULT '00000000000',
  `ads_ver` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `i5` (`dev_id`,`game`) USING BTREE,
  KEY `i1` (`tz`) USING BTREE,
  KEY `i2` (`cntry`) USING BTREE,
  KEY `i3` (`loc`) USING BTREE,
  KEY `i4` (`game`) USING BTREE,
  KEY `i6` (`ads_ver`) USING BTREE,
  KEY `i7` (`dev_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1685856 DEFAULT CHARSET=utf8;