ALTER TABLE `h_identify_mem`
ADD COLUMN `identify_pi` varchar(255) NOT NULL DEFAULT '' COMMENT '验证平台的用户唯一标识' AFTER `identify_from`;

DROP TABLE IF EXISTS `h_identify_game`;
CREATE TABLE `h_identify_game` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `app_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '对应与game表中id',
  `app_key` varchar(64) NOT NULL DEFAULT '' COMMENT 'appid',
  `app_secret` varchar(128) NOT NULL DEFAULT '' COMMENT 'secret',
  `biz_id` varchar(64) NOT NULL DEFAULT '' COMMENT '游戏备案识别码',
  `ext_info` text NOT NULL COMMENT '扩展信息',
  `create_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `ig_app_index` (`app_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='游戏实名认证配置表';

ALTER TABLE `h_identify_game`
  ADD COLUMN `driver_key` varchar(16) NOT NULL DEFAULT '' COMMENT '驱动key' AFTER `app_id`;