| 12345678910111213141516 |
- 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`;
|
