server/sql/update.sql

-- 2024-10-24
INSERT INTO `cf_enrol_param`(`PARAM_TYPE`, `PARAM_NAME`, `PARAM_VALUE`, `PARAM_NOTE`) VALUES ('Enrol', 'TencentLiveInfoType', '0', '活体识别获取结果类型');
INSERT INTO `cf_enrol_param`(`PARAM_TYPE`, `PARAM_NAME`, `PARAM_VALUE`, `PARAM_NOTE`) VALUES ('Enrol', 'TencentLiveRedirectUrl', 'https://10047.qmth.com.cn/bk/wechat/wechat.jsp', '跳转地址');
INSERT INTO `cf_enrol_param`(`PARAM_TYPE`, `PARAM_NAME`, `PARAM_VALUE`, `PARAM_NOTE`) VALUES ('Enrol', 'TencentLiveRuleId', '1', '活体识别业务唯一标识');
INSERT INTO `cf_enrol_param`(`PARAM_TYPE`, `PARAM_NAME`, `PARAM_VALUE`, `PARAM_NOTE`) VALUES ('Enrol', 'TencentLiveSecretId', 'AKIDEJCwMdidMr8C7pYFpDTbcgYSSXP8fyAB', '活体识别ID');
INSERT INTO `cf_enrol_param`(`PARAM_TYPE`, `PARAM_NAME`, `PARAM_VALUE`, `PARAM_NOTE`) VALUES ('Enrol', 'TencentLiveSecretKey', 'ymTyLWcXEhzBD6rfbSDoIZhjkgeV9f4J', '活体识别秘钥');


CREATE TABLE `tx_liveness_detail`
(
    `id`               int(0)                                                  NOT NULL AUTO_INCREMENT COMMENT '主键',
    `biz_token`        varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'token',
    `req_time`         bigint(0)                                               NULL DEFAULT NULL COMMENT '请求时间',
    `seq`              varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求的唯一标记',
    `id_card`          varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci  NULL DEFAULT NULL COMMENT '身份证号',
    `name`             varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci  NULL DEFAULT NULL COMMENT '姓名',
    `sim`              varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci  NULL DEFAULT NULL COMMENT '相似度',
    `need_charge`      bit(1)                                                  NULL DEFAULT NULL COMMENT '是否需要收费0：不收费，1：收费',
    `error_code`       int(0)                                                  NULL DEFAULT NULL COMMENT '本次活体一比一最终结果',
    `error_msg`        varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '本次活体一比一最终结果描述',
    `live_status`      int(0)                                                  NULL DEFAULT NULL COMMENT '本次活体结果',
    `live_msg`         varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '本次活体结果描述',
    `compare_status`   int(0)                                                  NULL DEFAULT NULL COMMENT '本次一比一结果',
    `compare_msg`      varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci  NULL DEFAULT NULL COMMENT '本次一比一结果描述',
    `compare_lib_type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci  NULL DEFAULT NULL COMMENT '比对库源类型',
    `liveness_mode`    int(0)                                                  NULL DEFAULT NULL COMMENT '活体检测类型',
    PRIMARY KEY (`id`) USING BTREE
) COMMENT = '活体识别对账流水记录表';

CREATE TABLE `tx_std_live_log`
(
    `id`          int(0)                                                  NOT NULL AUTO_INCREMENT COMMENT '主键',
    `std_id`      int(0)                                                  NULL DEFAULT NULL COMMENT '考生ID',
    `biz_token`   varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '腾讯活体识别token',
    `create_time` datetime(0)                                             NULL DEFAULT NULL COMMENT '创建时间',
    `pull_flag`   varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci   NULL DEFAULT NULL COMMENT '是否拉取标志：0:未拉取，1：已成功拉取',
    PRIMARY KEY (`id`) USING BTREE
) COMMENT = '考生请求token记录表';

CREATE TABLE `tx_std_material_log`
(
    `id`          int(0)                                          NOT NULL AUTO_INCREMENT,
    `std_id`      int(0)                                          NULL DEFAULT NULL COMMENT '考生ID',
    `std_photo`   text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '考生base64图片',
    `create_time` datetime(0)                                     NULL DEFAULT NULL COMMENT '创建时间',
    PRIMARY KEY (`id`) USING BTREE
) COMMENT = '考生失败材料记录表';


-- 2024-10-25
update cf_enrol_param set param_value='InActive' where param_name='EnrolVerifyNoCrownWithPayed';