CREATE TABLE `h_identify_in_queue` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
    `app_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '游戏ID',
    `uid` varchar(64) NOT NULL DEFAULT '' COMMENT '渠道唯一用户id',
    `channel_code` int(11) NOT NULL DEFAULT '0' COMMENT '渠道编码',
    `real_name` varchar(128) NOT NULL DEFAULT '' COMMENT '真实姓名',
    `id_card` varchar(32) NOT NULL DEFAULT '' COMMENT '身份证号',
    `identify_pi` varchar(255) NOT NULL DEFAULT '' 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,
    UNIQUE KEY `iiq_uid_channel_card_unique` (`uid`,`channel_code`,`id_card`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='实名认证队列中信息';

ALTER TABLE `h_identify_game`
    ADD COLUMN `pre_check` tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '实名认证前置校验 1 正则校验 2阿里/腾讯云' AFTER `ext_info`;