sql

2024-06-03 # alter table device add anonymous_storage tinyint(1) DEFAULT '0' COMMENT '是否开启纯采集匿名入库 false-关闭 true-开启默认false'; alter table device add compare_silent_display tinyint(1) DEFAULT '0' COMMENT '比对失败是否静默显示 false-关闭 true-开启默认false'; alter table device add compare_silent_display_time int DEFAULT '2' COMMENT '比对失败静默时长默认2'; alter table device add compare_top_title varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '比对失败顶部文字'; alter table device_template add anonymous_storage tinyint(1) DEFAULT '0' COMMENT '是否开启纯采集匿名入库 false-关闭 true-开启默认false'; alter table device_template add compare_silent_display tinyint(1) DEFAULT '0' COMMENT '比对失败是否静默显示 false-关闭 true-开启默认false'; alter table device_template add compare_silent_display_time int DEFAULT '2' COMMENT '比对失败静默时长默认2'; alter table device_template add compare_top_title varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '比对失败顶部文字'; alter table fkj_device add face_fail_hand_input tinyint(1) DEFAULT '0' COMMENT '刷脸失败跳转手输 false-关闭 true-开启默认false'; alter table fkj_device_template add face_fail_hand_input tinyint(1) DEFAULT '0' COMMENT '刷脸失败跳转手输 false-关闭 true-开启默认false'; alter table provisional_identity_proof_device add face_fail_hand_input tinyint(1) DEFAULT '0' COMMENT '刷脸失败跳转手输 false-关闭 true-开启默认false'; alter table provisional_identity_proof_device add face_fail_hand_input tinyint(1) DEFAULT '0' COMMENT '刷脸失败跳转手输 false-关闭 true-开启默认false'; ALTER TABLE provisional_identity_proof_device add home_page_title varchar(50) COLLATE utf8mb4_general_ci DEFAULT '临时身份证明自助服务系统' COMMENT '首页标题'; ALTER TABLE provisional_identity_proof_device add face_button_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '支付宝用户刷脸快捷办理' COMMENT '刷脸按钮文本'; ALTER TABLE provisional_identity_proof_device add input_button_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '无支付宝旅客/老年人入口' COMMENT '手输按钮文本'; ALTER TABLE provisional_identity_proof_device add result_page_print_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '查看电子版临时身份证明' COMMENT '结果页-打印文本'; ALTER TABLE provisional_identity_proof_device add result_page_no_print_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '电子版临时身份证明' COMMENT '结果页-非打印文本'; ALTER TABLE provisional_identity_proof_template add home_page_title varchar(50) COLLATE utf8mb4_general_ci DEFAULT '临时身份证明自助服务系统' COMMENT '首页标题'; ALTER TABLE provisional_identity_proof_template add face_button_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '支付宝用户刷脸快捷办理' COMMENT '刷脸按钮文本'; ALTER TABLE provisional_identity_proof_template add input_button_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '无支付宝旅客/老年人入口' COMMENT '手输按钮文本'; ALTER TABLE provisional_identity_proof_template add result_page_print_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '查看电子版临时身份证明' COMMENT '结果页-打印文本'; ALTER TABLE provisional_identity_proof_template add result_page_no_print_text varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '电子版临时身份证明' COMMENT '结果页-非打印文本';

2024-06-07 ALTER TABLE fkj_device add reminder_auth tinyint(1) DEFAULT '0' COMMENT '是否启用注意事项提示语 true-启用 false-不启用'; ALTER TABLE fkj_device_template add reminder_auth tinyint(1) DEFAULT '0' COMMENT '是否启用注意事项提示语 true-启用 false-不启用';

2024-07-29 alter table iot_device_config add is_open_printer tinyint(1) DEFAULT '0' COMMENT '是否开启打印机默认false'; alter table iot_device_config add printer_config int DEFAULT NULL COMMENT 'HHArome打印机接口配置PrinterConfigEnum'; alter table iot_device_config_template add is_open_printer tinyint(1) DEFAULT '0' COMMENT '是否开启打印机默认false'; alter table iot_device_config_template add printer_config int DEFAULT NULL COMMENT 'HHArome打印机接口配置PrinterConfigEnum';

-- 2024-07-30 ALTER TABLE hh_culture_device ADD COLUMN isv_pid varchar(64) NULL COMMENT 'isv的商户id'; ALTER TABLE hh_culture_device_template ADD COLUMN isv_pid varchar(64) NULL COMMENT 'isv的商户id';

-- 2024-07-31 CREATE TABLE hanghui_outapi_platform.provisional_identity_proof_special_code ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', create_time datetime NULL DEFAULT NULL COMMENT '创建时间', update_time datetime NULL DEFAULT NULL COMMENT '更新时间', version bigint(20) NULL DEFAULT NULL COMMENT '版本控制 ', is_deleted tinyint(1) NULL DEFAULT NULL COMMENT '是否删除', qr_code_no varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二维码CODE编码根据购买方公司id+用户身份证加密生成', cert_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', cert_no varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件号', phone varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', photo varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '照片', start_date date NULL DEFAULT NULL COMMENT '开始时间格式：2024-07-31', end_date date NULL DEFAULT NULL COMMENT '结束时间格式：2024-07-31', purchaser_id bigint(20) NULL DEFAULT NULL COMMENT '购买方公司', PRIMARY KEY (id) USING BTREE, INDEX idx_qr_code_no(qr_code_no) USING BTREE, INDEX idx_end_date(end_date) USING BTREE, INDEX idx_cert_no(cert_no) USING BTREE, INDEX idx_purchaser_id(purchaser_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '临证用户特殊码表' ROW_FORMAT = DYNAMIC;

ALTER TABLE hanghui_outapi_platform.provisional_identity_proof_device ADD COLUMN special_code_switch tinyint(1) NULL COMMENT '启用三要素获取特殊码接口默认：否', ADD COLUMN special_code_url varchar(500) NULL COMMENT '三要素获取特殊码接口地址' AFTER special_code_switch, ADD COLUMN special_code_encrypt_switch tinyint(1) NULL COMMENT '三要素获取特殊码接口数据是否加解密默认true' AFTER special_code_url, ADD COLUMN special_code_encrypt_app_key varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密appKey' AFTER special_code_encrypt_switch, ADD COLUMN special_code_encrypt_app_secret varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密appSecrete' AFTER special_code_encrypt_app_key, ADD COLUMN special_code_encrypt_private_key varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密PrivateKey' AFTER special_code_encrypt_app_secret, ADD COLUMN special_code_timeout int(10) NULL COMMENT '三要素获取特殊码接口超时时间：5s' AFTER special_code_encrypt_private_key, ADD COLUMN special_code_timeout_tips varchar(64) NULL COMMENT '三要素获取特殊码接口超时提示语默认-三要素获取特殊码接口请求超时' AFTER special_code_timeout, ADD COLUMN special_code_failed_tips varchar(64) NULL COMMENT '三要素获取特殊码接口失败提示语默认-三要素获取特殊码接口请求失败' AFTER special_code_timeout_tips;

ALTER TABLE hanghui_outapi_platform.provisional_identity_proof_template ADD COLUMN special_code_switch tinyint(1) NULL COMMENT '启用三要素获取特殊码接口默认：否', ADD COLUMN special_code_url varchar(500) NULL COMMENT '三要素获取特殊码接口地址' AFTER special_code_switch, ADD COLUMN special_code_encrypt_switch tinyint(1) NULL COMMENT '三要素获取特殊码接口数据是否加解密默认true' AFTER special_code_url, ADD COLUMN special_code_encrypt_app_key varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密appKey' AFTER special_code_encrypt_switch, ADD COLUMN special_code_encrypt_app_secret varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密appSecrete' AFTER special_code_encrypt_app_key, ADD COLUMN special_code_encrypt_private_key varchar(64) NULL COMMENT '三要素获取特殊码接口数据是否加解密PrivateKey' AFTER special_code_encrypt_app_secret, ADD COLUMN special_code_timeout int(10) NULL COMMENT '三要素获取特殊码接口超时时间：5s' AFTER special_code_encrypt_private_key, ADD COLUMN special_code_timeout_tips varchar(64) NULL COMMENT '三要素获取特殊码接口超时提示语默认-三要素获取特殊码接口请求超时' AFTER special_code_timeout, ADD COLUMN special_code_failed_tips varchar(64) NULL COMMENT '三要素获取特殊码接口失败提示语默认-三要素获取特殊码接口请求失败' AFTER special_code_timeout_tips;

ALTER TABLE hanghui_outapi_platform.device ADD COLUMN special_code_switch tinyint(1) NULL COMMENT '启用三要素获取特殊码接口默认：否', ADD COLUMN special_code_url varchar(500) NULL COMMENT '三要素获取特殊码接口地址' AFTER special_code_switch, ADD COLUMN special_code_timeout int(10) NULL COMMENT '三要素获取特殊码接口超时时间：5s' AFTER special_code_url, ADD COLUMN special_code_timeout_tips varchar(64) NULL COMMENT '三要素获取特殊码接口超时提示语默认-三要素获取特殊码接口请求超时' AFTER special_code_timeout, ADD COLUMN special_code_failed_tips varchar(64) NULL COMMENT '三要素获取特殊码接口失败提示语默认-三要素获取特殊码接口请求失败' AFTER special_code_timeout_tips, ADD COLUMN special_code_prefix varchar(255) NULL COMMENT '特殊码标识（首位/前缀）' AFTER special_code_failed_tips;

ALTER TABLE hanghui_outapi_platform.device_template ADD COLUMN special_code_switch tinyint(1) NULL COMMENT '启用三要素获取特殊码接口默认：否', ADD COLUMN special_code_url varchar(500) NULL COMMENT '三要素获取特殊码接口地址' AFTER special_code_switch, ADD COLUMN special_code_timeout int(10) NULL COMMENT '三要素获取特殊码接口超时时间：5s' AFTER special_code_url, ADD COLUMN special_code_timeout_tips varchar(64) NULL COMMENT '三要素获取特殊码接口超时提示语默认-三要素获取特殊码接口请求超时' AFTER special_code_timeout, ADD COLUMN special_code_failed_tips varchar(64) NULL COMMENT '三要素获取特殊码接口失败提示语默认-三要素获取特殊码接口请求失败' AFTER special_code_timeout_tips, ADD COLUMN special_code_prefix varchar(255) NULL COMMENT '特殊码标识（首位/前缀）' AFTER special_code_failed_tips;

ALTER TABLE hh_culture_device ADD result_page_template tinyint(1) DEFAULT '1' COMMENT '结果页模版 1-通用版 2-悬浮版'; ALTER TABLE hh_culture_device_template ADD result_page_template tinyint(1) DEFAULT '1' COMMENT '结果页模版 1-通用版 2-悬浮版'; ALTER TABLE device addled_brightness int DEFAULT '200' COMMENT '补光灯亮度'; ALTER TABLE device_template addled_brightness int DEFAULT '200' COMMENT '补光灯亮度';

ALTER TABLE hanghui_outapi_platform.provisional_identity_proof_special_code ADD COLUMN issuing_time datetime NULL COMMENT '签发时间', ADD COLUMN issuing_authority varchar(100) NULL COMMENT '签发单位' AFTER issuing_time;

ALTER TABLE hanghui_outapi_platform.provisional_identity_proof_device ADD COLUMN valid_time int(5) NULL COMMENT '凭证有效期', ADD COLUMN issuing_authority varchar(100) NULL COMMENT '签发单位' AFTER valid_time;

ALTER TABLE hanghui_outapi_platform.provisional_identity_proof_template ADD COLUMN valid_time int(5) NULL COMMENT '凭证有效期', ADD COLUMN issuing_authority varchar(100) NULL COMMENT '签发单位' AFTER valid_time;

alter table device_template add verify_retry_times int DEFAULT '2' COMMENT 'verify核验接口失败重试次数默认2', add verify_link_timeout int DEFAULT '15' COMMENT 'verify核验接口超时时间：15s', add scheduled_restart tinyint(1) DEFAULT '0' COMMENT '是否开启定时重启 true-是 false-否默认-false', add scheduled_restart_time time DEFAULT NULL COMMENT '定时重启时间HH:mm:ss';

alter table device add verify_retry_times int DEFAULT '2' COMMENT 'verify核验接口失败重试次数默认2', add verify_link_timeout int DEFAULT '15' COMMENT 'verify核验接口超时时间：15s', add scheduled_restart tinyint(1) DEFAULT '0' COMMENT '是否开启定时重启 true-是 false-否默认-false', add scheduled_restart_time time DEFAULT NULL COMMENT '定时重启时间HH:mm:ss';

alter table device add ic14443_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic14443_reader_brand int DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum', add ic14443_reader_sector_numbers int DEFAULT '15' COMMENT 'ic14443-读取扇区-数字；0-99 默认15', add ic14443_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic14443_reader_key varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F', add ic14443_start_offset int DEFAULT '0' COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0', add ic14443_end_offset int DEFAULT '0' COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0', add ic14443_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否人证比对；false-否（默认） true-是', add ic14443_same_card_interval_time int DEFAULT '7' COMMENT 'ic14443-同卡间隔时间；默认7', add ic15693_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic15693_reader_brand int DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum', add ic15693_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic15693_start_offset int DEFAULT '0' COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0', add ic15693_end_offset int DEFAULT '0' COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0', add ic15693_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否人证比对；false-否（默认） true-是', add ic15693_same_card_interval_time int DEFAULT '7' COMMENT 'ic15693-同卡间隔时间；默认7';

alter table device_template add ic14443_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic14443_reader_brand int DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum', add ic14443_reader_sector_numbers int DEFAULT '15' COMMENT 'ic14443-读取扇区-数字；0-99 默认15', add ic14443_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic14443_reader_key varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F', add ic14443_start_offset int DEFAULT '0' COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0', add ic14443_end_offset int DEFAULT '0' COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0', add ic14443_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否人证比对；false-否（默认） true-是', add ic14443_same_card_interval_time int DEFAULT '7' COMMENT 'ic14443-同卡间隔时间；默认7', add ic15693_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic15693_reader_brand int DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum', add ic15693_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic15693_start_offset int DEFAULT '0' COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0', add ic15693_end_offset int DEFAULT '0' COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0', add ic15693_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否人证比对；false-否（默认） true-是', add ic15693_same_card_interval_time int DEFAULT '7' COMMENT 'ic15693-同卡间隔时间；默认7';

alter table hh_culture_device add ic14443_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic14443_reader_brand int DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum', add ic14443_reader_sector_numbers int DEFAULT '15' COMMENT 'ic14443-读取扇区-数字；0-99 默认15', add ic14443_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic14443_reader_key varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F', add ic14443_start_offset int DEFAULT '0' COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0', add ic14443_end_offset int DEFAULT '0' COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0', add ic14443_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否人证比对；false-否（默认） true-是', add ic14443_same_card_interval_time int DEFAULT '7' COMMENT 'ic14443-同卡间隔时间；默认7', add ic15693_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic15693_reader_brand int DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum', add ic15693_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic15693_start_offset int DEFAULT '0' COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0', add ic15693_end_offset int DEFAULT '0' COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0', add ic15693_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否人证比对；false-否（默认） true-是', add ic15693_same_card_interval_time int DEFAULT '7' COMMENT 'ic15693-同卡间隔时间；默认7';

alter table hh_culture_device_template add ic14443_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic14443_reader_brand int DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum', add ic14443_reader_sector_numbers int DEFAULT '15' COMMENT 'ic14443-读取扇区-数字；0-99 默认15', add ic14443_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic14443_reader_key varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F', add ic14443_start_offset int DEFAULT '0' COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0', add ic14443_end_offset int DEFAULT '0' COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0', add ic14443_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic14443-是否人证比对；false-否（默认） true-是', add ic14443_same_card_interval_time int DEFAULT '7' COMMENT 'ic14443-同卡间隔时间；默认7', add ic15693_ic_card_function tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是', add ic15693_reader_brand int DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum', add ic15693_reader_block varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', add ic15693_start_offset int DEFAULT '0' COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0', add ic15693_end_offset int DEFAULT '0' COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0', add ic15693_person_card_comparison tinyint(1) DEFAULT '0' COMMENT 'ic15693-是否人证比对；false-否（默认） true-是', add ic15693_same_card_interval_time int DEFAULT '7' COMMENT 'ic15693-同卡间隔时间；默认7';

alter TABLE device add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE device_template add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE fkj_device add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE fkj_device_template add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE hh_culture_device add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE hh_culture_device_template add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE iot_device_config add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE iot_device_config_template add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE provisional_identity_proof_device add expiration_date date DEFAULT NULL COMMENT '到期日期'; alter TABLE provisional_identity_proof_template add expiration_date date DEFAULT NULL COMMENT '到期日期';

ALTER TABLE account_auth_config add use_config varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '使用配置 UseConfigEnum';

-- 2024-08-30 ALTER TABLE hanghui_outapi_platform.device_template ADD COLUMN user_blacklist_switch tinyint(1) NULL COMMENT '开启黑名单默认：false-否' AFTER expiration_date, ADD COLUMN forbid_pass_switch tinyint(1) NULL COMMENT '是否阻止通行默认：true-是' AFTER user_blacklist_switch, ADD COLUMN forbid_pass_text varchar(50) NULL COMMENT '阻止通行的文本默认：禁止通行' AFTER forbid_pass_switch, ADD COLUMN forbid_pass_voice varchar(50) NULL COMMENT '阻止通信提示语音默认：禁止通行，请联系管理员' AFTER forbid_pass_text, ADD COLUMN user_blacklist_hit_rule varchar(255) NULL COMMENT '命中条件 IDENTITY_CARD-身份证 PHONE-手机号默认：勾选身份证' AFTER forbid_pass_voice, ADD COLUMN user_blacklist_interf_fetch_switch tinyint(1) NULL COMMENT '是否启用接口拉取默认：true' AFTER user_blacklist_hit_rule, ADD COLUMN user_blacklist_interf_url varchar(500) NULL COMMENT '接口拉取地址' AFTER user_blacklist_interf_fetch_switch, ADD COLUMN user_blacklist_encrypt_switch tinyint(1) NULL COMMENT '黑名单数据是否加解密默认true' AFTER user_blacklist_interf_url, ADD COLUMN user_blacklist_encrypt_app_key varchar(100) NULL COMMENT '核验接口数据是否加解密appKey' AFTER user_blacklist_encrypt_switch, ADD COLUMN user_blacklist_encrypt_app_secret varchar(100) NULL COMMENT '核验接口数据是否加解密appSecrete' AFTER user_blacklist_encrypt_app_key, ADD COLUMN user_blacklist_encrypt_private_key varchar(100) NULL COMMENT '核验接口数据是否加解密PrivateKey' AFTER user_blacklist_encrypt_app_secret, ADD COLUMN push_failed_record_type text NULL COMMENT '推送失败记录类型' AFTER user_blacklist_offline_task_id;

ALTER TABLE hanghui_outapi_platform.device ADD COLUMN user_blacklist_switch tinyint(1) NULL COMMENT '开启黑名单默认：false-否' AFTER expiration_date, ADD COLUMN forbid_pass_switch tinyint(1) NULL COMMENT '是否阻止通行默认：true-是' AFTER user_blacklist_switch, ADD COLUMN forbid_pass_text varchar(50) NULL COMMENT '阻止通行的文本默认：禁止通行' AFTER forbid_pass_switch, ADD COLUMN forbid_pass_voice varchar(50) NULL COMMENT '阻止通信提示语音默认：禁止通行，请联系管理员' AFTER forbid_pass_text, ADD COLUMN user_blacklist_hit_rule varchar(255) NULL COMMENT '命中条件 IDENTITY_CARD-身份证 PHONE-手机号默认：勾选身份证' AFTER forbid_pass_voice, ADD COLUMN user_blacklist_interf_fetch_switch tinyint(1) NULL COMMENT '是否启用接口拉取默认：true' AFTER user_blacklist_hit_rule, ADD COLUMN user_blacklist_interf_url varchar(500) NULL COMMENT '接口拉取地址' AFTER user_blacklist_interf_fetch_switch, ADD COLUMN user_blacklist_encrypt_switch tinyint(1) NULL COMMENT '黑名单数据是否加解密默认true' AFTER user_blacklist_interf_url, ADD COLUMN user_blacklist_encrypt_app_key varchar(100) NULL COMMENT '核验接口数据是否加解密appKey' AFTER user_blacklist_encrypt_switch, ADD COLUMN user_blacklist_encrypt_app_secret varchar(100) NULL COMMENT '核验接口数据是否加解密appSecrete' AFTER user_blacklist_encrypt_app_key, ADD COLUMN user_blacklist_encrypt_private_key varchar(100) NULL COMMENT '核验接口数据是否加解密PrivateKey' AFTER user_blacklist_encrypt_app_secret, ADD COLUMN user_blacklist_offline_switch tinyint(1) NULL COMMENT '是否启用本地名单默认false' AFTER user_blacklist_encrypt_private_key, ADD COLUMN user_blacklist_offline_task_id text NULL COMMENT '本地名单任务集合' AFTER user_blacklist_offline_switch, ADD COLUMN push_failed_record_type text NULL COMMENT '推送失败记录类型' AFTER user_blacklist_offline_task_id;

CREATE TABLE hanghui_outapi_platform.user_blacklist_task ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', create_time datetime NULL DEFAULT NULL COMMENT '创建时间', update_time datetime NULL DEFAULT NULL COMMENT '更新时间', version bigint(20) NULL DEFAULT NULL COMMENT '版本控制 ', is_deleted tinyint(1) NULL DEFAULT NULL COMMENT '是否删除', task_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务名称', purchaser_id bigint(20) NULL DEFAULT NULL COMMENT '购买方公司', PRIMARY KEY (id) USING BTREE, INDEX idx_task_name(task_name) USING BTREE, INDEX idx_purchaser_id(purchaser_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '黑名单任务' ROW_FORMAT = DYNAMIC;

CREATE TABLE hanghui_outapi_platform.user_blacklist ( id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id', create_time datetime NULL DEFAULT NULL COMMENT '创建时间', update_time datetime NULL DEFAULT NULL COMMENT '更新时间', version bigint(20) NULL DEFAULT NULL COMMENT '版本控制 ', is_deleted tinyint(1) NULL DEFAULT NULL COMMENT '是否删除', cert_name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', cert_no varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件号', phone varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', task_id bigint(20) NULL DEFAULT NULL COMMENT 'UserBlacklistTask 主键', PRIMARY KEY (id) USING BTREE, INDEX idx_task_id(task_id) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '黑名单' ROW_FORMAT = DYNAMIC;

-- 20240904 ALTER TABLE hanghui_outapi_platform.hh_culture_device ADD COLUMN entry_identify_switch tinyint(1) NULL COMMENT '是否开启进场识别默认false' AFTER expiration_date, ADD COLUMN click_scan_face_button_switch tinyint(1) NULL COMMENT '显示点击刷脸按钮默认true' AFTER entry_identify_switch, ADD COLUMN click_scan_face_button_text varchar(100) NULL COMMENT '点击刷脸按钮文本默认：点击开始刷脸核验' AFTER click_scan_face_button_switch, ADD COLUMN scan_face_failed_tip_url varchar(255) NULL COMMENT '刷脸失败提示页配置图片' AFTER click_scan_face_button_text;

ALTER TABLE hanghui_outapi_platform.hh_culture_device_template ADD COLUMN entry_identify_switch tinyint(1) NULL COMMENT '是否开启进场识别默认false' AFTER expiration_date, ADD COLUMN click_scan_face_button_switch tinyint(1) NULL COMMENT '显示点击刷脸按钮默认true' AFTER entry_identify_switch, ADD COLUMN click_scan_face_button_text varchar(100) NULL COMMENT '点击刷脸按钮文本默认：点击开始刷脸核验' AFTER click_scan_face_button_switch, ADD COLUMN scan_face_failed_tip_url varchar(255) NULL COMMENT '刷脸失败提示页配置图片' AFTER click_scan_face_button_text;

-- 20240911 ALTER TABLE hanghui_outapi_platform.iot_device_config ADD COLUMN volume int NULL DEFAULT 80 COMMENT '语音音量 0-100 默认值80' AFTER expiration_date, ADD COLUMN applet_enter_page_url varchar(255) NULL COMMENT '小程序入口页面地址' AFTER volume; ALTER TABLE hanghui_outapi_platform.iot_device_config_template ADD COLUMN volume int NULL DEFAULT 80 COMMENT '语音音量 0-100 默认值80' AFTER expiration_date, ADD COLUMN applet_enter_page_url varchar(255) NULL COMMENT '小程序入口页面地址' AFTER volume;

ALTER TABLE hanghui_outapi_platform.account_auth_config MODIFY COLUMN use_config text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '使用配置 UseConfigEnum' AFTER version, ADD COLUMN push_config text NULL COMMENT '推送地址配置' AFTER use_config, ADD COLUMN hh_face_switch tinyint(1) NULL COMMENT 'hhface权限开关' AFTER push_config, ADD COLUMN hhface_use_config text NULL COMMENT 'hhface使用配置' AFTER hh_face_switch, ADD COLUMN hhface_face_config text NULL COMMENT 'hhface支付宝刷脸启动核点配置' AFTER hhface_use_config, ADD COLUMN hhface_face_config_tenant_ids text NULL COMMENT '商户平台id集合' AFTER hhface_face_config, ADD COLUMN hhface_face_config_user_lib_ids text NULL COMMENT '用户库id集合' AFTER hhface_face_config_tenant_ids, ADD COLUMN hhface_collect_config text NULL COMMENT 'hhface采集配置' AFTER hhface_face_config_user_lib_ids, ADD COLUMN hhface_third_config text NULL COMMENT 'hhface三方接口接入配置' AFTER hhface_collect_config, ADD COLUMN hhface_result_config text NULL COMMENT 'hhface结果页配置' AFTER hhface_third_config, ADD COLUMN hhface_hardware_config text NULL COMMENT 'hhface硬件模组配置' AFTER hhface_result_config, ADD COLUMN hhface_push_config text NULL COMMENT 'hhface推送配置' AFTER hhface_hardware_config, ADD COLUMN hhface_func_config text NULL COMMENT 'hhface功能配置' AFTER hhface_push_config, ADD COLUMN hhface_system_config text NULL COMMENT 'hhface系统配置' AFTER hhface_func_config;

-- 20240924 CREATE TABLE hanghui_outapi_platform.hh_local_device (

`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键id',
`sn` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备编号',
`first_auth_time` datetime NULL DEFAULT NULL COMMENT '第一次授权时间',
`status` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否授权',
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
`version` BIGINT NULL DEFAULT NULL COMMENT '版本控制 ',
`is_deleted` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否删除',
`purchaser_id` BIGINT NULL DEFAULT NULL COMMENT '购买方公司id',
`application_type_id` BIGINT NULL DEFAULT NULL COMMENT '应用类型id',
`device_model_hardware_id` BIGINT NULL DEFAULT NULL COMMENT '设备型号(硬件)id',
`expiration_date` date NULL DEFAULT NULL COMMENT '到期日期',
`license_online_key` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(百度)激活序列号',
`communication_mode` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '应用通信模式 1-HTTP 2-WS 3-serialPort',
`ws_address` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'websocket地址',
`communication_serial_port` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '串口地址serialPort',
`linkage_check_mode` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '联动平台校验模式 1-通用 2-预检查模式',
`use_idcard` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否启用身份证功能 默认：true',
`id_card_reader_brand` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '身份证阅读器品牌 IdCardReaderBrandEnum',
`analysis_photo` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否解析身份证照片 0-关闭 1-开启 默认-1',
`analysis_fingerprint` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否解析身份证指纹 0-关闭 1-开启 默认-0',
`use_person_card` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否人证比对 默认：false',
`use_qrcode` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否启用二维码功能 默认：true',
`id_card_interval` INT NULL DEFAULT 3 COMMENT '同一人刷证间隔时间 取值范围0-20 默认-3',
`qr_code_reader_brand` INT NULL DEFAULT NULL COMMENT '二维码读头品牌 QrCodeReaderBrandEnum',
`qr_code_reader_communication_mode` INT NULL DEFAULT NULL COMMENT '二维码读头通信模式 1-虚拟串口 2-串口serialPort',
`qr_code_reader_serial_port` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二维码读头串口地址serialPort',
`qr_code_interval` INT NULL DEFAULT NULL COMMENT '同码间隔时间 取值范围0-20 默认-7',
`open_delay_time` INT NULL DEFAULT 0 COMMENT '开放刷证/码延时(毫秒)',
`is_open_passport` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启护照机 默认: false',
`manual_in_id_card` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启手动输入证件号 默认false',
`manual_in_id_card_auth` VARCHAR ( 500 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开启手动输入证件号的密钥信息',
`qr_code_use_person_card` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '二维码是否人证比对 默认：false',
`passport_use_person_card` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '护照是否人证比对 默认：false',
`manual_in_use_person_card` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '手动输入证件号是否人证比对 默认：false',
`open_one_to_n` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否开启1:N刷脸能力',
`ic14443_ic_card_function` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是',
`ic14443_reader_brand` INT NULL DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum',
`ic14443_reader_sector_numbers` INT NULL DEFAULT 15 COMMENT 'ic14443-读取扇区-数字；0-99 默认15',
`ic14443_reader_block` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0',
`ic14443_reader_key` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F',
`ic14443_start_offset` INT NULL DEFAULT 0 COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0',
`ic14443_end_offset` INT NULL DEFAULT 0 COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0',
`ic14443_person_card_comparison` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic14443-是否人证比对；false-否（默认） true-是',
`ic14443_same_card_interval_time` INT NULL DEFAULT 7 COMMENT 'ic14443-同卡间隔时间；默认7',
`ic15693_ic_card_function` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是',
`ic15693_reader_brand` INT NULL DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum',
`ic15693_reader_block` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0',
`ic15693_start_offset` INT NULL DEFAULT 0 COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0',
`ic15693_end_offset` INT NULL DEFAULT 0 COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0',
`ic15693_person_card_comparison` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic15693-是否人证比对；false-否（默认） true-是',
`ic15693_same_card_interval_time` INT NULL DEFAULT 7 COMMENT 'ic15693-同卡间隔时间；默认7',
`camera_type` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'IR' COMMENT '摄像头类型 IR-双目  3D-3D结构光 ',
`rgb_video_direction` INT NULL DEFAULT NULL COMMENT '预览画面角度(RGB)',
`mirror_video_rgb` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '预览画面是否镜像(RGB)',
`rgb_detect_direction` INT NULL DEFAULT NULL COMMENT '人脸识别检测角度(RGB)',
`mirror_detect_rgb` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '人脸识别检测是否镜像(RGB)',
`nir_video_direction` INT NULL DEFAULT NULL COMMENT '预览画面角度(NIR)',
`mirror_video_nir` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '预览画面是否镜像(NIR)',
`nir_detect_direction` INT NULL DEFAULT NULL COMMENT '人脸识别检测角度(NIR)',
`mirror_detect_nir` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '人脸识别检测是否镜像(NIR)',
`face_follow_box_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否显示人脸跟随框 默认值true',
`using_best_image` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启最优人脸检测',
`best_image_score` INT NULL DEFAULT 0 COMMENT '人脸阈值：0-100；默认 50',
`quality_control` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启质量检测',
`blur` FLOAT NULL DEFAULT NULL COMMENT '模糊阈值：0-1；默认 0.5 取值范围[0~1]，0是最清晰，1是最模糊',
`illum` FLOAT NULL DEFAULT NULL COMMENT '光照阈值：0-1；默认 0.8 取值范围[0~1], 数值越大，光线越强',
`living_control` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启活体检测',
`live_type` INT NULL DEFAULT NULL COMMENT '活体检测模式',
`rgb_live_score` FLOAT NULL DEFAULT NULL COMMENT 'RGB 可见光活体阈值：0-1；默认 0.8',
`nir_live_score` FLOAT NULL DEFAULT NULL COMMENT 'NIR 近红外活体阈值：0-1；默认 0.8',
`depth_live_score` FLOAT NULL DEFAULT NULL COMMENT 'Depth深度活体阈值(3D结构光)：0-1；默认 0.8 ',
`min_face_size` INT NULL DEFAULT NULL COMMENT '人脸检测最小人脸大小： 1-100; 默认 50',
`one_to_n_score_threshold` FLOAT NULL DEFAULT NULL COMMENT '1:N比对阈值：0-1；默认 0.8',
`one_to_one_score_threshold` FLOAT NULL DEFAULT NULL COMMENT '1:1比对阈值：0-1；默认 0.5',
`one_to_one_continue_fail_time` INT NULL DEFAULT NULL COMMENT '1:1人脸连续未通过秒数：1-50；默认 3',
`one_to_one_timeout` INT NULL DEFAULT NULL COMMENT '1:1人脸比对超时时间：1-50；默认 10',
`one_to_n_fail_show_tip` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '1:N未通过是否显示提示语：是/否；默认 否',
`one_to_n_continue_fail_time` INT NULL DEFAULT NULL COMMENT '1:N人脸连续未通过秒数：1-50；默认 3',
`use_linkage` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用核验接口 默认：true',
`linkage_ads` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联动平台地址',
`check_verify_encrypt_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '核验接口数据是否加解密 默认true',
`check_verify_encrypt_app_key` VARCHAR ( 64 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appKey',
`check_verify_encrypt_app_secret` VARCHAR ( 64 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appSecret',
`check_verify_encrypt_private_key` VARCHAR ( 64 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密privateKey',
`check_verify_retry_times` INT NULL DEFAULT NULL COMMENT '核验接口失败重试次数 默认-1',
`check_verify_timeout_tips` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口超时提示语 默认-核验接口超时',
`check_verify_failed_tips` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口失败提示语 默认-核验接口失败',
`verify_link_timeout` INT NULL DEFAULT NULL COMMENT 'verify核验接口超时时间：15s',
`verify_retry_times` INT NULL DEFAULT NULL COMMENT 'verify核验接口失败重试次数 默认2',
`link_timeout` INT NULL DEFAULT NULL COMMENT '核验接口超时时间：4s',
`special_code_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '启用三要素获取特殊码接口 默认：否',
`special_code_url` VARCHAR ( 500 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口地址',
`special_code_timeout` INT NULL DEFAULT NULL COMMENT '三要素获取特殊码接口超时时间：5s',
`special_code_timeout_tips` VARCHAR ( 64 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口超时提示语 默认-三要素获取特殊码接口请求超时',
`special_code_failed_tips` VARCHAR ( 64 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口失败提示语 默认-三要素获取特殊码接口请求失败',
`special_code_prefix` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '特殊码标识（首位/前缀）',
`user_blacklist_switch` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '开启黑名单 默认：false-否',
`forbid_pass_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否阻止通行 默认：true-是',
`forbid_pass_text` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阻止通行的文本 默认：禁止通行',
`forbid_pass_voice` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阻止通信提示语音 默认：禁止通行，请联系管理员',
`user_blacklist_hit_rule` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '命中条件 IDENTITY_CARD-身份证 PHONE-手机号 默认：勾选身份证',
`user_blacklist_interf_fetch_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用接口拉取 默认：true',
`user_blacklist_interf_url` VARCHAR ( 500 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口拉取地址',
`user_blacklist_encrypt_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '黑名单数据是否加解密 默认true',
`user_blacklist_encrypt_app_key` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appKey',
`user_blacklist_encrypt_app_secret` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appSecrete',
`user_blacklist_encrypt_private_key` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密PrivateKey',
`user_blacklist_offline_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用本地名单 默认false',
`user_blacklist_offline_task_id` text CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '本地名单任务集合',
`websocket_subscribe_url` VARCHAR ( 500 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '人脸管理平台ws地址',
`result_page_template` TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '结果页模版 1-通用版 2-悬浮版',
`compare_silent_display` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '比对失败是否静默显示 false-关闭 true-开启 默认false',
`compare_silent_display_time` INT NULL DEFAULT 2 COMMENT '比对失败静默时长 默认2',
`compare_top_title` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '比对失败顶部文字',
`success_page_time` INT NULL DEFAULT NULL COMMENT '刷脸成功结果页时长 1-10 默认值2',
`fail_page_time` INT NULL DEFAULT NULL COMMENT '刷脸失败结果页时长 1-10 默认值5',
`push_failed_record_type` text CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '推送失败记录类型',
`in_out_filter_repeat_time` INT NULL DEFAULT NULL COMMENT '进出记录滤重时间 默认0 0-120s',
`suc_voice` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成功语音 默认: 请通行',
`suc_text` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成功文字 默认: 请通行',
`fail_voice` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败语音 默认: 比对失败,请联系现场工作人员',
`fail_text` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败文字 默认: 比对失败,请联系现场工作人员',
`show_display_time_by_open_times_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否根据开门次数决定显示时长 false-关闭 true-开启 默认false',
`once_open_door_time` INT NULL DEFAULT NULL COMMENT '单次开门时长 默认2',
`single_page_time` INT NULL DEFAULT NULL COMMENT '默认单选页时长 默认120',
`multi_page_time` INT NULL DEFAULT NULL COMMENT '默认多选页时长 默认120',
`wait_page_time` INT NULL DEFAULT NULL COMMENT '默认等待页时长 默认120',
`one_to_one_tips_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '1:1比对是否显示提醒页面 默认：true',
`one_to_one_tips` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1:1比对提醒文字 默认：请面向屏幕刷脸',
`one_to_one_voice` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1:1比对提醒语音',
`show_top_bar` TINYINT ( 1 ) UNSIGNED ZEROFILL NULL DEFAULT 1 COMMENT '是否显示顶部栏',
`left_top_bar_text` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '顶部栏左边显示内容',
`right_top_bar_text` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '顶部栏右边显示内容',
`use_serial_port` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开门信号: 继电器/RS232 default/RS232 默认：default',
`door_serial_port` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'RS232开门信号串口地址',
`relay_open_model` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '继电器开门模式 1-开-闭信号 2-开-门磁-闭信息',
`door_serial_port_address` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门磁串口地址',
`gate_time_out` INT NULL DEFAULT NULL COMMENT '门磁超时时间（s）',
`light_mode` VARCHAR ( 50 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '补光灯: 自动 auto 默认:auto',
`led_brightness` INT NULL DEFAULT NULL COMMENT '补光灯亮度',
`open_close_interval` INT NULL DEFAULT NULL COMMENT '开闭时间间隔（s）',
`signal_interval` INT NULL DEFAULT NULL COMMENT '信号间间隔（s）',
`heart_tracking_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用状态推送地址',
`transit_push_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进出记录推送地址',
`log_push_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '在线日志推送地址',
`pass_way` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`is_open_age_limit` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启年龄限制',
`limit_section_start` INT NULL DEFAULT NULL COMMENT '限制区间-开始年龄',
`limit_section_end` INT NULL DEFAULT NULL COMMENT '限制区间-结束年龄',
`age_forbid_text` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '禁止进入文本',
`is_push_gm` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否推送门磁信号 默认: false',
`gm_address` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门磁信号推送地址',
`gm_frequency` INT NULL DEFAULT 1000 COMMENT '门磁信号推送频率',
`push_failed_record_switch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否推送失败记录',
`mpassword` VARCHAR ( 100 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备管理员密码',
`volume` INT NULL DEFAULT 80 COMMENT '语音音量 0-100 默认值80',
`hide_navigation_bar` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '隐藏底部导航栏 默认: false',
`forbid_pull_down` TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '禁止下拉通知栏 默认: false',
`auto_launch` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '应用是否自启动 默认: false',
`scheduled_restart` TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否开启定时重启 true-是 false-否 默认-false',
`scheduled_restart_time` time NULL DEFAULT NULL COMMENT '定时重启时间HH:mm:ss',
`home_page_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首页图片配置',
`transition_page_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '过渡页图片配置',
`preview_page_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预览页图片配置',
`scan_face_failed_page_url` VARCHAR ( 255 ) CHARACTER 
SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刷脸失败结果页图片配置',
PRIMARY KEY ( `id` ) USING BTREE,
INDEX `idx_sn` ( `sn` ASC ) USING BTREE

) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'HhLocal设备' ROW_FORMAT = DYNAMIC;

CREATE TABLE hanghui_outapi_platform.hh_local_device_template ( id BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键id', template_name VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模版名称', create_time datetime NULL DEFAULT NULL COMMENT '创建时间', update_time datetime NULL DEFAULT NULL COMMENT '更新时间', version BIGINT NULL DEFAULT NULL COMMENT '版本控制 ', is_deleted TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否删除', application_type_id BIGINT NULL DEFAULT NULL COMMENT '应用类型id', device_model_hardware_id BIGINT NULL DEFAULT NULL COMMENT '设备型号(硬件)id', expiration_date date NULL DEFAULT NULL COMMENT '到期日期', license_online_key VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '(百度)激活序列号', communication_mode TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '应用通信模式 1-HTTP 2-WS 3-serialPort', ws_address VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'websocket地址', communication_serial_port VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '串口地址serialPort', linkage_check_mode TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '联动平台校验模式 1-通用 2-预检查模式', use_idcard TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否启用身份证功能默认：true', id_card_reader_brand TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '身份证阅读器品牌 IdCardReaderBrandEnum', analysis_photo TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否解析身份证照片 0-关闭 1-开启默认-1', analysis_fingerprint TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否解析身份证指纹 0-关闭 1-开启默认-0', use_person_card TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否人证比对默认：false', use_qrcode TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '是否启用二维码功能默认：true', id_card_interval INT NULL DEFAULT 3 COMMENT '同一人刷证间隔时间取值范围0-20 默认-3', qr_code_reader_brand INT NULL DEFAULT NULL COMMENT '二维码读头品牌 QrCodeReaderBrandEnum', qr_code_reader_communication_mode INT NULL DEFAULT NULL COMMENT '二维码读头通信模式 1-虚拟串口 2-串口serialPort', qr_code_reader_serial_port VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '二维码读头串口地址serialPort', qr_code_interval INT NULL DEFAULT NULL COMMENT '同码间隔时间取值范围0-20 默认-7', open_delay_time INT NULL DEFAULT 0 COMMENT '开放刷证/码延时(毫秒)', is_open_passport TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启护照机默认: false', manual_in_id_card TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启手动输入证件号默认false', manual_in_id_card_auth VARCHAR ( 500 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开启手动输入证件号的密钥信息', qr_code_use_person_card TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '二维码是否人证比对默认：false', passport_use_person_card TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '护照是否人证比对默认：false', manual_in_use_person_card TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '手动输入证件号是否人证比对默认：false', open_one_to_n TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否开启1:N刷脸能力', ic14443_ic_card_function TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic14443-是否启用IC卡ISO14443A功能 false-否（默认） true-是', ic14443_reader_brand INT NULL DEFAULT NULL COMMENT 'ic14443-阅读器品牌 ReaderBrandEnum', ic14443_reader_sector_numbers INT NULL DEFAULT 15 COMMENT 'ic14443-读取扇区-数字；0-99 默认15', ic14443_reader_block VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT 'ic14443-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', ic14443_reader_key VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'FFFFFFFFFFFF' COMMENT 'ic14443-读取密钥-填写,默认 FFFFFFFFFFFF 长度100 默认12个F', ic14443_start_offset INT NULL DEFAULT 0 COMMENT 'ic14443-起始偏移量-数字 0-100 默认 0', ic14443_end_offset INT NULL DEFAULT 0 COMMENT 'ic14443-末尾偏移量-数字 0-100 默认 0', ic14443_person_card_comparison TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic14443-是否人证比对；false-否（默认） true-是', ic14443_same_card_interval_time INT NULL DEFAULT 7 COMMENT 'ic14443-同卡间隔时间；默认7', ic15693_ic_card_function TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic15693-是否启用IC卡ISO14443A功能 false-否（默认） true-是', ic15693_reader_brand INT NULL DEFAULT NULL COMMENT 'ic15693-阅读器品牌 ReaderBrandEnum', ic15693_reader_block VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT 'ic15693-读取块-填写,数字逗号隔开 0,1,2,3 长度100 默认0', ic15693_start_offset INT NULL DEFAULT 0 COMMENT 'ic15693-起始偏移量-数字 0-100 默认 0', ic15693_end_offset INT NULL DEFAULT 0 COMMENT 'ic15693-末尾偏移量-数字 0-100 默认 0', ic15693_person_card_comparison TINYINT ( 1 ) NULL DEFAULT 0 COMMENT 'ic15693-是否人证比对；false-否（默认） true-是', ic15693_same_card_interval_time INT NULL DEFAULT 7 COMMENT 'ic15693-同卡间隔时间；默认7', camera_type VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'IR' COMMENT '摄像头类型 IR-双目 3D-3D结构光 ', rgb_video_direction INT NULL DEFAULT NULL COMMENT '预览画面角度(RGB)', mirror_video_rgb TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '预览画面是否镜像(RGB)', rgb_detect_direction INT NULL DEFAULT NULL COMMENT '人脸识别检测角度(RGB)', mirror_detect_rgb TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '人脸识别检测是否镜像(RGB)', nir_video_direction INT NULL DEFAULT NULL COMMENT '预览画面角度(NIR)', mirror_video_nir TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '预览画面是否镜像(NIR)', nir_detect_direction INT NULL DEFAULT NULL COMMENT '人脸识别检测角度(NIR)', mirror_detect_nir TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '人脸识别检测是否镜像(NIR)', face_follow_box_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否显示人脸跟随框默认值true', using_best_image TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启最优人脸检测', best_image_score INT NULL DEFAULT 0 COMMENT '人脸阈值：0-100；默认 50', quality_control TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启质量检测', blur FLOAT NULL DEFAULT NULL COMMENT '模糊阈值：0-1；默认 0.5 取值范围[0~1]，0是最清晰，1是最模糊', illum FLOAT NULL DEFAULT NULL COMMENT '光照阈值：0-1；默认 0.8 取值范围[0~1], 数值越大，光线越强', living_control TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '视频流是否开启活体检测', live_type INT NULL DEFAULT NULL COMMENT '活体检测模式', rgb_live_score FLOAT NULL DEFAULT NULL COMMENT 'RGB 可见光活体阈值：0-1；默认 0.8', nir_live_score FLOAT NULL DEFAULT NULL COMMENT 'NIR 近红外活体阈值：0-1；默认 0.8', depth_live_score FLOAT NULL DEFAULT NULL COMMENT 'Depth深度活体阈值(3D结构光)：0-1；默认 0.8 ', min_face_size INT NULL DEFAULT NULL COMMENT '人脸检测最小人脸大小： 1-100; 默认 50', one_to_n_score_threshold FLOAT NULL DEFAULT NULL COMMENT '1:N比对阈值：0-1；默认 0.8', one_to_one_score_threshold FLOAT NULL DEFAULT NULL COMMENT '1:1比对阈值：0-1；默认 0.5', one_to_one_continue_fail_time INT NULL DEFAULT NULL COMMENT '1:1人脸连续未通过秒数：1-50；默认 3', one_to_one_timeout INT NULL DEFAULT NULL COMMENT '1:1人脸比对超时时间：1-50；默认 10', one_to_n_fail_show_tip TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '1:N未通过是否显示提示语：是/否；默认否', one_to_n_continue_fail_time INT NULL DEFAULT NULL COMMENT '1:N人脸连续未通过秒数：1-50；默认 3', use_linkage TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用核验接口默认：true', linkage_ads VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联动平台地址', check_verify_encrypt_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '核验接口数据是否加解密默认true', check_verify_encrypt_app_key VARCHAR ( 64 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appKey', check_verify_encrypt_app_secret VARCHAR ( 64 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appSecret', check_verify_encrypt_private_key VARCHAR ( 64 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密privateKey', check_verify_retry_times INT NULL DEFAULT NULL COMMENT '核验接口失败重试次数默认-1', check_verify_timeout_tips VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口超时提示语默认-核验接口超时', check_verify_failed_tips VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口失败提示语默认-核验接口失败', verify_link_timeout INT NULL DEFAULT NULL COMMENT 'verify核验接口超时时间：15s', verify_retry_times INT NULL DEFAULT NULL COMMENT 'verify核验接口失败重试次数默认2', link_timeout INT NULL DEFAULT NULL COMMENT '核验接口超时时间：4s', special_code_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '启用三要素获取特殊码接口默认：否', special_code_url VARCHAR ( 500 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口地址', special_code_timeout INT NULL DEFAULT NULL COMMENT '三要素获取特殊码接口超时时间：5s', special_code_timeout_tips VARCHAR ( 64 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口超时提示语默认-三要素获取特殊码接口请求超时', special_code_failed_tips VARCHAR ( 64 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '三要素获取特殊码接口失败提示语默认-三要素获取特殊码接口请求失败', special_code_prefix VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '特殊码标识（首位/前缀）', user_blacklist_switch TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '开启黑名单默认：false-否', forbid_pass_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否阻止通行默认：true-是', forbid_pass_text VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阻止通行的文本默认：禁止通行', forbid_pass_voice VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阻止通信提示语音默认：禁止通行，请联系管理员', user_blacklist_hit_rule VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '命中条件 IDENTITY_CARD-身份证 PHONE-手机号默认：勾选身份证', user_blacklist_interf_fetch_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用接口拉取默认：true', user_blacklist_interf_url VARCHAR ( 500 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接口拉取地址', user_blacklist_encrypt_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '黑名单数据是否加解密默认true', user_blacklist_encrypt_app_key VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appKey', user_blacklist_encrypt_app_secret VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密appSecrete', user_blacklist_encrypt_private_key VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '核验接口数据是否加解密PrivateKey', user_blacklist_offline_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否启用本地名单默认false', user_blacklist_offline_task_id text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '本地名单任务集合', websocket_subscribe_url VARCHAR ( 500 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '人脸管理平台ws地址', result_page_template TINYINT ( 1 ) NULL DEFAULT 1 COMMENT '结果页模版 1-通用版 2-悬浮版', compare_silent_display TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '比对失败是否静默显示 false-关闭 true-开启默认false', compare_silent_display_time INT NULL DEFAULT 2 COMMENT '比对失败静默时长默认2', compare_top_title VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '比对失败顶部文字', success_page_time INT NULL DEFAULT NULL COMMENT '刷脸成功结果页时长 1-10 默认值2', fail_page_time INT NULL DEFAULT NULL COMMENT '刷脸失败结果页时长 1-10 默认值5', push_failed_record_type text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '推送失败记录类型', in_out_filter_repeat_time INT NULL DEFAULT NULL COMMENT '进出记录滤重时间默认0 0-120s', suc_voice VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成功语音默认: 请通行', suc_text VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '成功文字默认: 请通行', fail_voice VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败语音默认: 比对失败,请联系现场工作人员', fail_text VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '失败文字默认: 比对失败,请联系现场工作人员', show_display_time_by_open_times_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否根据开门次数决定显示时长 false-关闭 true-开启默认false', once_open_door_time INT NULL DEFAULT NULL COMMENT '单次开门时长默认2', single_page_time INT NULL DEFAULT NULL COMMENT '默认单选页时长默认120', multi_page_time INT NULL DEFAULT NULL COMMENT '默认多选页时长默认120', wait_page_time INT NULL DEFAULT NULL COMMENT '默认等待页时长默认120', one_to_one_tips_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '1:1比对是否显示提醒页面默认：true', one_to_one_tips VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1:1比对提醒文字默认：请面向屏幕刷脸', one_to_one_voice VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1:1比对提醒语音', show_top_bar TINYINT ( 1 ) UNSIGNED ZEROFILL NULL DEFAULT 1 COMMENT '是否显示顶部栏', left_top_bar_text VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '顶部栏左边显示内容', right_top_bar_text VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '顶部栏右边显示内容', use_serial_port VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '开门信号: 继电器/RS232 default/RS232 默认：default', door_serial_port VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'RS232开门信号串口地址', relay_open_model TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '继电器开门模式 1-开-闭信号 2-开-门磁-闭信息', door_serial_port_address VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门磁串口地址', gate_time_out INT NULL DEFAULT NULL COMMENT '门磁超时时间（s）', light_mode VARCHAR ( 50 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '补光灯: 自动 auto 默认:auto', led_brightness INT NULL DEFAULT NULL COMMENT '补光灯亮度', open_close_interval INT NULL DEFAULT NULL COMMENT '开闭时间间隔（s）', signal_interval INT NULL DEFAULT NULL COMMENT '信号间间隔（s）', heart_tracking_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '应用状态推送地址', transit_push_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '进出记录推送地址', log_push_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '在线日志推送地址', pass_way VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, is_open_age_limit TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否开启年龄限制', limit_section_start INT NULL DEFAULT NULL COMMENT '限制区间-开始年龄', limit_section_end INT NULL DEFAULT NULL COMMENT '限制区间-结束年龄', age_forbid_text VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '禁止进入文本', is_push_gm TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '是否推送门磁信号默认: false', gm_address VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '门磁信号推送地址', gm_frequency INT NULL DEFAULT 1000 COMMENT '门磁信号推送频率', push_failed_record_switch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否推送失败记录', mpassword VARCHAR ( 100 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备管理员密码', volume INT NULL DEFAULT 80 COMMENT '语音音量 0-100 默认值80', hide_navigation_bar TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '隐藏底部导航栏默认: false', forbid_pull_down TINYINT ( 1 ) NULL DEFAULT 0 COMMENT '禁止下拉通知栏默认: false', auto_launch TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '应用是否自启动默认: false', scheduled_restart TINYINT ( 1 ) NULL DEFAULT NULL COMMENT '是否开启定时重启 true-是 false-否默认-false', scheduled_restart_time time NULL DEFAULT NULL COMMENT '定时重启时间HH:mm:ss', home_page_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '首页图片配置', transition_page_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '过渡页图片配置', preview_page_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '预览页图片配置', scan_face_failed_page_url VARCHAR ( 255 ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '刷脸失败结果页图片配置', PRIMARY KEY ( id ) USING BTREE, INDEX idx_template_name ( template_name ASC ) USING BTREE ) ENGINE = INNODB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'HhLocal设备模版' ROW_FORMAT = DYNAMIC;

ALTER TABLE hanghui_outapi_platform.device ADD COLUMN scan_face_failed_page_url varchar(255) NULL COMMENT '刷脸失败结果页图片配置' AFTER in_out_filter_repeat_time; ALTER TABLE hanghui_outapi_platform.device_template ADD COLUMN scan_face_failed_page_url varchar(255) NULL COMMENT '刷脸失败结果页图片配置' AFTER in_out_filter_repeat_time;

访客机 visitReason 拜访事由

ALTER TABLE hanghui_outapi_platform.fkj_device ADD COLUMN confirm_countdown_switch tinyint(1) NULL COMMENT '是否启用确定倒计时' AFTER visit_reason, ADD COLUMN confirm_countdown_time bigint NULL COMMENT '确定倒计时时长（s）' AFTER confirm_countdown_switch, ADD COLUMN secondary_page_switch tinyint(1) NULL COMMENT '是否启用副屏轮播图' AFTER confirm_countdown_time, ADD COLUMN secondary_page_images text NULL COMMENT '副屏轮播图' AFTER secondary_page_switch, ADD COLUMN processing_page_image varchar(500) NULL COMMENT '副屏处理中页面图片' AFTER secondary_page_images;

ALTER TABLE hanghui_outapi_platform.fkj_device_template ADD COLUMN confirm_countdown_switch tinyint(1) NULL COMMENT '是否启用确定倒计时' AFTER visit_reason, ADD COLUMN confirm_countdown_time bigint NULL COMMENT '确定倒计时时长（s）' AFTER confirm_countdown_switch, ADD COLUMN secondary_page_switch tinyint(1) NULL COMMENT '是否启用副屏轮播图' AFTER confirm_countdown_time, ADD COLUMN secondary_page_images text NULL COMMENT '副屏轮播图' AFTER secondary_page_switch, ADD COLUMN processing_page_image varchar(500) NULL COMMENT '副屏处理中页面图片' AFTER secondary_page_images;

ALTER TABLE hanghui_outapi_platform.fkj_device ADD COLUMN reminder_play_text varchar(100) NULL COMMENT '提示标语播报文本' AFTER processing_page_image; ALTER TABLE hanghui_outapi_platform.fkj_device_template ADD COLUMN reminder_play_text varchar(100) NULL COMMENT '提示标语播报文本' AFTER processing_page_image;

ALTER TABLE hanghui_outapi_platform.hh_local_device ADD COLUMN rgb_revert tinyint(1) NULL COMMENT '人脸框跟随框是否镜像' AFTER scan_face_failed_page_url; ALTER TABLE hanghui_outapi_platform.hh_local_device_template ADD COLUMN rgb_revert tinyint(1) NULL COMMENT '人脸框跟随框是否镜像' AFTER scan_face_failed_page_url;

ALTER TABLE fkj_device add processing_page_switch tinyint(1) DEFAULT '0' COMMENT '是否启用副屏处理中页面' AFTER secondary_page_images; ALTER TABLE fkj_device_template add processing_page_switch tinyint(1) DEFAULT '0' COMMENT '是否启用副屏处理中页面' AFTER secondary_page_images;

ALTER TABLE hanghui_outapi_platform.device ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true' AFTER scan_face_failed_page_url, ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

ALTER TABLE hanghui_outapi_platform.device_template ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true', ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

ALTER TABLE hanghui_outapi_platform.hh_local_device ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true', ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

ALTER TABLE hanghui_outapi_platform.hh_local_device_template ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true', ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

ALTER TABLE hanghui_outapi_platform.fkj_device ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true', ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

ALTER TABLE hanghui_outapi_platform.fkj_device_template ADD COLUMN transit_push_switch tinyint(1) NULL DEFAULT 1 COMMENT '启用进出记录推送默认: true', ADD COLUMN transit_push_encrypt_switch tinyint(1) NULL DEFAULT 0 COMMENT '进出记录推送数据是否加解密默认false' AFTER transit_push_switch, ADD COLUMN transit_push_encrypt_app_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密appKey' AFTER transit_push_encrypt_switch, ADD COLUMN transit_push_encrypt_app_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密appSecrete' AFTER transit_push_encrypt_app_key, ADD COLUMN transit_push_encrypt_private_secret varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_app_secret, ADD COLUMN transit_push_encrypt_private_key varchar(100) NULL COMMENT '进出记录推送数据是否加解密PrivateKey' AFTER transit_push_encrypt_private_secret;

sql.md 78 KB Istoric Crud

sql

sql.md 78 KB

Istoric Crud